My Oracle Support Banner

How do I extract additional transaction types from RCV_transactions table ? (Doc ID 1324461.1)

Last updated on DECEMBER 05, 2019

Applies to:

Data Warehouse Business Adapter for Oracle - Version 7.9.6.1 to 7.9.6.1 [Release V7]
Business Intelligence Applications Observer - Version 7.9.6 [1340] and later
Information in this document applies to any platform.

Goal

Following transactions types from RCV_TRANSACTIONS required for reporting which were filtered out currently.
1. DELIVER
2. REJECT
3. ACCEPT
4. RETURN TO RECEIVING

Can we alter the filter in ‘SDE_ORA_PurchaseReceiptFact’ to include these additional transactions types. Does it have any other hidden implications?

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.