R12 PAIGEN_SINGLE Errors No Active Bill to Address for the Bill to Customer when the Customer has recently had Addresses Merged in Accounts Receivable (AR). (Doc ID 2208213.1)

Last updated on MARCH 08, 2017

Applies to:

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

Goal

PRC: Generate Draft Invoice For Single Project Completes with the following exception for a single project:

"There is no active Bill to Address for the bill to customer"

Upon further investigation, it is discovered that the secondary customer has has the addresses merged and the new address id was NOT updated to pa_project_customers. After adding legitimate addresses to the Project's customer on the Customer and Contact form, the issue is resolved. Is there a script to identify how many projects exist where the merge did not successfully update pa_project_customers?
 

Solution

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