Oracle Apps Technical Stuff

Friday, November 10, 2017

What are the Meaning of the Codes in the STATUS_CODE and PHASE_CODE Columns of FND_CONCURRENT_REQUESTS Table?

›
                                      Status Code Meaning A Waiting B Resuming ...
Thursday, November 9, 2017

Meaning of LSE_ID in Oracle Service contract

›
LSE_ID Usage (Meaning ) 1 Service                                   2 Coverage   ...
Friday, October 13, 2017

PURGE_QUEUE_TABLE

›
This procedure purges messages from queue tables. You can perform various purge operations on both single-consumer and multi consumer que...
Sunday, October 8, 2017

Sample script to update the Item attributes (Inventory)

›
DECLARE    CURSOR c1    IS       SELECT inventory_item_id            , segment1         FROM mtl_system_items_b        WHERE organiza...
Wednesday, October 4, 2017

Script to create New Item copying existing SKU, it's attributes and all categories and also Assign it to all Inventory Organization.

›
Please test the script first in NON PROD instance. DECLARE    k                                            NUMBER;    l_api_version    ...
‹
›
Home
View web version

About Me

Vijaykumar G
View my complete profile
Powered by Blogger.