Payables and Cash Management - EBS (MOSC)

MOSC Banner

Reconciling Bank Statements Daily using Same Bank Statement Number

edited Aug 19, 2021 7:51PM in Payables and Cash Management - EBS (MOSC) 1 commentAnswered
 Hello,

A custom SQL loader program has been developed to load bank statements for our different bank accounts (AR, AP and Payroll). 

The custom loader program loads the data into the Header and Lines interface table. The issue encountered is when trying to import and reconcile bank statements on a daily basis using the same bank statement number. 

The bank statement number is made up MMDD and ACCOUNT#.  For example on the 1st business day of the Month the first set of Bank statements for each account are loaded, imported and reconciled. On the second day, a new set of bank statements are downloaded from the bank and loaded in the CM.  It is during the Import and reconciliation that the error 'The statement Line exits' occurs.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center