Why PC_AR_TO_PC Inserts Direct Journal Data Into PC With BI, CST, & REV DISTRIB_STATUS Values = I (Doc ID 2178723.1)

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.

Goal

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
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms