My Oracle Support Banner

OBIA: 7963 NEEDED_BY_DT Column Is Not Mapped In Informatica SDE_PSFT_PurchaseRequisitionLinesFact Mapping (Doc ID 1954065.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.3 [AN 1900] and later
Information in this document applies to any platform.

Goal

NEEDED_BY_DT column is not mapped to any column in Informatica SDE_PSFT_PurchaseRequisitionLinesFact

There is a Requisition Line report: Unfulfilled Past Expected date in procurement performance Dashboard which is not working currently

From Analysis
In Manage SQL this report is using NEEDED_BY_DT column from fact table : W_PURCH_RQSTN_LINE_F. As the NEEDED_BY_DT column is not mapped to any other column it is populating NULL values in it.
 

Solution

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
Goal
Solution


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