OBIA 11g : Reporting ACTIVITY_ID Level on W_RQSTN_LINE_COST_F FACT Table (Doc ID 2244516.1)

Last updated on JUNE 08, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.
- BI Apps modules: -- "Finance and Procurement & Spend"
- Source System/version: PeopleSoft (PSFT) 9.2

Symptoms

Issue when reporting on activity id for W_RQSTN_LINE_COST_F as in the SDE_PSFT_RequisitionLinesCostFact Interface, the GL_ACCOUNT_ID mapping expression doesn’t include PS_REQ_LN_DISTRIB.ACTIVITY_ID

Out of the Box (OOTB) mapping does not include activity_id to create gl_account_id under mapping SDE_PSFT_RequisitionLinesCostFact.

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