B Configuring Common Parameters for Upgrading to Oracle BI Applications 7.9.6

This appendix contains instructions for configuring parameters that are specific to the various source systems and that are common across all Oracle BI Applications. It is mandatory that you set the appropriate parameters for your specific source system.

The procedure for setting common parameters entails looking up the parameter value in the DAC's Source System Parameters tab and entering this value in the 796_UPG_PARAMS.txt file, which is stored in the SrcFiles folder on the Informatica Server machine.

This appendix contains the following topics:

• Section B.1, "Configuring Common Parameters for Oracle Source Systems"

• Section B.2, "Configuring Common Parameters for Siebel Source Systems"

B.1 Configuring Common Parameters for Oracle Source Systems

This section contains instructions for configuring parameters specific to Oracle source systems.

This section contains the following topics:

• Section B.1.1, "Configuring Common Parameters for Oracle EBS 11i Source Systems"

• Section B.1.2, "Configuring Common Parameters for Oracle EBS R12 Source Systems"

B.1.1 Configuring Common Parameters for Oracle EBS 11i Source Systems

This section contains instructions for configuring parameters for Oracle EBS 11i source systems.

To configure parameters for Oracle EBS 11i source systems

1. Navigate to the SrcFiles folder on the Informatica Server machine, for example, C:\Program Files\Informatica PowerCenter 8.6\server\infa_shared\SrcFiles.

2. Open the file 796_UPG_PARAMS.txt.

3. Note the values for the following parameters:

   • $$ORA_DATASOURCE_NUM_ID_LIST

   • $$GRAIN

   • $$GBL_DATASOURCE_NUM_ID

   • $$QUALIFICATION_CATEGORY_LIST

4. In DAC, go the the Design view, and select the appropriate custom container.

5. Select the Source System Parameters tab.

6. Query for the parameters listed in Step 3, and compare the values.

7. If necessary, change the values for the parameters in the 796_UPG_PARAMS.txt file to match the values for the parameters in the DAC Source System Parameters tab.

8. Save the 796_UPG_PARAMS.txt file.

B.1.2 Configuring Common Parameters for Oracle EBS R12 Source Systems

This section contains instructions for configuring parameters for Oracle EBS R12 source systems.

To configure parameters for Oracle EBS R12 source systems

1. Navigate to the SrcFiles folder on the Informatica Server machine, for example, C:\Program Files\Informatica PowerCenter 8.6\server\infa_shared\SrcFiles.

2. Open the file 796_UPG_PARAMS.txt.

3. Note the values for the following parameters:

   • $$START_DATE

   • $$END_DATE

4. In DAC, go the the Design view, and select the appropriate custom container.

5. Select the Source System Parameters tab.

6. Query for the parameters listed in Step 3, and compare the values.

7. If necessary, change the values for the parameters in the 796_UPG_PARAMS.txt file to match the values for the parameters in the DAC Source System Parameters tab.

8. Save the 796_UPG_PARAMS.txt file.

B.2 Configuring Common Parameters for Siebel Source Systems

This section contains instructions for configuring parameters specific to Siebel source systems.

To configure parameters for Siebel source systems

1. Navigate to the SrcFiles folder on the Informatica Server machine, for example, C:\Program Files\Informatica PowerCenter 8.6\server\infa_shared\SrcFiles.

2. Open the file 796_UPG_PARAMS.txt.

3. Note the values for the following parameters:

   • $$HI_DT

   • $$LOW_DT

   • $$NAME_ORDER_WITH_FIRSTNAME

4. In DAC, go the the Design view, and select the appropriate custom container.

5. Select the Source System Parameters tab.

6. Query for the parameters listed in Step 3, and compare the values.

7. If necessary, change the values for the parameters in the 796_UPG_PARAMS.txt file to match the values for the parameters in the DAC Source System Parameters tab.

8. Save the 796_UPG_PARAMS.txt file.