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 31, 2023

Applies to:

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

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