Hi all,
I am inserting data into the below table through the concurrent program in oracle apps R12
Options(errors=10000,skip=3)
LOAD DATA
REPLACE
INTO TABLE sampl_table
fields terminated by ','
optionally enclosed by '"'
trailing nullcols
(
valid_amount_month1 "to_number(:valid_amount_month1 , '999,999,999.99')" ,
valid_code CHAR NULLIF valid_code = BLANKS "RTRIM(:valid_code )",
valid_rate CHAR NULLIF valid_rate = BLANKS "RTRIM(:valid_rate)"
)
valid_code and valid_rate is new columns to the ctrl file
In the Log File
Table sampl_table, loaded from every logical record.
Insert option in effect for this table: REPLACE
TRAILING NULLCOLS option in effect
value used for ROWS parameter changed from 34 to 11
Record 1: Rejected - Error on table sampl_table, column valid_amount_month1.
ORA-01722: invalid number
Thanks
Message was edited by: 994122 Changed valid_month1 as valid_amount_month1 in the main post body