Introduction This Post illustrate steps required to extract Expenses SLA Details in Oracle EBS R12. Query to extract Expenses SLA Details SELECT aerh.invoice_num “Report_Number”, papf.full_name “Employee_Name”, papf.employee_number “Emp_Number”, hou.NAME “Operating_Unit”,…
Read MoreIntroduction 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 More