Create Custom Subject Area Error : No Physical Mapping available

(Doc ID 2348758.1)

Last updated on JANUARY 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

Unable to publish the CSA

ERROR
-----------------------
ZCX-3075101
The Oracle BI Server returned the error Logical column YFYMachineInfo_c0.PaperType_c_Meaning has no physical data source mapping. Logical column YFYMachineInfo_c0.RecordType_c_Meaning has no physical data source mapping. Logical column YFYM. Fix the error, then republish the custom subject area." when create custom subject area and publish.




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Goto Application Composervr --> Common --> Custom Subject Area --> Create --> Publish --> throws the error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create and use the custom subject area

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