Account Type is Not Saved at the Database Level for an Account Created in Oracle Customers Online (OCO)
Last updated on JULY 12, 2017
Applies to:Oracle Customers Online - Version 12.1.3 and later
Information in this document applies to any platform.
Attempting to create a "Party" and "Account" in Oracle Customer Online (OCO).
The "Customer Type" flag is not getting populated in the HZ_CUST_ACCOUNTS table.
Steps to Reproduce:
Responsibility: Customers Online Data Librarian
Navigation: Home > Customers Tab > Organization Subtab
-Click on the Create button to create a Party
-Add Below Details
Organization Name: Customer_Type_Organization
Address Line1: 100 Main Street
City: San Antonio
Postal Code 78249
State : TX
-Once Party is created Click on “Update” button then click on 'Accounts' and click on 'Create Account'
-Once the account is created, notice the Account Type - it is defaulted to “External”.
-However, when running the query below, “Account Type”field still shows 'Null':
PARTY_NAME ACCOUNT_NUMBER CUSTOMER_TYPE CREATION_DATE
Broken Steel 1000_BrokenSteel (null) 09-DEC-13
Navigation: Customers > Customers > Query Customer
Change the Customer Type from "External" > back to "Internal" > back to "External" to save the type at the database level.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms