Sunday, October 22, 2017

Mandatory Parameters of Procedure

1. ERRBUF 2. RETCODE
ERRBUF is used to return messages in log file
RETCODE is used to show the status of the concurrent program

RETOCDE have 3 values 0, 1 & 2
 0 indicates concurrent program completed with Normal
 1 indicates concurrent program completed with Warning
 2 indicates concurrent program completed with Error

No comments:

Post a Comment

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...