Last updated on SEPTEMBER 27, 2016
Applies to:Siebel Data Warehouse Application Console - Version 220.127.116.11 [AN 1900] and later
Information in this document applies to any platform.
21st May 2013 - Checked for Relevancy
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 18.104.22.168, there is confusion on the mplt_BC_PSFT_ARTransactionFact_ItemActivity maplet.
Specifically, Section 22.214.171.124 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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms