How to extract Oracle payments to HCM Payroll

Hi Experts,

I am working on Oracle Incentive Compensation (CN) – Extract Payments process, and I’m facing an issue while populating the staging table CN_PAY_EXTRACT_STAGING_ALL.

Issue: During execution of the process, I encounter the following error:

Exception in populate_staging_table :-1006 : ORA-01006: bind variable does not exist

Context

The dynamic SQL generated looks like this:

INSERT INTO CN_PAY_EXTRACT_STAGING_ALL (  AMOUNT,  LEGISLATIVE_DATA_GROUP,  ORG_ID,  PARTICIPANT_ID,  PAYRUN_ID,  PAY_DATE,  PAY_ELEMENT,  PAY_PERIOD_ID,  WORKER_ID,  payment_extract_staging_id,  parent_job_id,  creation_date,  created_by,  last_update_date,  last_updated_by,  last_update_login,  object_version_number)SELECT  ptrans_helper.amount,  'US Legislative Data Group',  CN_TP_PAYRUNS_ALL.ORG_ID,  CN_TP_PAYSHEETS_ALL.PARTICIPANT_ID,  CN_TP_PAYRUNS_ALL.PAYRUN_ID,  CN_TP_PAYRUNS_ALL.PAY_DATE,  'Driver Safety Program',  CN_TP_PAYRUNS_ALL.PAY_PERIOD_ID,  cn_pay_extract_seq.NEXTVAL,  :p_parent_request_id,  :worker_id,  SYSDATE,  fnd_global.user_guid,  SYSDATE,  fnd_global.user_name,  fnd_global.session_id,  1FROM  CN_TP_PAYRUNS_ALL,  ptrans_helper,  cn_tp_paysheets_all,  cn_srp_participant_hdr_ro_vWHERE  CN_TP_PAYRUNS_ALL.payrun_id = :p_payrun_id  AND CN_TP_PAYRUNS_ALL.payrun_id = cn_tp_paysheets_all.payrun_id  AND cn_tp_paysheets_all.payrun_id = ptrans_helper.payrun_id