Transactions Workbench: Customer Does Not Appear in List of Values in the Transactions Form After Activating it From an Inactive Status

(Doc ID 1584380.1)

Last updated on AUGUST 04, 2016

Applies to:

Oracle Receivables - Version 12.0.0 and later
Information in this document applies to any platform.
ARXTWMAI Transactions form

Symptoms

On : 12.1.3 version, Customers Module

Attempting to select a Customer Site, that was activated after being inactivated previously.  
 
Steps to Reproduce:
Responsibility:  Receivables
Navigation:  Customers > Customers
Query an Inactive customer Site
Activate the Customer Site and Save
Navigation:  Transactions > Transactions
Query the same Site in Transactions form and find site is not available

Query an Existing customer with Active Bill To Site - HZ_CUST_ACCT_SITES_ALL.BILL_TO_FLAG = P - Inactive the Site
The Bill TO also get inactivated. HZ_CUST_ACCT_SITES_ALL.BILL_TO_FLAG = NULL
Now activate the Site and Bill To Business purpose uses HZ_CUST_ACCT_SITES_ALL.BILL_TO_FLAG remain Null only

Due to this, this site does not appear in AR Transaction form

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