Payables and Cash Management - EBS (MOSC)

MOSC Banner

SQL Loader control file issue bank statements

edited Aug 20, 2021 7:48AM in Payables and Cash Management - EBS (MOSC) 1 commentAnswered

Hi


I am setting up system for FNB Bank statement loading. I have a data file which has different record id's as follows for example:

:20:620132679330204

:25:62013267933

:28C:28103/5

:60F:C201231ZAR1000,00

:61:210102D10,00FCHGTISH   763184*012

:86:MAGTAPE DEBIT USER PP55 SEQ 000324

:62F:C210130ZAR900,00


I am building the sql loader control file and for rec id's 20, 25, 28C, 62F & 86 I am not facing any issues and have successfully been able to load the records correctly into the different columns in the CE_STMT_INT_TMP table.

However for record 61 which stores the trx date, the D or C indentification, the amount, and other pertinent information I am battling to split the data into various columns...

Tagged:

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

EBS Payables Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center