FMSAUTOPILOT FAILED WITH ERROR 904 "I"."PROJECT_ID": INVALID IDENTIFIER (Doc ID 2314139.1)

Last updated on OCTOBER 04, 2017

Applies to:

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