Error While Running The PRC: Year End Budget Rollover Process (Doc ID 2076629.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Planning and Control - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

PABDGRLR: PRC: Year End Budget Rollover Process
.....
.....
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Log: Calling populate_hist_table
Log: Inside populate_hist_table
Log: Exiting populate_hist_table
Log: Start of Update_Act_Enc_Balance
: PB:Entering Sweeper
Log: No. of records to delete 0
Log: No records in c_delete_pkts, exit
Log: Last Deleted 0 records from PA_BC_PACKETS older than 3 days
Log: Deleted 1 records from GL_BC_PACKETS older than 3 days
Log: Entering Loop
*******************************************************
Log: End of Update_Act_Enc_Balance
: PB:Exiting Sweeper
Debug Msg :Year_End_Rollover: Request ID : 1086966
Debug Msg :Year_End_Rollover: Set of Books ID : 2023
Debug Msg :Year_End_Rollover: Organization ID :
Debug Msg :Year_End_Rollover: Accounted Period Type : 21
Debug Msg :Year_End_Rollover: ------------------------------
Debug Msg :Year_End_Rollover: Start API : Get_Period_Details
Debug Msg :Year_End_Rollover: ------------------------------
Debug Msg :Year_End_Rollover: Fiscal Closing Year : 2015
Debug Msg :Year_End_Rollover: Set Of Books ID : 2023
Debug Msg :Year_End_Rollover: Cur Yr First Prd Start Date : 01-JAN-2015
Debug Msg :Year_End_Rollover: Cur Yr Last Prd Start Date : 01-DEC-2015
Debug Msg :Year_End_Rollover: Cur Yr Last Prd End Date : 31-DEC-2015
Debug Msg :Year_End_Rollover: Next Yr First Prd Start Date : 01-JAN-2016
Debug Msg :Year_End_Rollover: Next Yr First Prd End Date : 31-JAN-2016
Debug Msg :Year_End_Rollover: ERRORS encountered in API : Get_Period_Details
Debug Msg :Year_End_Rollover: Get_Period_Details-> Error: X_Msg_Data : ORA-01422: exact fetch returns more than requested number of rows
+---------------------------------------------------------------------------+

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