Payables and Cash Management - EBS (MOSC)

MOSC Banner

Values loaded in BANK_TRX_NUMBER are truncated

edited Aug 19, 2021 8:22PM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered
Hi!

I loaded and import a statement bank, but when I review the lines imported, the values in
BANK_TRX_NUMBER (number column) in the Bank Statement Lines form, has 12 digits instead of 13. How can I correct this?

.ctl file
--------------------------------------------
LOAD DATA
REPLACE

INTO TABLE ce_stmt_int_tmp
WHEN (01) = 'H'

TRAILING NULLCOLS
(rec_no            RECNUM,
 rec_id_no        CONSTANT '0',
 column1         POSITION(02:12)  CHAR,
 column2         POSITION(13:20)  CHAR,
 column3         POSITION(21:26)  CHAR)
 
 
INTO TABLE ce_stmt_int_tmp
WHEN (01) <> 'H'
TRAILING NULLCOLS

(rec_no        RECNUM,
 rec_id_no    CONSTANT '1' ,
 column1      POSITION(01:11)    CHAR,
 column2      POSITION(12:19)    CHAR,
 column3     POSITION(20:35)    CHAR,

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