Last updated on JUNE 13, 2017
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Issue:- Receipt Accrual Process went to No Success with below Error
"File: e:\pt85512b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 805 - ORA-00001: unique constraint (EMDBO.PS_RECV_ACCR_DFLB) violated Failed SQL stmt: INSERT INTO PS_RECV_ACCR_DFLB( PROCESS_INSTANCE , BUSINESS_UNIT , BUSINESS_UNIT_PO , PO_ID , VENDOR_SETID , VENDOR_ID , VNDR_LOC , CURRENCY_CD_BASE , DECIMAL_POS_BSE , DST_CNTRL_ID , BUSINESS_UNIT_GL , APPL_JRNL_ID_RACC , CALENDAR_ID) SELECT DISTINCT H.PROCESS_INSTANCE , S.BUSINESS_ UNIT , S.BUSINESS_UNIT_PO , S.PO_ID , H.VENDOR_SETID , H.VENDOR_ID , H.VNDR_LOC , B.CURRENCY_CD_BASE , C.DECIMAL_POSITIONS , P.DST_CNTRL_ID , B.BUSINESS_UNIT_GL , G.APPL_JRNL_ID_RACC , L.CALENDAR_ID F ROM PS_RECV_HDR_TMP2 H , PS_RECV_LN_ACCTG A , PS_RECV_LN_DISTRIB S , PS_PO_HDR P , PS_PO_LINE_DISTRI B B , PS_BUS_UNIT_INTFC G , PS_BU_LED_GRP_TBL L , PS_CURRENCY_CD_TBL C WHERE H.PROCESS_INSTANCE = 11
5:29:19AMProcess 110280 ABENDED at Step PO_RECVACCR.RACCR023.Step10-1 (SQL) -- RC = 805305:29:19AM110280 PO_RECVACCR RACCR023 Step10-1 SQL 805"
Steps To Reproduce the Issue:-
1.Create a PO With Matching required and Receiving required with two lines having Same GL BU(US005) and dispatch the PO.
2.Create a receipt from the PO.After creating the receipt.Change the GL BU on line 1 to US001.
3.Run Receipt Accrual for current period.Data gets populated in RECV_LN_ACCTG table
4.Run the Journal generator process for current accounting period.Journals are created and the journal ID is populated in RECV_LN_ACCTG table for current period
5.Run the Journal generator process for next accounting period.Journals are created and the journal ID is populated in RECV_LN_ACCTG table for the next accounting period
6.Close the receipt forcefully using Receiver's workbench(Not qualified because receipt status is unmatched)
7.Close the PO forcefully using Buyer's Workbench(Not qualified because PO status is unmatched)
8.Now navigate to Setup Financials->Business Unit Related->General Ledger->Ledgers for a Unit and change the calendar ID for US001 Recording Ledger to 03
9.Now run the Receipt Accrual Process for the Receipt Business Unit
Process went to No Success
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