Introduction This Post is about to Update Customer Account in TCA R12. Script to Update Customer account in TCA R12. DECLARE p_cust_account_rec HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE; p_object_version_number NUMBER; x_return_status …
Read MoreIntroduction This Post is about to Report Will Fetch All VAT details in the AP Module in Oracle EBS-R12. <dataTemplate name=”IRNGLBFRTVAAP” version=”1.0″> <parameters> <parameter name=”P_ACCT_FROM_DT” dataType=”DATE”/> <parameter name=”P_ACCT_TO_DT” dataType=”DATE”/>…
Read MoreIntroduction This Post illustrates the steps required to Extract the employee data based on business group in Oracle EBS R12 Script to Employee data extraction based on business group SELECT hou.name business_unit,…
Read MoreIntroduction This Post illustrates the steps required to PO Blanket details along with receipt and Indian tax details in Oracle EBS R12. Script to PO Blanket details along with…
Read MoreIntroduction This Post illustrates steps required to get Oracle i-expense Line attachments in Oracle EBS R12. SELECT fl.* FROM apps.fnd_documents_tl fdtl, apps.fnd_documents …
Read MoreIntroduction This Post is about to Receivables to GL Link in 11i. SELECT je_header_id, line_number, trx_number, myrank, item_number,customer_number, customer_name, SOURCE, CATEGORY, batch_name,transaction_date, posted_date, period_name, currency_code,account_number, description, CASE WHEN my…
Read MoreIntroduction This Post illustrates the steps required Function to calculate Item Cost in Oracle EBS R12. Script to Function to calculate Item Cost. CREATE OR REPLACE FUNCTION XXTTK_ITEM_COST (P_INV_ITEM_ID IN…
Read MoreIntroduction This Post illustrates the steps required to get Detail Customer Information query in Oracle EBS R12. Script to get Detail Customer Information. SELECT DISTINCT hp.party_name “Customer Name”, hca.account_number,…
Read MoreIntroduction This Post is about to Get Employee Supervisor Relationships Query in oracle R12. Query to Get Employee Supervisor Relationships. SELECT DISTINCT LPAD(‘ ‘,5*(LEVEL-1)) || PPF.FULL_NAME, PERA.SUPERVISOR_ID, PERA.PERSON_ID, PER_JOBS.NAME JobName,…
Read More