Payables and Cash Management - EBS (MOSC)

MOSC Banner

How to default currency code in control file

I have the need to default the value of 'ZAR' in my control file for bank statement loading as the current bank statements do not carry the currency code. With R12.2 this is now a requirement.

How can I change my control file to cater for this and what changes must be made to my setup.

This is the current control file:

LOAD DATA

REPLACE

into table ce_stmt_int_tmp
fields terminated by ","TRAILING NULLCOLS
(rec_no RECNUM,
rec_id_no "decode(:rec_no ,1,'0001',2,'0002',3,'0003',DECODE(:column2,'CLOSE ','0009','0036'))",
column1 "decode(:rec_no,2,:column1, ltrim(:column1,'0'))",

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