Description: Construction units are defined at the organization level, and can include only those activities that are assigned to the same inventory organization. However, you can query construction units associated…
Read MoreDescription: Oracle Enterprise Asset Management provides several open interfaces and APIs, enabling you to link with non-Oracle applications, applications you build, and applications on other computers. API used to maintain…
Read MoreDescription: Failure Analysis enables you to track an asset failure from the time it is reported until its resolution. Statistics from your collected failure data provide you with information on…
Read MoreDescription: A capital project, defined as any project which requires capital flows for completion, usually refers to a project which requires large sums of capital. Purpose of this report is to display Project…
Read MoreDescription: 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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction 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 More