Financial Management - PSFT (MOSC)

MOSC Banner

GL to PC Allocation is failing on Transaction Line No join

edited Jan 2, 2014 4:35AM in Financial Management - PSFT (MOSC) 7 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center