Flat Files Reference For Source Domains in Price Analytics for E-Business Suite

You can configure the Source Domain Member Name values for those Codes seeded through the Price flat files.

The table below captures the lineage from Presentation Column to Flat file column and relevant Source domain codes.

Presentation Table Presentation Column File Name File Column Source Domain Code

Price Waterfall Element

Source Element Code

file_pwf_element_ds.csv

ELEMENT_CODE

PRC_ELEMENT_CODE

Price Waterfall Element

Source Element Type Code

file_pwf_element_ds.csv

ELEMENT_TYPE_CODE

PRC_ELEMENT_TYPE_CODE

Price Profile

Profile Attribute 1 Code

file_pri_segment_ds.csv

PROF_ATTR_1_CODE

PRC_PROFILE_1

Price Profile

Profile Attribute 2 Code

file_pri_segment_ds.csv

PROF_ATTR_2_CODE

PRC_PROFILE_2

Price Profile

Profile Attribute 3 Code

file_pri_segment_ds.csv

PROF_ATTR_3_CODE

PRC_PROFILE_3

Price Profile

Profile Attribute 4 Code

file_pri_segment_ds.csv

PROF_ATTR_4_CODE

PRC_PROFILE_4

Price Profile

Profile Attribute 5 Code

file_pri_segment_ds.csv

PROF_ATTR_5_CODE

PRC_PROFILE_5

Note:

The configuration file or files for this task are provided on installation of Oracle BI Applications at one of the following locations:

  • Source-independent files: <Oracle Home for BI>\biapps\etl\data_files\src_files\.

  • Source-specific files: <Oracle Home for BI>\biapps\etl\data_files\src_files\<source adaptor>.

Your system administrator will have copied these files to another location and configured ODI connections to read from this location. Work with your system administrator to obtain the files. When configuration is complete, your system administrator will need to copy the configured files to the location from which ODI reads these files.

Note:

If you are deploying OTBI-Enterprise, then you must download the CSV files from Configuration Manager, as follows: 1. From the Tasks bar, click Define Business Intelligence Applications. 2. Click Actions, then Manage Source Configuration Data Files. 3. Click the Export Source Configuration Data Files option on the tool bar. 4. Move the required files to the right hand list, then click Export.

Configuration File: file_domain_member_gs.csv

The file is generic and therefore does not support any source Pricing system specific features.

This file is used to populate data for the following domains which are not available in E-Business Suite and should be loaded only if supplementing data for any of the dimensions listed below:

  • Price Waterfall Element Dimension – Price Element Type Code (the Conformed Price Element Type will have to be mapped to any new domains introduced through this).

  • Price Segment Dimension - Price Profile Attribute 1 Code

  • Price Segment Dimension - Price Profile Attribute 2 Code

  • Price Segment Dimension - Price Profile Attribute 3 Code

  • Price Segment Dimension - Price Profile Attribute 4 Code

  • Price Segment Dimension - Price Profile Attribute 5 Code

Task SDE_ORA_DomainGeneral_PriceElementType will load the file data to Warehouse staging table W_DOMAIN_MEMBER_GS.

The granularity of this file is each domain member per language for any of the domains listed above.

Column Name Data Type Sample Data Description

DOMAIN_CODE

Not available.

Not available.

This should be populated with the Domain Code corresponding to the Source Domain that is to be configured as per Table 10-1.

DOMAIN_TYPE_CODE

Not available.

Not available.

Defaulted to 'S' - indicates this is a Source Domain Code.

DOMAIN_MEMBER_CODE

Not available.

Not available.

This should be populated with the CODE value supplied in any of the above files.

DOMAIN_MEMBER_NAME

Not available.

Not available.

This should be populated with the NAME value that corresponds to the Member Code supplied.

DOMAIN_MEMBER_DESCR

Not available.

Not available.

Not available.

DOMAIN_MEMBER_REF_CODE

Not available.

Not available.

Hardcode to '__NOT_APPLICABLE__'.

DOMAIN_MEMBER_DEFN_TYPE_CODE

Not available.

Not available.

Not available.

LANGUAGE_CODE

Not available.

Not available.

Warehouse Language Code.

SRC_LANGUAGE_CODE

Not available.

Not available.

Source Language Code.

INTEGRATION_ID

Not available.

Not available.

This is the unique ID for the record. The INTEGRATION_ID for this file can also be populated as DOMAIN_CODE~DOMAIN_MEMBER_CODE.

DATASOURCE_NUM_ID

Not available.

Not available.

The unique Data Source ID of the Siebel Instance you are configuring.