Journals Uploaded Twice into Oracle Apps r12
Introduction/ 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 MoreAuto Reversal Journals Setup -Fusion
Introduction/ 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 MoreItem Where-Used Analysis Report (Excel – PL/SQL)
Introduction: 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 MoreNot able to submit the Print statement in AR
Issue :- 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 MoreNeed to delete the incorrect receipt entry from Account receivables
Introduction/ 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 MoreOracle PLSQL to Generate XML Tag Using Standard Functionality
declare 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 MorePurchase Invoice GL to AP Drill down for Account Analysis Reconciliation
Introduction: 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 MoreAP: Create Accounting Completed In Warning with Offsets Error
Issue 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 MoreFixed Asset- Split Transaction
Introduction/ Issue In this document we shall see how to perform SPLIT in Fixed asset Split Divide an asset into separate units. Use the Split Assets routine to divide an…
Read MoreHow To Achieve Serial Approval Between The Groups And First Responder Wins Within A Group
We have 2 Approval Groups Approval Group-1 – Parallel Approval with First Responder Wins Employee-A Employee-B Approval Group-2 – Parallel Approval with First Responder Wins Employee-C Employee-D Requirement: When the…
Read More