Hrglobal.drv Fails to Load Balance Type "ORA-20001: The mandatory argument OBJECT_VERSION_NUMBER value cannot be null"
(Doc ID 2023196.1)
Last updated on DECEMBER 11, 2023
Applies to:
Oracle Payroll - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When loading data into PAY_BALANCE_TYPES during the hrglobal, the following error occurs.
Error Example(ldt file, version, balance name, and directories may differ):
Uploading from the data file /XXXX/apps/apps_st/appl/per/12.0.0/patch/115/import/US/loc_us/pyusbaltypes.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/XXXX/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyseedbal.lct(120.1.12010000.9), /XXXX/apps/apps_st/appl/per/12.0.0/patch/115/import/US/loc_us/pyusbaltypes.ldt) to staging tables
Dumping LCT file /XXXX/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyseedbal.lct(120.1.12010000.9) into FND_SEED_STAGE_CONFIG
Dumping LDT file /XXXX/apps/apps_st/appl/per/12.0.0/patch/115/import/US/loc_us/pyusbaltypes.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_BALANCE_TYPES ACA Employee Service Hours US , PAY_BALANCE_TYPES Workers Compensation3 ER US ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for PAY_BALANCE_TYPES: BALANCE_NAME = Labor Recording, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = US, ORA-20001: The mandatory argument OBJECT_VERSION_NUMBER value cannot be null
Cause: The mandatory argument OBJECT_VERSION_NUMBER has either not been specified or has been explicitly set to null in the API pay_blt_shd.lck .
Action: Either specify a value for the OBJECT_VERSION_NUMBER argument which is not null or contact your local support representative.
Error loading seed data for PAY_BALANCE_TYPES: BALANCE_NAME = Regular Hours Worked, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = US, ORA-20001: The mandatory argument OBJECT_VERSION_NUMBER value cannot be null
Cause: The mandatory argument OBJECT_VERSION_NUMBER has either not been specified or has been explicitly set to null in the API pay_blt_shd.lck .
Action: Either specify a value for the OBJECT_VERSION_NUMBER argument which is not null or contact your local support representative.
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/XXXX/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyseedbal.lct(120.1.12010000.9), /XXXX/apps/apps_st/appl/per/12.0.0/patch/115/import/US/loc_us/pyusbaltypes.ldt) to staging tables
Dumping LCT file /XXXX/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyseedbal.lct(120.1.12010000.9) into FND_SEED_STAGE_CONFIG
Dumping LDT file /XXXX/apps/apps_st/appl/per/12.0.0/patch/115/import/US/loc_us/pyusbaltypes.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_BALANCE_TYPES ACA Employee Service Hours US , PAY_BALANCE_TYPES Workers Compensation3 ER US ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for PAY_BALANCE_TYPES: BALANCE_NAME = Labor Recording, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = US, ORA-20001: The mandatory argument OBJECT_VERSION_NUMBER value cannot be null
Cause: The mandatory argument OBJECT_VERSION_NUMBER has either not been specified or has been explicitly set to null in the API pay_blt_shd.lck .
Action: Either specify a value for the OBJECT_VERSION_NUMBER argument which is not null or contact your local support representative.
Error loading seed data for PAY_BALANCE_TYPES: BALANCE_NAME = Regular Hours Worked, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = US, ORA-20001: The mandatory argument OBJECT_VERSION_NUMBER value cannot be null
Cause: The mandatory argument OBJECT_VERSION_NUMBER has either not been specified or has been explicitly set to null in the API pay_blt_shd.lck .
Action: Either specify a value for the OBJECT_VERSION_NUMBER argument which is not null or contact your local support representative.
Error can occur on any ldt file that contains balance type data to load into PAY_BALANCE_TYPES.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Apply hrglobaldrv.
2. adworker job fails to load ldt file.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |