–The query inputs the Item ID, organization ID and date. SELECT SUM (target_qty), item_id FROM ( SELECT moqv.subinventory_code subinv, moqv.inventory_item_id item_id, SUM (transaction_quantity) target_qty […]
CURSOR : A cursors is a pointer used to fetch rows from a result set Two types of classification s:I.STATIC CURSOR S: Static : Normal cursor (implicit or explicit)Cursor attributes for implicit and explicit:%FOUND – records fetched successfully%NOTFOUND – no records fetched%ROWCOUNT – Number of records fetched%ISOPEN – returns TRUE if cursor is opena. Implicit : Cannot be […]
We usually use cursor for loops to process data.(i.e declare a cursor, open it, fetch from it row by row in a loop and process the row they fetch) statements in plsql programs causes a context switch between the plsql engine and the sql engine.Too many context switches may degrade performance dramatically. In order to […]
Pre-requisites : Step1: Data Definition and Template to be created Step2: Concurrent program needs to be created Steps To Create the PL/SQL package: 1. Initialize the Session Specific variable using fnd_global.APPS_INITIALIZE 2. Set The BI publisher report layout Before submitting the concurrent program 3. Submit the Concurrent Program Code: (Tested in R12.1.1 ) DECLARE l_user_id […]
For each Concurrent program we must use mandatory parameters : ERRBUF and RETCODE.ERRBUF: It return the error message. For you program if you get any error in exception block you can assign the error message to this parameter. This error message you can see after concurrent program run go to details button it will open details in that […]
Recent Comments