|
|
Dear Erman,
Env:
Db version 19c
R12.2.5
We have a concurrent program which calls below control file. This file was not changed recently. All of the sudden the program was failed and
when we look into control file,one of the field "request id" shown below is changed.
[applprod@app bin]$ cat XXTTD_AP_HRMAPS_INTERFACE_V2.ctl
options(skip=1)
load data
infile '$FILEPATH'
append
INTO TABLE xxttd.XXTTD_AP_HRMAPS_VIEW_DATA_V2
fields terminated by ','
Optionally enclosed by '"'
TRAILING NULLCOLS
(INSTITUTION_CODE "trim(:INSTITUTION_CODE)",
BILL_TYPE "trim(:BILL_TYPE)",
PAYBILL_NUM "trim(:PAYBILL_NUM)",
INVOICE_DATE "to_char(TO_DATE(:INVOICE_DATE,'DD/MM/YY'),'DD-MON-YY')",
GL_DATE "to_char(TO_DATE(:GL_DATE,'DD/MM/YY'),'DD-MON-YY')",
INVOICE_TYPE "trim(:INVOICE_TYPE)",
SUPPLIER_NUMBER "trim(:SUPPLIER_NUMBER)",
SUPPLIER_SITE "trim(:SUPPLIER_SITE)",
AMOUNT "replace(trim(:AMOUNT),',','')",
DESCRIPTION "trim(:DESCRIPTION)",
SEGMENT1 "trim(:SEGMENT1)",
SEGMENT2 "trim(:SEGMENT2)",
SEGMENT3 "trim(:SEGMENT3)",
SEGMENT4 "trim(:SEGMENT4)",
SEGMENT5 "trim(:SEGMENT5)",
SEGMENT6 "trim(:SEGMENT6)",
SEGMENT7 "trim(:SEGMENT7)",
SEGMENT8 "trim(:SEGMENT8)",
SEGMENT9 "trim(:SEGMENT9)",
NET_PAYABLE_AMOUNT "trim(:NET_PAYABLE_AMOUNT)",
EMPLOYEE_NO "trim(:EMPLOYEE_NO)",
EMPLOYEE_NAME "trim(:EMPLOYEE_NAME)",
BENEFICIARY_BANK_NAME "trim(:BENEFICIARY_BANK_NAME)",
BENEFICIARY_BANK_BRANCH "trim(:BENEFICIARY_BANK_BRANCH)",
BENEFICIARY_ACCOUNT_NUMBER "trim(:BENEFICIARY_ACCOUNT_NUMBER)",
BENEFICIARY_IFSC_CODE "trim(:BENEFICIARY_IFSC_CODE)",
CONTACT_NUMBER "trim(:CONTACT_NUMBER)",
EMAIL_ID "trim(:EMAIL_ID)",
WFAPPROVAL_STATUS "trim(:WFAPPROVAL_STATUS)",
HEADER_STATUS "decode(:HEADER_STATUS,null, 'N', :HEADER_STATUS)",
LINE_STATUS "decode(:HEADER_STATUS,null, 'N', :HEADER_STATUS)",
EMPLOYEE_STATUS "decode(:HEADER_STATUS,null, 'N', :HEADER_STATUS)",
CREATION_DATE sysdate,
LAST_UPDATE_DATE sysdate ,
CREATED_BY "P_USER",
LAST_UPDATED_BY "P_USER",
REQUEST_ID "P_REQUEST_ID",-------------------------->This was changed to 33P_USERP_USER8472
CSV_FILE_NAME ,
PROGRAM_ID "fnd_global.conc_program_id",
ERROR_MESSAGE ,
DIST_CODE_COMBINATION_ID
)[applprod@erpprodapp01 bin]$
Original:
REQUEST_ID "P_REQUEST_ID"
Changed:
REQUEST_ID 33P_USERP_USER8472---It should be as above.
Can you suggest what went wrong?
Thank you
|
Locked
