Certain AR Interface records are not being processed by our Custom program
Hi All,
We are on Ebs 12.2.4
Our business scenario:- After shipping is done in OM, Workflow background process pushes the concerned records to AR interface.
In AR, we have a request set:-
Child program 1:- AR Preprocessor program - Based on some business rules, this program updates certain fields in AR interface (like Ship to, payment terms, DFF etc...)
Child Program 2:- Auto invoice import - After the data being massaged by child program 1, this program imports the data into AR.
Practical problem:- Our AR request set is scheduled daily to run at 1 AM. Let us assume that at 1 AM, there are say 1000 records in AR interface table. Now when the AR request set start running, first child program starts at 1 AM and it takes around 1 hr to complete. So, roughly at 2 AM, this program completes. Auto invoice import program (Which is child program 2) starts at 2 AM. But between 1 AM and 2 AM, let us assume that there are 50 sales orders which are shipped, those records gets pushed to AR interface