Mass Inventory Category Cleanup Using Oracle Inventory API In large Oracle E-Business Suite (EBS) implementations, item categories often become inconsistent over time due to data migrations, manual corrections, or changes…
Read MoreCreating a BOM Item Creating a Bill of Materials (BOM) item in Oracle Apps R12 involves defining the parent assembly and its components within the Bills of Material module, ensuring prerequisites like items…
Read MoreIntroduction/ Issue: The Same details Journals Uploaded Twice into Oracle. Why We need to do / Cause of the Issue: User was uploaded the same GL File Twice into Oracle.…
Read MoreIntroduction/ Issue: How to define Auto reversal journal setup Purpose of Auto Reversal: Auto Reversal in Oracle Fusion is used to automatically reverse journal entries that need to be cancelled…
Read MoreIntroduction: This blog has the SQL query that can be used for Item where used Report in Oracle Apps R12. Cause of the issue: Business wants a PLSQL excel based report…
Read MoreIssue :- Not able to submit the Print statement in AR Cause of the issue: Statement Periods are not defined for the New Year. How do we solve: We need…
Read MoreIntroduction/ Issue: Need to delete the incorrect receipt entry from Account receivables User has mistakenly made Receipt entry by selecting wrong customer now they need to delete the incorrect receipt…
Read Moredeclare l_ctx dbms_xmlquery.ctxHandle; l_clob clob; begin l_ctx := dbms_xmlquery.newContext(‘select * from <TABLE_NAME>’); dbms_lob.createtemporary(:g_clob,true,dbms_lob.session); :g_clob := dbms_xmlquery.getXml(l_ctx); end;
Read MoreIntroduction: This document outlines how to reconcile Oracle General Ledger (GL) and Oracle Payables (AP) for Purchase Invoice analysis by using a specific SQL script to drill down to the…
Read MoreIssue Overview: The error “The accounting program cannot create this journal line because the debit or credit that offsets it cannot be found” occurs when attempting to run the Create…
Read More