Add Row on the Top in the APEX Tabular Form
Description: Query explains how to add row on the top in the APEX…
Read MoreASSET DEPRECIATION LOGIC QUERY
Description: Oracle Assets calculates depreciation using either the recoverable cost or the recoverable net book value as a basis. If the depreciation method uses the asset cost, Oracle Assets calculates…
Read MoreScript for Extracting InterCompany batch details
Introduction This Post illustrates steps required to Extracting InterCompany batch details in Oracle EBS R12. Extracting InterCompany batch details Query SELECT DISTINCT xep.NAME provider, ftb.status batch_status, ftb.batch_number batch_number, ftb.description batch_description,…
Read MoreScript for getting PO SLA Details
Introduction This Post illustrates steps required to getting PO SLA Details in Oracle EBS R12. Script to getting PO SLA Details SELECT DISTINCT pap.last_name || ‘, ‘ || pap.first_name AS…
Read MoreScript for getting Sales Tax Transactions
Introduction This Post illustrates the steps required to getting Sales Tax Transactions Query in Oracle EBS R12. Script to getting Sales Tax Transactions Query SELECT DISTINCT aia.invoice_date transaction_date, aia.invoice_num transaction_number,…
Read MoreScript to add employee as buyer
Introduction This Post illustrate steps required to add employee as buyer in Oracle EBS R12. Script to add employees as buyer DECLARE l_agent_id NUMBER; l_employee_number VARCHAR2 (20); l_buyer_rowid VARCHAR2 (100);…
Read MoreScript to Assign Salesrep Role in CRM
Introduction This Post Is About to Script to Assign Salesrep Role in CRM in Oracle. DECLARE l_jtf_person_id NUMBER; /*Assign Value*/ lc_resource_id jtf_rs_resource_extns.resource_id%TYPE; ln_role_id NUMBER; lc_role_code VARCHAR2 (200); l_return_status VARCHAR2 (1);…
Read MoreScript to extract Expenses SLA Details
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 MoreScript to extract Goods Received Date for Suppliers along with Invoice and PO Information
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 MoreScript to get Oracle i-expense Line attachments
Introduction 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 More