Introduction This Post illustrates the steps required to extract Goods Received Date for Suppliers along with Invoice and PO Information in Oracle EBS R12. Query select (select hou.name from apps.hr_operating_units…
Read MoreIntroduction This Post illustrates steps required to get Oracle i-expense Line attachments in Oracle EBS R12. Query SELECT fl.* FROM apps.fnd_documents_tl fdtl, apps.fnd_documents fd, apps.fnd_attached_documents fad, apps.fnd_lobs fl WHERE fdtl.document_id…
Read MoreIntroduction This Post illustrates the steps required to get Project Listing Query in Oracle EBS R12. Script to get Project Listing Query SELECT pt.project_id, ppa.NAME project_name, ppa.description project_description, ppa.segment1 project_number,…
Read MoreIntroduction This Post illustrate steps required to Import CRM Resource in Oracle EBS R12. Script to Import CRM Resource DECLARE l_jtf_person_id NUMBER; /*Assign Value*/ l_jtf_user_id NUMBER; /*Assign Value*/ l_user_name VARCHAR2…
Read MoreIntroduction This Post described Suppliers Report (XML) is used to review the supplier, supplier site, and supplier contact details. 1.Query Fetching Vendor Details: SELECT p.vendor_id c_vendor_id, p.segment1 c_vendor_number, p.vendor_name c_vendor_name,…
Read MoreIntroduction Oracle General Ledger Trial Balance report is used to satisfy legal, statutory, and internal management reporting requirements in Portugal. There are five separate reports with a standard layout; however,…
Read MoreIntroduction Uninvoiced Receipts report is designed to provide a preview of all accrual entries that will be posted to your account in a specific month. Script to Uninvoiced Receipts Report…
Read MoreIntroduction This Post illustrates steps required to using the below code In load file “button” using “when-button-pressed” trigger. DECLARE l_userhome VARCHAR2 (200) := webutil_clientinfo.get_system_property (‘user.home’) || ‘\Desktop’; l_filename VARCHAR2…
Read MoreIntroduction This Post illustrates steps required to Vendor Ledger Report Query in Oracle EBS R12. Script to Vendor Ledger Report Query SELECT flag, vendor_num, vendor_name, vendor_site_id, vendor_site_code, state_code, project_code, transaction_type,…
Read MoreIntroduction This Post illustrates steps required to Calling One Form from another Form using Personalization in Oracle EBS R12. Step 1 Open the main form you want to personalize and…
Read More