How To delete or Purge Customers from Oracle Receivables

At this time there is no functionality available to purge/delete customer information from Oracle Receivables and hence Oracle support can not provide a script to delete the customers incorrectly loaded or the customer that will never be used. Customer information is stored in about 20 to 25 tables. It is not supported solution to delete the record from the database by any unsupported means.

How To Create a Customer That is Also a Supplier

Step to create customer as a supplier:

1. Enable the profile option at site level : POS:SM: Supplier Data Hub Configuration

2. Set this profile option to "Standalone" if you are implementing Supplier Hub as a Standalone MDM instance.


3. Steps below to reproduce the same:

a. Create Customer Party
b. Login to Supplier Data Librarian Super User responsibility
c. Click "Select" and click the "Enable As Supplier" button & Save
d. Search for the customer created.
e. Navigate to Payables --- Supplier page and see "Enable As Supplier" option available
f. The customer that was enabled as a supplier is now available for further action.

Error: This transaction type does not have any action types for the rule type selected. Ensure you add the selected rule type's action types to this transaction type to use in a rule.

Issue:

Error: This transaction type does not have any action types for the rule type selected. Ensure you add the selected rule type's action types to this transaction type to use in a rule.

Fix:

1. Navigate to Approvals Management Business Analyst Responsibility > Business Analyst Dashboard

2. Payables Invoice Approval> Setup

3. Action types tab > Select Use Existing Action Type

4. Select Name = Pre-chain of authority approvals having Rule type = Pre List approval Group.

5. Now Create Rule > Enter Details > Click next > no error received. > AME setup done without error