How To Configure Domain Values For Oracle Receivables Analytics In OBI Applications 7.9.6.3

(Doc ID 1385153.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Siebel Data Warehouse Application Console - Version 7.9.6.3 [AN 1900] and later
Information in this document applies to any platform.
21st May 2013 - Checked for Relevancy

Goal

When configuring the domain values for Oracle Receivables Analytics and following steps in the Oracle Business Intelligence Applications Configuration Guide for Informatica PowerCenter Users
Release 7.9.6.3, there is confusion on the mplt_BC_PSFT_ARTransactionFact_ItemActivity maplet.

Specifically, Section 5.2.3.2 How to Configure Domain Values for Oracle Receivables Analytics:

1. In Informatica PowerCenter Designer, open mapplets mplt_BC_PSFT_ARTransactionFact_Item and mplt_BC_PSFT_ARTransactionFact_ItemActivity in the SDE_PSFTVersion_Adaptor folder.

2. Open the Source Qualifier transformation.  At the end of the SQL, there is a IN clause that should include all the entry typecodes that map into W_XACT_TYPE_CODE = 'ORIGINAL' in the CSV file prepared above.

3. In Informatica PowerCenter Workflow Manager, make the same change to the full load sessions that correspond to the SDE_PSFT_ARTransactionFact_Item_Full and SDE_PSFT_ARTransactionFact_ItemActivity_Full mappings.

However, in the mapplet mplt_BC_PSFT_ARTransactionFact_ItemActivity, there is no IN clause. Instead there is a NOT IN clause available.

Should this be changed to an IN clause instead of  NOT IN?


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