Payables and Cash Management - EBS (MOSC)

MOSC Banner

Loading Bank statement with 44 and 54 code lines

edited Aug 20, 2021 8:46AM in Payables and Cash Management - EBS (MOSC) 3 commentsAnswered

Hello,

We are running into difficulties loading bank statements for one of our banks.

The bank states in their spec:

'Each file contains mixed credit and debit transactions in date order. Control total records (transaction code 44 and 54) appear at change of date, indicating the value of all daily debit and credit transactions. These credit and debit total records will always be present, regardless of the type of records on the file.'

These daily credit and debit totals are causing us an issue in our upload process.

We were originally stripping out any code 44 or 54 lines during the SQL Loader process so that they were not being loaded but the problem is that their total values are included in the UTL line control totals.

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