Tuesday, September 17, 2019

How to set custom top to AR Lock box CTL File instead of AR TOP?

Auto Lock box is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing.

Auto lock box eliminates manual data entry by automatically Processing receipts that are sent directly to your bank.

in order to load the bank files through oracle standard lock box process, oracle recommends only to keep that standard control file in $AR_TOP/12.0.0/BIN folder , but when we have custom control files , oracle will not suggest to keep it in  $AR_TOP/12.0.0/BIN  folder , because when DBA's do any patch update all custom files will go off.  solution where we can place custom control file in CUSTOM_TOP/12.0.0/BIN.

when we are passing a parameter value for a control file , if we give any control file name , program will search for given control file name directly in $AR_TOP/12.0.0/BIN so we need to divert to CUSTOM_TOP/12.0.0/BIN/Control_File_Name as per below screenshot.



No comments:

Post a Comment

AME (Approval Management Engine)

AME (Approval Management Engine) : AME Stands for Oracle Approval Management Engine. AME is a self service web application that enables...