Last updated on SEPTEMBER 01, 2016
Applies to:PeopleSoft Enterprise FIN Project Costing - Version 9.2 and later
Information in this document applies to any platform.
The AR Direct Journal integration to Project Costing was added into the PC_AR_TO_PC process in 9.2. The PC_AR_TO_PC.40000000.INSERT2 sql step inserts data into PROJ_RES_TMP with BI_DISTRIB_STATUS, CST_DISTRIB_STATUS, & REV_DISTRIB_STATUS values = I. This prevents the AR Direct Journal data from being eligible for PC_PRICING. The fields should have value = N when inserted into PC from AR.
%InsertSelect(PROJ_RES_TMP, PC_AR_PAY_TAO TAO, FOREIGN_AMOUNT = %RoundCurrency(%DecMult(TAO.FOREIGN_AMOUNT, AGM.SIGNED_VALUE), TAO.FOREIGN_CURRENCY), GL_DISTRIB_STATUS = 'I', PC_DISTRIB_STATUS = 'N', CST_DISTRIB_STATUS = 'I', BI_DISTRIB_STATUS = 'I', REV_DISTRIB_STATUS = 'I', CUR_EFFDT = TAO.ACCOUNTING_DT, BUS_UNIT_GL_FROM = TAO.BUSINESS_UNIT_GL, RESOURCE_ID_FROM = TAO.RESOURCE_ID)
FROM %Table(PC_AR_PAY_TAO) TAO, PS_PROJ_AN_GRP_MAP AGM, PS_SET_CNTRL_REC REC
WHERE TAO.PROCESS_INSTANCE = %ProcessInstance
AND AGM.ANALYSIS_GROUP = %Bind(PC_AR_TO_PC_AET.AN_GRP_AR)
AND AGM.ANALYSIS_TYPE = TAO.ANALYSIS_TYPE
AND REC.SETCNTRLVALUE = TAO.BUSINESS_UNIT
AND REC.RECNAME = 'PROJ_AN_GRP_MAP'
AND REC.SETID = AGM.SETID
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms