Payables and Cash Management - EBS (MOSC)

MOSC Banner

SQL*Loader-503: Error appending extension to file Additional information: 7217

edited Aug 20, 2021 7:38AM in Payables and Cash Management - EBS (MOSC) 5 commentsAnswered

Hello ,

The SQL loader for the bank loader program is working fine in all instance except one and displaying the above error in that particular instance.

Can anybody suggest anything regarding this error as its urgent. The control file details are below:

--

--  $Header: ATC_COL_CITIBANK.ctl 12.1 1:50 PM 03/28/2012 Apps Associates $       |

--

LOAD DATA

REPLACE

INTO TABLE ce_stmt_int_tmp

FIELDS TERMINATED BY '|'

TRAILING NULLCOLS

(rec_no RECNUM,

rec_id_no "ltrim(rtrim(:rec_id_no))",

column1 "ltrim(rtrim(:column1))",

column2   "ltrim(rtrim(:column2))",

column3   "ltrim(rtrim(:column3))",

column4 "ltrim(rtrim(:column4))",

--column5   "ltrim(rtrim(:column5))",

column5      "ltrim(rtrim(REGEXP_REPLACE(:column5 , '[^a-zA-Z0-9~`!

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