FMSAUTOPILOT FAILED WITH ERROR 904 "I"."PROJECT_ID": INVALID IDENTIFIER
(Doc ID 2314139.1)
Last updated on OCTOBER 04, 2017
Applies to:
PeopleSoft Enterprise FIN Project Costing - Version 9.1 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Application package FA_COMMON that checks transaction for AR fail due to invalid field.
FMSAUTOPILOT process failed when calling FA_COMMON application package to check transaction in AR to be process.
Error
SQL error. Function: CreateSQL Error Position: 206 Return: 904 - ORA-00904: "I"."PROJECT_ID": invalid identifier Statement: select count(*) from ps_item i, ps_item_activity ia where i.business_unit = ia.busines s_unit and i.cust_id = ia.cust_id and i.item = ia.item and i.item_line = ia.item_line and i.business _unit_pc <> ' ' and I.PROJECT_ID <> ' ' AND IA.PC_DISTRIB_STATUS = 'N' AND IA.ENTRY_USE_ID IN ('FC-0 1','IT-01','IT-02','MT-03','MT-04','MT-07','WS-03','WS-04','WS-07','WS-08','WS-09','WS-11') Original Statement: SELECT COUNT(*) FROM PS_ITEM I, PS_ITEM_ACTIVITY IA WHERE I.BUSINESS_UNIT = I A.BUSINESS_UNIT AND I.CUST_ID = IA.CUST_ID AND I.ITEM = IA.ITEM AND I.ITEM_LINE = IA.ITEM_LINE AND I
Steps
1. Got to Main Menu > Background Processes >Process Autopilot
2. Set up run control with Process Name = PC_AR_TO_PC and any existing run control id for it.
3. Run Auto pilot
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 |