Below script is useful in finding On hand quantity accurately using Oracle Standard API INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES. This script is tested in R12.1.3 instance. 1 2 3… Read More »API approach to find On Hand Quantity of an Item
Available to Transact = Quantity already reserved and ready to transact Available to Reserve = (Total Quantity in Reservable Subinventory) – (Total Quantity of the… Read More »What is the Difference between Available to Reserve & Available to Transact
Before understanding about BULK COLLECT, lets see how a PL/SQL code is executed. Oracle uses two engines to process PL/SQL code. All procedural code is… Read More »What is BULK COLLECT? How and Why do we need to use it?
Click on the question to see the answer How to display 9th record from EMP table? HOW TO DISPLAY 5 TO 7 ROWS FROM A… Read More »Frequently asked SQL Interview Questions on EMP, DEPT table
Click on the question to see the answer Basic PL/SQL Interview Questions Difference between Syntax and Runtime errors in PL/SQL?? Explain what is… Read More »Top PL/SQL Interview Questions with Answers
Yes! We all know that cannot use SQLCODE, SQLERRM in INSERT Statement! but why?? SQLCODE, SQLERRM are predefined functions which are useful in Exception handling.… Read More »Why cant we use SQLERRM and SQLCODE in INSERT Statement?
We can find values of System global values using FND_PROFILE and FND_GLOBAL FND_PROFILE To manipulate values stored in client and server user profile caches.Any changes… Read More »FND_GLOBAL and FND_PROFILE: Import List of System Global values
Click on the question to see the answer What is XML Publisher? What is the difference between XML publisher and BI Publisher? What… Read More »XML Publisher Interview Questions with Answers
AIM (Application Implementation Methodology) Documents Oracle A.I.M. Methodology encompasses a project management methodology with documentation templates that support the life cycle of an implementation. The… Read More »MD50, MD70 and MD120 Templates – Free Download
We can use the same fnd_request.submit_request API which we use to submit a program for scheduling a program too. The only difference is the value… Read More »How to Schedule a concurrent program from Backend