GL to PC Allocation is failing on Transaction Line No join
We are trying to create a PeopleSoft Allocation to pull in fringe benefits from the General Ledger tables into the INTFC_PROJ_RES table. In the Target, we defined the the Transaction ID = Seq No. along with the projectID, date = req date, and other fields. We selected no offset. In the batch records, we used delivered GL TOA tables for the pool & basis, but PC TAO tables for the target. When we run teh allocation, we get an error:
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1617 Error Position: 198 Return: 9 04 - ORA-00904: "PS_ALC_PC_TS_TAO1"."INTFC_LINE_NUM": invalid identifier Failed SQL stmt:UPDATE PS_ALC_PC_TS_TAO1 SET PROCESS_INSTANCE = PROCESS_INSTANCE + 1000000000 WHERE EXISTS ( SELECT 'X' FROM PS_INTFC_PROJ_RES A WHERE A.INTFC_ID = PS_ALC_PC_TS_TAO1.INTFC_ID AND A.INT FC_LINE_NUM = PS_ALC_PC_TS_TAO1.INTFC_LINE_NUM AND A.BUSINESS_UNIT = PS_ALC_PC_TS_TAO1.BUSINESS_UNIT AND A.PROJECT_ID = PS_ALC_PC_TS_TAO1.PROJECT_ID AND A.ACTIVITY_ID = PS_ALC_PC_TS_TAO1.ACTIVITY_ID ) AND PROCESS_INSTANCE = 1211189
0