HR Only Hrglobal.drv Failing On R12.1.1 paycamagrecbnc.ldt paycamagrecrbc.ldt paycamagrecbmo.ldt ORA-01400: cannot insert NULL into ("HR"."PAY_MAGNETIC_RECORDS"."FORMULA_ID")

(Doc ID 1606346.1)

Last updated on JULY 18, 2016

Applies to:

Oracle Human Resources - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to run hrglobal
the following error occurs.

  FAILED: file paycamagrecbnc.ldt on worker 1.
  FAILED: file paycamagrecrbc.ldt on worker 2.
  FAILED: file paycamagrecbmo.ldt on worker 3.


Error message :

Uploading from the data file $PAY_TOP/patch/115/import/US/paycamagrecrbc.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files ( $PAY_TOP/patch/115/import/pypmgr.lct(120.3.12010000.1), $PAY_TOP/patch/115/import/US/paycamagrecrbc.ldt) to staging tables
Dumping LCT file $PAY_TOP/patch/115/import/pypmgr.lct(120.3.12010000.1) into FND_SEED_STAGE_CONFIG
Dumping LDT file $PAY_TOP/patch/115/import/US/paycamagrecrbc.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_MAGNETIC_RECORDS RBC_HEADER RBC 1 , PAY_MAGNETIC_RECORDS RBC_PAYMENT RBC 1 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  Error loading seed data for PAY_MAGNETIC_RECORDS: BLOCK_NAME = RBC_HEADER, REPORT_FORMAT = RBC, SEQUENCE = 1, ORA-01400: cannot insert NULL into ("HR"."PAY_MAGNETIC_RECORDS"."FORMULA_ID")
  Error loading seed data for PAY_MAGNETIC_RECORDS: BLOCK_NAME = RBC_HEADER, REPORT_FORMAT = RBC, SEQUENCE = 2, ORA-01400: cannot insert NULL into ("HR"."PAY_MAGNETIC_RECORDS"."FORMULA_ID")
  Error loading seed data for PAY_MAGNETIC_RECORDS: BLOCK_NAME = RBC_HEADER, REPORT_FORMAT = RBC, SEQUENCE = 3, ORA-01400: cannot insert NULL into ("HR"."PAY_MAGNETIC_RECORDS"."FORMULA_ID")
  Error loading seed data for PAY_MAGNETIC_RECORDS: BLOCK_NAME = RBC_MULTI_PAYMENTS, REPORT_FORMAT = RBC, SEQUENCE = 1, ORA-01400: cannot insert NULL into ("HR"."PAY_MAGNETIC_RECORDS"."FORMULA_ID")





Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms