My Oracle Support Banner

OBIA 11g: SPLR_ACCT_NAME In W_SUPPLIER_ACCOUNT_D NOT Populating Supplier Account Name (Doc ID 2478699.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Business Intelligence Applications Observer - Version 11.1.1.10.2 and later
Information in this document applies to any platform.

Symptoms

OBIA 11.1.1.10.2

SPLR_ACCT_NAME in W_SUPPLIER_ACCOUNT_D is not populating supplier account name but instead it is populating supplier site code values.

It is noticed in SDE Interface (SDE_ORA_SupplierAccountDimension.W_SUPPLIER_ACCOUNT_DS) column SPLR_ACCT_NAME has been mapped to SQ_SUPPLIERS.VENDOR_SITE_CODE from the Interface.

In many reports, using the SPLR_ACCT_NAME column to show the actual supplier account names but because of this issue it is showing the Supplier Site Code.



Cause

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
Symptoms
Cause
Solution
References


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