Account Type is Not Saved at the Database Level for an Account Created in Oracle Customers Online (OCO) (Doc ID 1643378.1)

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.

Symptoms

In R12.1.3:

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
  County: Bexar
  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

WORKAROUND: 
Responsibility:  Receivables
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.

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