Not 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 MoreOrcale EBS-Query to get active users along with their active responsibilities
LIST OF ALL ACTIVE USERS ALONG WITH THEIR ACTIVE RESPONSIBILITIES Introduction: This query is used to get all active users along with their active responsibilities. SQL Query: Execute the…
Read MoreOracle EBS-Query to get Service Contract Details
Query to get the Service Contract Details Introduction: This query is used to fetch the service contract details.In this we will be passing contract_number as the parameter. SQL Query:…
Read MoreUnable To Add Vendor in Threshold Exception Setup
Introduction: Information in this document applies to any platform. Oracle Financials for India – Version 12.1.1 and later Vendor not showing up in LOV (List of Values) while performing Exception…
Read More