EPC: PC_POADJUST & PC_PO_TO_PC Process Failing At Steps PC_POADJUST.SYNC1.Step02 or PC_PO_TO_PC.SYNC1.Step02 Respectively
(Doc ID 2564351.1)
Last updated on AUGUST 11, 2022
Applies to:
PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
On : 9.2 version, Purchasing Integration
PC_POADJUST & PC_PO_TO_PC process failing at step SYNC1.Step02 (SQL)
Both the Purchasing to Project costing integration processes are failing with same error as shown below.
Process names : PC_POADJUST & PC_PO_TO_PC
ERROR
-----------------------
Step failing :
Process ABENDED at Step PC_PO_TO_PC.SYNC1.Step02 (SQL) -- RC = 904 (108,524)
Process ABENDED at Step PC_POADJUST.SYNC1.Step02 (SQL) -- RC = 904 (108,524)
Stmt #: 1723 Error Position: 112 Return: 904 - ORA-00904: "EFFDT_TO": invalid identifier
Failed SQL stmt: INSERT INTO PS_PROJ_RES_DELETE (SETID, COMBINATION, DESCR, COMBO_DEFN_NAME, VALID_CODE, EFFDT_FROM, EFFDT_OPEN, EFFDT_TO) SELECT ' ', ' ', DEL.DESCR, ' ', 'V', TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD'), 'Y', NULL FROM PS_PROJ_RES_DEL DEL WHERE DEL.PROCESS_INSTANCE = 7661634 AND NOT EXISTS ( SELECT 'X' FROM PS_PROJ_RES_DELETE PRD WHERE DEL.PROCESS_INSTANCE = 7661634 AND PRD.BUSINESS_UNIT = DEL.BUSINESS_UNIT AND PRD.PROJECT_ID = DEL.PROJECT_ID AND PRD.ACTIVITY_ID = DEL.ACTIVITY_ID AND PRD.RESOURCE_ID = DEL.RESOURCE_ID)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run PC_POADJUST or PC_PO_TO_PC process that calls PC_POADJUST is "From Feed" is checked on for reversals in the Project Costing installation options
Changes
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 |
| Changes |
| Cause |
| Solution |