BIAPPS 11.1.1.8.1 - ‘DELIVER’ Transaction Type Data Not Available In Purchase Facts. How Can You Extract Data for TRANSACTION_TYPE='DELIVER' ? (Doc ID 2040523.1)

Last updated on SEPTEMBER 03, 2015

Applies to:

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

Goal

BIAPPS 11.1.1.8.1 Out of Box

Source is Oracle E-Business Suite R12.1.3.

You want to use the measure contained in the Out of Box RPD which is based on the EBS source TRANSACTION_TYPE=‘DELIVER’ from the RCV_TRANSACTIONS table.
But when you looked into the ODI logic and BIACM Mapping for Purchase Facts, it only has data for the TRANSACTION_TYPE('RECEIVE','MATCH','RETURN TO VENDOR') from RCV_TRANSACTIONS table.

Why is Out of Box RPD only supporting TRANSACTION_TYPE('RECEIVE','MATCH','RETURN TO VENDOR') from RCV_TRANSACTIONS and how can you extract data for TRANSACTION_TYPE='DELIVER'?
 

Solution

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