Oracle Apps Technical Stuff
Monday, March 30, 2015
Logic for BOM Implosion using bompimpl.imploder_userexit API
›
DECLARE i INTEGER; l_next_seq_num NUMBER; l_err_msg VARCHAR2 (2000)...
1 comment:
Friday, February 20, 2015
Script to Get the Sales Order Total Amount in Oracle Order Managment
›
DECLARE p_header_id NUMBER := 1084842; p_subtotal NUMBER; p_discount NUMBE...
Monday, January 26, 2015
Script to Create Excel using UTL_FILE
›
DECLARE v_fh UTL_FILE.file_type; v_dir VARCHAR2 (30) := 'XX_INTF_DIR'; v_...
Friday, January 9, 2015
Script to Create New FND_USER and Assign Responsilities and also Update/Create Profile For ICX_FORMS_LAUNCHER
›
------------------------------------------------------------------------------------------------ -- Replace the Value for l_user_name for c...
1 comment:
Thursday, December 4, 2014
SQL query to get the details of Scheduled Concurrent Requests in Oracle applications
›
SELECT r.request_id , p.user_concurrent_program_name || NVL2 (r.description , ' (' ...
‹
›
Home
View web version