Control file - concurrent program

Posted by satish on Aug 01, 2023; 2:15pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Control-file-concurrent-program-tp12003.html

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