Receipt Accrual(PO_RECVACCR) Process Failing With SQL Error (Doc ID 2206151.1)

Last updated on NOVEMBER 21, 2016

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When Receipt Accrual (PO_RECVACCR) process is ran in the system the process is went into error with the following error message. This happens when there are two different accounting period exists for two SETIDs in PS_CAL_DETP_TBL.

"SQL error(Sub query returns more than 1 value) in PO_RECVACCR.RACCR010.DELMXAC6 (Do Select)"
 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Make sure there is a calendar code exists for SETID SHARE and SHR03 with
Calendar code 01 for year 2016.
2. As there is no calendar I created a calendar for 2016 for SHR03, I created
one (Set Up Financials/Supply Chain- Common Definitions-
Calendars/SchedulesDetail Calendar)
3. Updated the user preferences with SETID SHR03 (Set Up Financials/Supply
Chain- Common Definitions - User Preferences - Define User Preferences ¿
Overall preferences).
4. Created a online requisition, budget checked
5. Requisition selection
6. Ran Auto Sourcing to generate a PO
7. PO  budget checked and dispatched
8. Created a RECEIPT
9. Ran Receipt Accural Process
10. Process goes into NO SUCCESS with the following error.

Cause

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