My Oracle Support Banner

G-Invoicing Reprocess Receipts Displays Errors 'ORA-01422: exact fetch returns more than requested number of rows' and 'ORA-06512: at APPS.PA_PERF_OBLIGATION_PVT' in Log (Doc ID 2997127.1)

Last updated on MARCH 01, 2024

Applies to:

Oracle Project Billing - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

Reprocess Receipt is failing with error

ERROR MESSAGE:
----------------------
“ORA-01422: exact fetch returns more than requested number of rows”


The issue can be reproduced at will with the following steps:

1. SFO (Seller Facilitated Order) created with 200 lines and 300 schedules.

2. Successfully pushed order to requesting. Completed requesting side activities.

3. Pulled the order back into servicing.

4. Successfully completed budget baseline.

5. Created 1600 billing events for 200 lines. (Multiple events for each task).

6. Successfully completed draft revenue, draft invoice and created AR transaction.

7. Executed “PRC: Process Mass submission performances for G-Invoicing” with performance type – Delivery and performance date of 30-SEP-2023.

8. On 05-OCT-2023, executed “Intragovernmental Performance Interface Program” with request mode Pull and request type – Get Performance List.

9. Program completed successfully but receipts not created due to GL date, 05-OCT-2023, is not in an open or future-enterable period.

10. PA, AR, GL (Projects, Receivables, General Ledger) periods are opened for OCT-2023.

11. Attempted to create receipts using reprocess receipts and receive error:

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at "APPS.PA_PERF_OBLIGATION_PVT", line 11230

ORA-06512: at "APPS.PA_PERF_OBLIGATION_PVT", line 10791 ORA-06512: at "APPS.PA_PERF_OBLIGATION_PVT", line 10791 ORA-06512: at line 1

 

12. Verified package body and spec object status “APPS.PA_PERF_OBLIGATION_PVT” and it is in valid status


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.