BENEFITS ACA STATE TRANSMISSION FOR RI FAILING ON TAG:SOFTWAREID - POST 2020 ACA PHASE III PATCH 32575269
(Doc ID 2786378.1)
Last updated on JUNE 30, 2021
Applies to:
Oracle Advanced Benefits - Version 12.1 HRMS RUP10 and laterInformation in this document applies to any platform.
Symptoms
Problem Statement:
Post 2020 ACA PHASE III PATCH 32575269 the Benefits ACA State Transmission Generation Process completes with Error status for RI.
Error:
BENACAXMLST: Benefits ACA State Transmission Generation Process
+---------------------------------------------------------------------------+
Current system time is 17-JUN-2021 22:14:45
+---------------------------------------------------------------------------+
[17-JUN-2021 22:14:45]: **Starts**
[17-JUN-2021 22:19:07]: **SQL error and free**
[17-JUN-2021 22:19:07]: ORACLE error 20001 in FDPSTP
Cause: FDPSTP failed due to ORA-20001: :
ORA-06512: at "APPS.FND_MESSAGE", line 509
ORA-06512: at "APPS.BEN_ACA_XML_PROCESS_STATES", line 9218
ORA-06512: at line 1
Generating manifest XML for xml rep action:281
null data found for mandatory tag:SoftwareId
l_hash from BEN_REP_FILES TABLE:
96F48D988573BD279EB2D5B30987489D7286849E875A86E5F7ED266176042480
Successfully generated Manifest XML :
Update Archive Data Start :2021-06-17T22:15:42
updating ben rep person actions:
ben rep person actions update done fore records:
ben rep person actions update done:
Update Archive Data End :2021-06-17T22:19:06
invalid data found in xml
Transmission XML Generation Failed:
ORA-20001: :
BENACAXMLST: Benefits ACA State Transmission Generation Process
+---------------------------------------------------------------------------+
Current system time is 17-JUN-2021 22:14:45
+---------------------------------------------------------------------------+
[17-JUN-2021 22:14:45]: **Starts**
[17-JUN-2021 22:19:07]: **SQL error and free**
[17-JUN-2021 22:19:07]: ORACLE error 20001 in FDPSTP
Cause: FDPSTP failed due to ORA-20001: :
ORA-06512: at "APPS.FND_MESSAGE", line 509
ORA-06512: at "APPS.BEN_ACA_XML_PROCESS_STATES", line 9218
ORA-06512: at line 1
Generating manifest XML for xml rep action:281
null data found for mandatory tag:SoftwareId
l_hash from BEN_REP_FILES TABLE:
96F48D988573BD279EB2D5B30987489D7286849E875A86E5F7ED266176042480
Successfully generated Manifest XML :
Update Archive Data Start :2021-06-17T22:15:42
updating ben rep person actions:
ben rep person actions update done fore records:
ben rep person actions update done:
Update Archive Data End :2021-06-17T22:19:06
invalid data found in xml
Transmission XML Generation Failed:
ORA-20001: :
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- US Super HRMS Manager
- Processes and Reports > Submit Processes and Reports
- Submit Benefits ACA State Transmission Generation Process -> set the relevant parameters for Rhode Island
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 |