My Oracle Support Banner

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 MAY 25, 2023

Applies to:

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


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 - Inactivate the Site
The Bill TO (site) also gets inactivated. HZ_CUST_ACCT_SITES_ALL.BILL_TO_FLAG = NULL
Now activate the Site and Bill To Business purpose uses (site uses) HZ_CUST_ACCT_SITES_ALL.BILL_TO_FLAG remain Null only

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




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

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