Error When Generating Invoice For Project With Related 'Bill To' Customer (Doc ID 1218764.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms


Can not use related customer for billing in project billing.

Steps to Reproduce:
1.  Create a project for customer A.
2.  Make the billing customer B
3.  B has a relationship with A
4.  Create a billing event
5.  Run PRC: Generate Draft Revenue for a Single Project, which errors with the following:

Going to check relation()
...Checking Billing Contact For Cust #5256
... For Bill Cust #28163
... For Ship Cust #5256
...Checking Relation - 1ORACLE error during DRAFT INVOICE GENERATION (cursor=2494248 code=-2112: SQL-02112: SELECT..INTO returns too many rows )
PAI_ORACLE_ERROR
ERROR
cursor=2494248 code=-2112: SQL-02112: SELECT..INTO returns too many rows

Leaving paiagr()Error during Draft Invoice Generation. Module paiagr returned failure
PA_IGEN_ERROR
MODULE
paiagr
Error during Draft Invoice Generation. Module paigop returned failure
PA_IGEN_ERROR
MODULE
paigop

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