Custom Subject Area Is Ending With Error Always

(Doc ID 2360422.1)

Last updated on FEBRUARY 15, 2018

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.12.1.0.0 version, Analytics

Custom subject area having custom Object named Purchase Order with no Child Object added is always ending up with errors.

The publication process could not update the Oracle BI EE repository. (ZCX-3075101)
The Oracle BI Server returned the error Logical column PurchaseOrder_c0.PO_POType_c_Meaning has no physical data source mapping. Logical column PurchaseOrder_c0.PO_SalesOpexRSPaymentFrequency_c_Meaning has no physical data source mapping. L. Fix the error, then republish the custom subject area.



ERROR
-----------------------

The publication process could not update the Oracle BI EE repository. (ZCX-3075101)
The Oracle BI Server returned the error Logical column PurchaseOrder_c0.PO_POType_c_Meaning has no physical data source mapping. Logical column PurchaseOrder_c0.PO_SalesOpexRSPaymentFrequency_c_Meaning has no physical data source mapping. L. Fix the error, then republish the custom subject area.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a CSA
2. Publish it


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create a CSA.

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