Oracle® Business Intelligence Applications Upgrade Guide for Informatica PowerCenter Users Release 7.9.6.3 Part Number E19040-01 |
|
|
PDF · Mobi · ePub |
This appendix contains the following topics:
Section D.1, "Running reset_infa_seq_gen.bat on Base Informatica Repository"
Section D.4, "Running reset_infa_seq_gen.bat on Upgrade Informatica Repository"
Follow this procedure to run the reset_infa_seq_gen.bat file on the Base informatica Repository if your Oracle Business Analytics Warehouse runs on an Oracle, DB2, or MSSQL Server database.
This section contains the following topics:
Section D.1.2, "Obtaining ROW_WID from W_ORG_D and W_PRD_OF_WRK_BAND_D"
Section D.1.3, "Obtaining ROW_WID from W_PARTY_D and W_PRD_OF_WRK_BAND_D"
Follow this procedure to enter values for the reset_infa_seq_gen.bat file to initialize the Informatica sequence generator for incremental runs on the base Informatica Repository (for example, Oracle_BI_DW_Base.rep).
Navigate to OracleBI\dwrep\Upgrade\DbScripts\<database type>.
Open the reset_infa_seq_gen.bat file.
Enter the appropriate parameter values to reflect your environment (the parameters are database specific). See one of the following tables:
Table D-1, "Oracle Database Parameter Settings for reset_infa_seq_gen.bat"
Table D-2, "SQL Server Database Parameter Settings for reset_infa_seq_gen.bat"
Table D-3, "IBM DB2 Database Parameter Settings for reset_infa_seq_gen.bat"
After you complete this step, proceed to one of the following sections:
Follow the steps in Section D.1.2, "Obtaining ROW_WID from W_ORG_D and W_PRD_OF_WRK_BAND_D" if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.9.5, 7.9.5.1, or 7.9.6.
Follow the steps in Section D.1.3, "Obtaining ROW_WID from W_PARTY_D and W_PRD_OF_WRK_BAND_D" if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.6.1, 7.9.6.2, or 7.9.6.3.
Do not execute reset_infa_seq_gen.bat until you have completed the procedures in either Section D.1.2 or Section D.1.3.
Oracle Database Parameter Settings for the Base Informatica Repository
Table D-1 Oracle Database Parameter Settings for reset_infa_seq_gen.bat
Parameter | Setting |
---|---|
OLAP USERNAME |
Enter the data warehouse database user ID. |
OLAP PASSWORD |
Enter the user ID/password@connection string of the data warehouse database. |
OLAP TNS ENTRY |
Enter the TNS entry for the data warehouse database. |
INFORMATICA SERVER ADDRESS |
Enter the host address for the Informatica Service. |
INFORMATICA REPOSITORY DATABASE TNSENTRY |
Enter the TNS entry for the Informatica Repository database. |
INFORMATICA REPOSITORY DB USERNAME |
Enter the user ID of the base Informatica Repository database. |
INFORMATICA REPOSITORY DB PASSWORD |
Enter the password@connection string of the base InformaticaRepository database. |
INFORMATICA REPOSITORY |
Enter the name of the base Informatica Repository. |
INFORMATICA REPOSITORY USERNAME |
Enter the user ID of the base Informatica Repository. |
INFORMATICA REPOSITORY PASSWORD |
Enter the password for the base Informatica Repository. |
INFORMATICA FODLER |
For all source systems except Siebel Industry Applications, enter the value For Siebel Industry Applications, you need to run reset_infa_seq_gen.bat twice. For the first execution, enter the value |
INFORMATICA PORT |
Enter the port number for the Repository Service. The default is 6001. |
SQL Server Database Parameter Settings for the Base Informatica Repository
Table D-2 SQL Server Database Parameter Settings for reset_infa_seq_gen.bat
Parameter | Setting |
---|---|
OLAP_SERVER |
Enter the name of the SQL Server for the OLAP database. |
OLAP DATABASE |
Enter the name of the database on which OLAP data is available. |
OLAP USERNAME |
Enter the user ID of the data warehouse database. |
OLAP PASSWORD |
Enter the user ID/password@connection string of the data warehouse database. |
INFORMATICA REPOSITORY DB SERVER ADDRESS |
Enter the Informatica Server host address. |
INFORMATICA DATABASE |
Enter the name of the database in which the base Informatica Repository metadata is available. |
INFORMATICA DB USERNAME |
Enter the user ID of the base Informatica Repository database. |
INFORMATICA DB PASSWORD |
Enter the password @connection string of the base Informatica Repository database. |
INFORMATICA REPOSITORY SERVER ADDRESS |
Enter the name of the machine that runs the Repository Service for the base Repository. |
INFORMATICA REPOSITORY USERNAME |
Enter the user ID of the base Informatica Repository. |
INFORMATICA REPOSITORY PASSWORD |
Enter the password of the base Informatica Repository. |
INFORMATAICA FOLDER |
For all source systems except Siebel Industry Applications, enter the value For Siebel Industry Applications, you need to run reset_infa_seq_gen.bat twice. For the first execution, enter the value |
INFORMATICA PORT |
Enter the port number for the Repository Service. The default is 6001. |
IBM DB2 Database Parameter Settings for the Base Informatica Repository
Table D-3 IBM DB2 Database Parameter Settings for reset_infa_seq_gen.bat
Parameter | Setting |
---|---|
OLAP USERNAME |
Enter the user ID of the data warehouse database. |
OLAP PASSWORD |
Enter the user ID/password@connection string of the data warehouse database. |
INFA DATABASE ALIAS |
Enter the name of the database in which Informatica Repository metadata is available. |
INFORMATICA DB USERNAME |
Enter the user ID of the base Informatica Repository database. |
INFORMATICA DB PASSWORD |
Enter the password @connection string of the base Informatica Repository database. |
INFORMATICA REPOSITORY |
Enter the name of the base Informatica Repository. |
INFORMATICA REPOSITORY USERNAME |
Enter the user ID of the base Informatica Repository. |
INFORMATICA REPOSITORY PASSWORD |
Enter the password for the base Informatica Repository. |
INFORMATICA SERVER ADDRESS |
Enter the Informatica Server host address. |
INFORMATICA FOLDER |
For all source systems except Siebel Industry Applications, enter the value For Siebel Industry Applications, you need to run reset_infa_seq_gen.bat twice. For the first execution, enter the value |
INFORMATICA PORT |
Enter the port number for the Repository Service. The default is 6001. |
Follow this procedure to obtain the maximum ROW_WID value from W_ORG_D and from W_PRD_OF_WRK_BAND_D if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.9.5, 7.9.5.1, or 7.9.6.
Note: If you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.6.1, 7.9.6.2, or 7.9.6.3, follow the steps in Section D.1.3, "Obtaining ROW_WID from W_PARTY_D and W_PRD_OF_WRK_BAND_D."
Obtain the maximum ROW_WID value from W_ORG_D:
In the reset_infa_seq_gen.bat file, go to the end of the file and locate the section similar to
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
In the code example, note the value 1234567
. You will replace this value in a following step.
On the data warehouse, run the following SQL statement:
SELECT MAX(ROW_WID)+1 FROM W_ORG_D
In the reset_infa_seq_gen.bat file, replace the value 1234567
with the value that was returned by the SQL statement.
Obtain the maximum ROW_WID value from W_PRD_OF_WRK_BAND_D:
In the reset_infa_seq_gen.bat file, go to the end of the file and locate the section similar to:
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
Add the following lines after the section referred to in step a:
IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_3000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX1 >>sequence_gen_update.bat IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_4000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX2 >>sequence_gen_update.bat
In the code example, note the values MAX1 and MAX2. You will replace these values in a following step.
On the data warehouse, run the following SQL statements:
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_EMP'
The value returned from the SQL statement above corresponds to MAX1.
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_CWK'
The value returned from the SQL statement above corresponds to MAX2.
In the reset_infa_seq_gen.bat file, replace the values MAX1 and MAX2 with the values returned by the SQL statements.
Execute reset_infa_seq_gen.bat.
Follow this procedure to obtain the maximum ROW_WID value from W_PARTY_D and from W_PRD_OF_WRK_BAND_D if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.6.1, 7.9.6.2, or 7.9.6.3.
Note: If you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.9.5, 7.9.5.1, or 7.9.6, follow the steps in Section D.1.2, "Obtaining ROW_WID from W_ORG_D and W_PRD_OF_WRK_BAND_D."
Obtain the maximum ROW_WID value from W_ORG_D:
In the reset_infa_seq_gen.bat file, go to the end of the file and locate the section similar to
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
In the code example, note the value 1234567
. You will replace this value in a following step.
On the data warehouse, run the following SQL statement:
SELECT MAX(ROW_WID)+1 FROM W_PARTY_D
In the reset_infa_seq_gen.bat file, replace the value 1234567
with the value that was returned by the SQL statement.
Obtain the maximum ROW_WID value from W_PRD_OF_WRK_BAND_D:
In the reset_infa_seq_gen.bat file, go to the end of the file and locate the section similar to:
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
Add the following lines after the section referred to in step a:
IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_3000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX1 >>sequence_gen_update.bat IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_4000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX2 >>sequence_gen_update.bat
In the code example, note the values MAX1 and MAX2. You will replace these values in a following step.
On the data warehouse, run the following SQL statements:
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_EMP'
The value returned from the SQL statement above corresponds to MAX1.
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_CWK'
The value returned from the SQL statement above corresponds to MAX2.
In the reset_infa_seq_gen.bat file, replace the values MAX1 and MAX2 with the values returned by the SQL statements.
Execute reset_infa_seq_gen.bat.
Follow this procedure if your Oracle Business Analytics Warehouse is on a Teradata database and your Informatica Repository is on an Oracle database.
This section contains the following topics:
Section D.2.2, "Obtaining ROW_WID from W_ORG_D and W_PRD_OF_WRK_BAND_D"
Section D.2.3, "Obtaining ROW_WID from W_PARTY_D and W_PRD_OF_WRK_BAND_D"
Follow this procedure to enter values for the reset_infa_seq_gen_ORA.bat file to initialize the Informatica sequence generator for incremental runs on the base Informatica Repository (for example, Oracle_BI_DW_Base.rep).
Navigate to OracleBI\dwrep\Upgrade\DbScripts\Teradata.
Open the reset_infa_seq_gen_ORA.bat file.
Enter the appropriate parameter values to reflect your environment (the parameters are database specific).
Table D-4 Teradata Database Parameter Settings for reset_infa_seq_gen_ORA.bat
Parameter | Setting |
---|---|
OLAP_SERVER |
Enter the name of the Teradata Server for the data warehouse database. |
OLAP DATABASE |
Enter the name of the database on which OLAP data is available. |
OLAP USERNAME |
Enter the user ID of the data warehouse database. |
OLAP PASSWORD |
Enter the password of the data warehouse database. |
INFORMATICA SERVER ADDRESS |
Enter the Informatica Server host address. |
INFORMATICA REPOSITORY DB USERNAME |
Enter the user ID of the base Informatica Repository database. |
INFORMATICA REPOSITORY DB PASSWORD |
Enter the password @connection string of the base Informatica Repository database. |
INFORMATICA REPOSITORY |
Enter the name of the base Informatica Repository. |
INFORMATICA REPOSITORY USERNAME |
Enter the user ID of the base Informatica Repository. |
INFORMATICA REPOSITORY PASSWORD |
Enter the password for the base Informatica Repository. |
INFORMATICA FOLDER |
For all source systems except Siebel Industry Applications, enter the value For Siebel Industry Applications, you need to run reset_infa_seq_gen_ORA.bat twice. For the first execution, enter the value |
INFORMATICA PORT |
Enter the port number for the Repository Service. The default is 6001. |
After you complete this step, proceed to one of the following sections:
Follow the steps in Section D.2.2, "Obtaining ROW_WID from W_ORG_D and W_PRD_OF_WRK_BAND_D" if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.9.5, 7.9.5.1, or 7.9.6.
Follow the steps in Section D.2.3, "Obtaining ROW_WID from W_PARTY_D and W_PRD_OF_WRK_BAND_D" if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.6.1, 7.9.6.2, or 7.9.6.3.
Do not execute reset_infa_seq_gen_ORA.bat until you have completed the procedures in either Section D.2.2 or Section D.2.3.
Follow this procedure to obtain the maximum ROW_WID value from W_ORG_D and from W_PRD_OF_WRK_BAND_D if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.9.5, 7.9.5.1, or 7.9.6.
Note: If you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.6.1, 7.9.6.2, or 7.9.6.3, follow the steps in Section D.2.3, "Obtaining ROW_WID from W_PARTY_D and W_PRD_OF_WRK_BAND_D."
Obtain the maximum ROW_WID value from W_ORG_D:
In the reset_infa_seq_gen_ORA.bat file, go to the end of the file and locate the section similar to
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
In the code example, note the value 1234567
. You will replace this value in a following step.
On the data warehouse, run the following SQL statement:
SELECT MAX(ROW_WID)+1 FROM W_ORG_D
In the reset_infa_seq_gen_ORA.bat file, replace the value 1234567
with the value that was returned by the SQL statement.
Obtain the maximum ROW_WID value from W_PRD_OF_WRK_BAND_D:
In the reset_infa_seq_gen_ORA.bat file, go to the end of the file and locate the section similar to:
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
Add the following lines after the section referred to in step a:
IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_3000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX1 >>sequence_gen_update.bat IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_4000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX2 >>sequence_gen_update.bat
In the code example, note the values MAX1 and MAX2. You will replace these values in a following step.
On the data warehouse, run the following SQL statements:
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_EMP'
The value returned from the SQL statement above corresponds to MAX1.
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_CWK'
The value returned from the SQL statement above corresponds to MAX2.
In the reset_infa_seq_gen_ORA.bat file, replace the values MAX1 and MAX2 with the values returned by the SQL statements.
Execute reset_infa_seq_gen_ORA.bat.
Follow this procedure to obtain the maximum ROW_WID value from W_PARTY_D and from W_PRD_OF_WRK_BAND_D if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.6.1, 7.9.6.2, or 7.9.6.3.
Note: If you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.9.5, 7.9.5.1, or 7.9.6, follow the steps in Section D.2.2, "Obtaining ROW_WID from W_ORG_D and W_PRD_OF_WRK_BAND_D."
Obtain the maximum ROW_WID value from W_ORG_D:
In the reset_infa_seq_gen_ORA.bat file, go to the end of the file and locate the section similar to
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
In the code example, note the value 1234567
. You will replace this value in a following step.
On the data warehouse, run the following SQL statement:
SELECT MAX(ROW_WID)+1 FROM W_PARTY_D
In the reset_infa_seq_gen_ORA.bat file, replace the value 1234567
with the value that was returned by the SQL statement.
Obtain the maximum ROW_WID value from W_PRD_OF_WRK_BAND_D:
In the reset_infa_seq_gen_ORA.bat file, go to the end of the file and locate the section similar to:
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
Add the following lines after the section referred to in step a:
IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_3000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX1 >>sequence_gen_update.bat IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_4000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX2 >>sequence_gen_update.bat
In the code example, note the values MAX1 and MAX2. You will replace these values in a following step.
On the data warehouse, run the following SQL statements:
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_EMP'
The value returned from the SQL statement above corresponds to MAX1.
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_CWK'
The value returned from the SQL statement above corresponds to MAX2.
In the reset_infa_seq_gen_ORA.bat file, replace the values MAX1 and MAX2 with the values returned by the SQL statements.
Execute reset_infa_seq_gen_ORA.bat.
Follow this procedure if your Oracle Business Analytics Warehouse is on a Teradata database and your Informatica Repository is on an MSSQL Server database.
This section contains the following topics:
Section D.3.2, "Obtaining ROW_WID from W_ORG_D and W_PRD_OF_WRK_BAND_D"
Section D.3.3, "Obtaining ROW_WID from W_PARTY_D and W_PRD_OF_WRK_BAND_D"
Follow this procedure to enter values for the reset_infa_seq_gen_MSSQL.bat file to initialize the Informatica sequence generator for incremental runs on the base Informatica Repository (for example, Oracle_BI_DW_Base.rep).
Navigate to OracleBI\dwrep\Upgrade\DbScripts\Teradata.
Open the reset_infa_seq_gen_MSSQL.bat file.
Enter the appropriate parameter values to reflect your environment (the parameters are database specific).
Table D-5 Teradata Database Parameter Settings for reset_infa_seq_gen_MSSQL.bat
Parameter | Setting |
---|---|
OLAP_SERVER |
Enter the name of the Teradata Server for the OLAP database. |
OLAP DATABASE |
Enter the name of the database on which OLAP data is available. |
OLAP USERNAME |
Enter the user ID of the data warehouse database. |
OLAP PASSWORD |
Enter the password of the data warehouse database. |
INFORMATICA REPOSITORY SERVER ADDRESS |
Enter the Informatica Repository Service host address. |
INFORMATICA REPOSITORY DB SERVER ADDRESS |
Enter the database address for the Informatica Repository database server in the format <MSSQL Server address>,<port number> For example: or |
INFORMATICA REPOSITORY DATABASE |
Name of the Informatica Repository database. |
INFORMATICA REPOSITORY DB USERNAME |
Enter the user ID of the base Informatica Repository database. |
INFORMATICA REPOSITORY DB PASSWORD |
Enter the password @connection string of the base Informatica Repository database. |
INFORMATICA REPOSITORY |
Enter the name of the base Informatica Repository. |
INFORMATICA REPOSITORY USERNAME |
Enter the user ID of the base Informatica Repository. |
INFORMATICA REPOSITORY PASSWORD |
Enter the password for the base Informatica Repository. |
INFORMATICA FOLDER |
For all source systems except Siebel Industry Applications, enter the value For Siebel Industry Applications, you need to run reset_infa_seq_gen_MSSQL.bat twice. For the first execution, enter the value |
INFORMATICA PORT |
Enter the port number for the Repository Service. The default is 6001. |
After you complete this step, proceed to one of the following sections:
Follow the steps in Section D.3.2, "Obtaining ROW_WID from W_ORG_D and W_PRD_OF_WRK_BAND_D" if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.9.5, 7.9.5.1, or 7.9.6.
Follow the steps in Section D.3.3, "Obtaining ROW_WID from W_PARTY_D and W_PRD_OF_WRK_BAND_D" if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.6.1, 7.9.6.2, or 7.9.6.3.
Do not execute reset_infa_seq_gen_MSSQL.bat until you have completed the procedures in either Section D.3.2 or Section D.3.3.
Follow this procedure to obtain the maximum ROW_WID value from W_ORG_D and from W_PRD_OF_WRK_BAND_D if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.9.5, 7.9.5.1, or 7.9.6.
Note: If you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.6.1, 7.9.6.2, or 7.9.6.3, follow the steps in Section D.3.3, "Obtaining ROW_WID from W_PARTY_D and W_PRD_OF_WRK_BAND_D."
Obtain the maximum ROW_WID value from W_ORG_D:
In the reset_infa_seq_gen_MSSQL.bat file, go to the end of the file and locate the section similar to
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
In the code example, note the value 1234567
. You will replace this value in a following step.
On the data warehouse, run the following SQL statement:
SELECT MAX(ROW_WID)+1 FROM W_ORG_D
In the reset_infa_seq_gen_MSSQL.bat file, replace the value 1234567
with the value that was returned by the SQL statement.
Obtain the maximum ROW_WID value from W_PRD_OF_WRK_BAND_D:
In the reset_infa_seq_gen_MSSQL.bat file, go to the end of the file and locate the section similar to:
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
Add the following lines after the section referred to in step a:
IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_3000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX1 >>sequence_gen_update.bat IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_4000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX2 >>sequence_gen_update.bat
In the code example, note the values MAX1 and MAX2. You will replace these values in a following step.
On the data warehouse, run the following SQL statements:
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_EMP'
The value returned from the SQL statement above corresponds to MAX1.
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_CWK'
The value returned from the SQL statement above corresponds to MAX2.
In the reset_infa_seq_gen_MSSQL.bat file, replace the values MAX1 and MAX2 with the values returned by the SQL statements.
Execute reset_infa_seq_gen_MSSQL.bat.
Follow this procedure to obtain the maximum ROW_WID value from W_PARTY_D and from W_PRD_OF_WRK_BAND_D if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.6.1, 7.9.6.2, or 7.9.6.3.
Note: If you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.9.5, 7.9.5.1, or 7.9.6, follow the steps in Section D.3.2, "Obtaining ROW_WID from W_ORG_D and W_PRD_OF_WRK_BAND_D."
Obtain the maximum ROW_WID value from W_ORG_D:
In the reset_infa_seq_gen_MSSQL.bat file, go to the end of the file and locate the section similar to
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
In the code example, note the value 1234567
. You will replace this value in a following step.
On the data warehouse, run the following SQL statement:
SELECT MAX(ROW_WID)+1 FROM W_PARTY_D
In the reset_infa_seq_gen_MSSQL.bat file, replace the value 1234567
with the value that was returned by the SQL statement.
Obtain the maximum ROW_WID value from W_PRD_OF_WRK_BAND_D:
In the reset_infa_seq_gen_MSSQL.bat file, go to the end of the file and locate the section similar to:
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
Add the following lines after the section referred to in step a:
IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_3000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX1 >>sequence_gen_update.bat IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_4000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX2 >>sequence_gen_update.bat
In the code example, note the values MAX1 and MAX2. You will replace these values in a following step.
On the data warehouse, run the following SQL statements:
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_EMP'
The value returned from the SQL statement above corresponds to MAX1.
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_CWK'
The value returned from the SQL statement above corresponds to MAX2.
In the reset_infa_seq_gen_MSSQL.bat file, replace the values MAX1 and MAX2 with the values returned by the SQL statements.
Execute reset_infa_seq_gen_MSSQL.bat.
Follow this procedure to run the reset_infa_seq_gen.bat file on the Base informatica Repository if your Oracle Business Analytics Warehouse runs on an Oracle, DB2, or MSSQL Server database.
This section contains the following topics:
Section D.4.2, "Obtaining ROW_WID from W_ORG_D and W_PRD_OF_WRK_BAND_D"
Section D.4.3, "Obtaining ROW_WID from W_PARTY_D and W_PRD_OF_WRK_BAND_D"
Follow this procedure to run the reset_infa_seq_gen.bat file to initialize the Informatica sequence generator for incremental runs on the Upgrade repository if your Oracle Business Analytics Warehouse runs on an Oracle, DB2, or MSSQL Server database.
Navigate to OracleBI\dwrep\Upgrade\DbScripts\<database type>.
Open the reset_infa_seq_gen.bat file.
Enter the appropriate parameter values to reflect your environment (the parameters are database specific). See one of the following tables:
Table D-6, "Oracle Database Parameter Settings for reset_infa_seq_gen.bat"
Table D-7, "SQL Server Database Parameter Settings for reset_infa_seq_gen.bat"
Table D-8, "IBM DB2 Database Parameter Settings for reset_infa_seq_gen.bat"
After you complete this step, proceed to one of the following sections:
Follow the steps in Section D.4.2, "Obtaining ROW_WID from W_ORG_D and W_PRD_OF_WRK_BAND_D" if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.9.5, 7.9.5.1, or 7.9.6.
Follow the steps in Section D.4.3, "Obtaining ROW_WID from W_PARTY_D and W_PRD_OF_WRK_BAND_D" if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.6.1, 7.9.6.2, or 7.9.6.3.
Do not execute reset_infa_seq_gen.bat until you have completed the procedures in either Section D.4.2 or Section D.4.3.
Oracle Database Parameter Settings for the Upgrade Informatica Repository
Table D-6 Oracle Database Parameter Settings for reset_infa_seq_gen.bat
Parameter | Setting |
---|---|
OLAP USERNAME |
Enter the data warehouse database user ID. |
OLAP PASSWORD |
Enter the user ID/password@connection string of the data warehouse database. |
INFORMATICA SERVER ADDRESS |
Enter the Informatica Server host address. |
INFORMATICA DATABASE TNSENTRY |
Enter the TNS entry for the Informatica Server database. |
INFORMATICA DB USERNAME |
Enter the user ID of the upgrade Informatica Repository database. |
INFORMATICA DB PASSWORD |
Enter the password@connection string of the upgrade InformaticaRepository database. |
INFORMATICA REPOSITORY |
Enter the name of the upgrade Informatica Repository. |
INFORMATICA REPOSITORY USERNAME |
Enter the user ID of the upgrade Informatica Repository. |
INFORMATICA REPOSITORY PASSWORD |
Enter the password for the upgrade Informatica Repository. |
INFORMATICA FODLER |
Enter the value |
INFORMATICA PORT |
Enter the port number for the Repository Service. The default is 6001. |
SQL Server Database Parameter Settings for the Upgrade Informatica Repository
Table D-7 SQL Server Database Parameter Settings for reset_infa_seq_gen.bat
Parameter | Setting |
---|---|
OLAP_SERVER |
Enter the name of the SQL Server for the OLAP database. |
OLAP DATABASE |
Enter the name of the database on which OLAP data is available. |
OLAP USERNAME |
Enter the user ID of the data warehouse database. |
OLAP PASSWORD |
Enter the user ID/password@connection string of the data warehouse database. |
INFORMATICA DB SERVER ADDRESS |
Enter the Informatica Server host address. |
INFORMATICA DATABASE |
Enter the name of the database in which the upgrade Informatica Repository metadata is available. |
INFORMATICA DB USERNAME |
Enter the user ID of the upgrade Informatica Repository database. |
INFORMATICA DB PASSWORD |
Enter the password @connection string of the upgrade Informatica Repository database. |
INFORMATICA REPOSITORY SERVER ADDRESS |
Enter the name of the machine that runs the Repository Service for the upgrade Repository. |
INFORMATICA REPOSITORY USERNAME |
Enter the user ID of the upgrade Informatica Repository. |
INFORMATICA REPOSITORY PASSWORD |
Enter the password of the upgrade Informatica Repository. |
INFORMATAICA FOLDER |
Enter the value |
INFORMATICA PORT |
Enter the port number for the Repository Service. The default is 6001. |
IBM DB2 Database Parameter Settings for the Upgrade Informatica Repository
Table D-8 IBM DB2 Database Parameter Settings for reset_infa_seq_gen.bat
Parameter | Setting |
---|---|
OLAP USERNAME |
Enter the user ID of the data warehouse database. |
OLAP PASSWORD |
Enter the user ID/password@connection string of the data warehouse database. |
INFA DATABASE ALIAS |
Enter the name of the database in which Informatica Repository metadata is available. |
INFORMATICA DB USERNAME |
Enter the user ID of the upgrade Informatica Repository database. |
INFORMATICA DB PASSWORD |
Enter the password @connection string of the upgrade Informatica Repository database. |
INFORMATICA REPOSITORY |
Enter the name of the upgrade Informatica Repository. |
INFORMATICA REPOSITORY USERNAME |
Enter the user ID of the upgrade Informatica Repository. |
INFORMATICA REPOSITORY PASSWORD |
Enter the password for the upgrade Informatica Repository. |
INFORMATICA SERVER ADDRESS |
Enter the Informatica Server host address. |
INFORMATICA FOLDER |
Enter the value |
INFORMATICA PORT |
Enter the port number for the Repository Service. The default is 6001. |
Follow this procedure to obtain the maximum ROW_WID value from W_ORG_D and from W_PRD_OF_WRK_BAND_D if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.9.5, 7.9.5.1, or 7.9.6.
Note: If you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.6.1, 7.9.6.2, or 7.9.6.3, follow the steps in Section D.4.3, "Obtaining ROW_WID from W_PARTY_D and W_PRD_OF_WRK_BAND_D."
Obtain the maximum ROW_WID value from W_ORG_D:
In the reset_infa_seq_gen.bat file, go to the end of the file and locate the section similar to
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
In the code example, note the value 1234567
. You will replace this value in a following step.
On the data warehouse, run the following SQL statement:
SELECT MAX(ROW_WID)+1 FROM W_ORG_D
In the reset_infa_seq_gen.bat file, replace the value 1234567
with the value that was returned by the SQL statement.
Obtain the maximum ROW_WID value from W_PRD_OF_WRK_BAND_D:
In the reset_infa_seq_gen.bat file, go to the end of the file and locate the section similar to:
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
Add the following lines after the section referred to in step a:
IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_3000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX1 >>sequence_gen_update.bat IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_4000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX2 >>sequence_gen_update.bat
In the code example, note the values MAX1 and MAX2. You will replace these values in a following step.
On the data warehouse, run the following SQL statements:
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_EMP'
The value returned from the SQL statement above corresponds to MAX1.
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_CWK'
The value returned from the SQL statement above corresponds to MAX2.
In the reset_infa_seq_gen.bat file, replace the values MAX1 and MAX2 with the values returned by the SQL statements.
Execute reset_infa_seq_gen.bat.
Follow this procedure to obtain the maximum ROW_WID value from W_PARTY_D and from W_PRD_OF_WRK_BAND_D if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.6.1, 7.9.6.2, or 7.9.6.3.
Note: If you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.9.5, 7.9.5.1, or 7.9.6, follow the steps in Section D.4.2, "Obtaining ROW_WID from W_ORG_D and W_PRD_OF_WRK_BAND_D."
Obtain the maximum ROW_WID value from W_ORG_D:
In the reset_infa_seq_gen.bat file, go to the end of the file and locate the section similar to
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
In the code example, note the value 1234567
. You will replace this value in a following step.
On the data warehouse, run the following SQL statement:
SELECT MAX(ROW_WID)+1 FROM W_PARTY_D
In the reset_infa_seq_gen.bat file, replace the value 1234567
with the value that was returned by the SQL statement.
Obtain the maximum ROW_WID value from W_PRD_OF_WRK_BAND_D:
In the reset_infa_seq_gen.bat file, go to the end of the file and locate the section similar to:
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
Add the following lines after the section referred to in step a:
IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_3000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX1 >>sequence_gen_update.bat IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_4000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX2 >>sequence_gen_update.bat
In the code example, note the values MAX1 and MAX2. You will replace these values in a following step.
On the data warehouse, run the following SQL statements:
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_EMP'
The value returned from the SQL statement above corresponds to MAX1.
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_CWK'
The value returned from the SQL statement above corresponds to MAX2.
In the reset_infa_seq_gen.bat file, replace the values MAX1 and MAX2 with the values returned by the SQL statements.
Execute reset_infa_seq_gen.bat.
Follow this procedure if your Oracle Business Analytics Warehouse is on a Teradata database and your Informatica Repository is on an Oracle database.
This section contains the following topics:
Section D.5.2, "Obtaining ROW_WID from W_ORG_D and W_PRD_OF_WRK_BAND_D"
Section D.5.3, "Obtaining ROW_WID from W_PARTY_D and W_PRD_OF_WRK_BAND_D"
Follow this procedure to enter values for the reset_infa_seq_gen_ORA.bat file to initialize the Informatica sequence generator for incremental runs on the Upgrade Informatica Repository.
Navigate to OracleBI\dwrep\Upgrade\DbScripts\Teradata.
Open the reset_infa_seq_gen_ORA.bat file.
Enter the appropriate parameter values to reflect your environment (the parameters are database specific).
Table D-9 Teradata Database Parameter Settings for reset_infa_seq_gen_ORA.bat
Parameter | Setting |
---|---|
OLAP_SERVER |
Enter the name of the Teradata Server for the OLAP database. |
OLAP DATABASE |
Enter the name of the database on which OLAP data is available. |
OLAP USERNAME |
Enter the user ID of the data warehouse database. |
OLAP PASSWORD |
Enter the password of the data warehouse database. |
INFORMATICA SERVER ADDRESS |
Enter the Informatica Server host address. |
INFORMATICA REPOSITORY DB USERNAME |
Enter the user ID of the Upgrade Informatica Repository database. |
INFORMATICA REPOSITORY DB PASSWORD |
Enter the password @connection string of the Upgrade Informatica Repository database. |
INFORMATICA REPOSITORY |
Enter the name of the Upgrade Informatica Repository. |
INFORMATICA REPOSITORY USERNAME |
Enter the user ID of the Upgrade Informatica Repository. |
INFORMATICA REPOSITORY PASSWORD |
Enter the password for the Upgrade Informatica Repository. |
INFORMATICA FOLDER |
For all source systems except Siebel Industry Applications, enter the value For Siebel Industry Applications, you need to run reset_infa_seq_gen_ORA.bat twice. For the first execution, enter the value |
INFORMATICA PORT |
Enter the port number for the Repository Service. The default is 6001. |
After you complete this step, proceed to one of the following sections:
Follow the steps in Section D.5.2, "Obtaining ROW_WID from W_ORG_D and W_PRD_OF_WRK_BAND_D" if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.9.5, 7.9.5.1, or 7.9.6.
Follow the steps in Section D.5.3, "Obtaining ROW_WID from W_PARTY_D and W_PRD_OF_WRK_BAND_D" if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.6.1, 7.9.6.2, or 7.9.6.3.
Do not execute reset_infa_seq_gen_ORA.bat until you have completed the procedures in either Section D.5.2 or Section D.5.3.
Follow this procedure to obtain the maximum ROW_WID value from W_ORG_D and from W_PRD_OF_WRK_BAND_D if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.9.5, 7.9.5.1, or 7.9.6.
Note: If you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.6.1, 7.9.6.2, or 7.9.6.3, follow the steps in Section D.5.3, "Obtaining ROW_WID from W_PARTY_D and W_PRD_OF_WRK_BAND_D."
Obtain the maximum ROW_WID value from W_ORG_D:
In the reset_infa_seq_gen_ORA.bat file, go to the end of the file and locate the section similar to
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
In the code example, note the value 1234567
. You will replace this value in a following step.
On the data warehouse, run the following SQL statement:
SELECT MAX(ROW_WID)+1 FROM W_ORG_D
In the reset_infa_seq_gen_ORA.bat file, replace the value 1234567
with the value that was returned by the SQL statement.
Obtain the maximum ROW_WID value from W_PRD_OF_WRK_BAND_D:
In the reset_infa_seq_gen_ORA.bat file, go to the end of the file and locate the section similar to:
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
Add the following lines after the section referred to in step a:
IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_3000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX1 >>sequence_gen_update.bat IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_4000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX2 >>sequence_gen_update.bat
In the code example, note the values MAX1 and MAX2. You will replace these values in a following step.
On the data warehouse, run the following SQL statements:
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_EMP'
The value returned from the SQL statement above corresponds to MAX1.
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_CWK'
The value returned from the SQL statement above corresponds to MAX2.
In the reset_infa_seq_gen_ORA.bat file, replace the values MAX1 and MAX2 with the values returned by the SQL statements.
Execute reset_infa_seq_gen_ORA.bat.
Follow this procedure to obtain the maximum ROW_WID value from W_PARTY_D and from W_PRD_OF_WRK_BAND_D if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.6.1, 7.9.6.2, or 7.9.6.3.
Note: If you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.9.5, 7.9.5.1, or 7.9.6, follow the steps in Section D.5.2, "Obtaining ROW_WID from W_ORG_D and W_PRD_OF_WRK_BAND_D."
Obtain the maximum ROW_WID value from W_ORG_D:
In the reset_infa_seq_gen_ORA.bat file, go to the end of the file and locate the section similar to
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
In the code example, note the value 1234567
. You will replace this value in a following step.
On the data warehouse, run the following SQL statement:
SELECT MAX(ROW_WID)+1 FROM W_PARTY_D
In the reset_infa_seq_gen_ORA.bat file, replace the value 1234567
with the value that was returned by the SQL statement.
Obtain the maximum ROW_WID value from W_PRD_OF_WRK_BAND_D:
In the reset_infa_seq_gen_ORA.bat file, go to the end of the file and locate the section similar to:
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
Add the following lines after the section referred to in step a:
IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_3000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX1 >>sequence_gen_update.bat IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_4000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX2 >>sequence_gen_update.bat
In the code example, note the values MAX1 and MAX2. You will replace these values in a following step.
On the data warehouse, run the following SQL statements:
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_EMP'
The value returned from the SQL statement above corresponds to MAX1.
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_CWK'
The value returned from the SQL statement above corresponds to MAX2.
In the reset_infa_seq_gen_ORA.bat file, replace the values MAX1 and MAX2 with the values returned by the SQL statements.
Execute reset_infa_seq_gen_ORA.bat.
Follow this procedure if your Oracle Business Analytics Warehouse is on a Teradata database and your Informatica Repository is on an MSSQL Server database.
This section contains the following topics:
Section D.6.2, "Obtaining ROW_WID from W_ORG_D and W_PRD_OF_WRK_BAND_D"
Section D.6.3, "Obtaining ROW_WID from W_PARTY_D and W_PRD_OF_WRK_BAND_D"
Follow this procedure to enter values for the reset_infa_seq_gen_MSSQL.bat file to initialize the Informatica sequence generator for incremental runs on the Upgrade Informatica Repository.
Navigate to OracleBI\dwrep\Upgrade\DbScripts\Teradata.
Open the reset_infa_seq_gen_MSSQL.bat file.
Enter the appropriate parameter values to reflect your environment (the parameters are database specific).
Table D-10 Teradata Database Parameter Settings for reset_infa_seq_gen_MSSQL.bat
Parameter | Setting |
---|---|
OLAP_SERVER |
Enter the name of the Teradata Server for the OLAP database. |
OLAP DATABASE |
Enter the name of the database on which OLAP data is available. |
OLAP USERNAME |
Enter the user ID of the data warehouse database. |
OLAP PASSWORD |
Enter the password of the data warehouse database. |
INFORMATICA REPOSITORY SERVER ADDRESS |
Enter the UPgrade Informatica Repository Service host address. |
INFORMATICA REPOSITORY DB SERVER ADDRESS |
Enter the database address for the Upgrade Informatica Repository database server in the format <MSSQL Server addres>,<port number> For example: or |
INFORMATICA REPOSITORY DATABASE |
Name of the UPgrade Informatica Repository database. |
INFORMATICA REPOSITORY DB USERNAME |
Enter the user ID of the Upgrade Informatica Repository database. |
INFORMATICA REPOSITORY DB PASSWORD |
Enter the password @connection string of the Upgrade Informatica Repository database. |
INFORMATICA REPOSITORY |
Enter the name of the Upgrade Informatica Repository. |
INFORMATICA REPOSITORY USERNAME |
Enter the user ID of the Upgrade Informatica Repository. |
INFORMATICA REPOSITORY PASSWORD |
Enter the password for the Upgrade Informatica Repository. |
INFORMATICA FOLDER |
For all source systems except Siebel Industry Applications, enter the value For Siebel Industry Applications, you need to run reset_infa_seq_gen_MSSQL.bat twice. For the first execution, enter the value |
INFORMATICA PORT |
Enter the port number for the Repository Service. The default is 6001. |
After you complete this step, proceed to one of the following sections:
Follow the steps in Section D.6.2, "Obtaining ROW_WID from W_ORG_D and W_PRD_OF_WRK_BAND_D" if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.9.5, or 7.9.5.1, or 7.9.6.
Follow the steps in Section D.6.3, "Obtaining ROW_WID from W_PARTY_D and W_PRD_OF_WRK_BAND_D" if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.6.1, 7.9.6.2, or 7.9.6.3.
Do not execute reset_infa_seq_gen_MSSQL.bat until you have completed the procedures in either Section D.6.2 or Section D.6.3.
Follow this procedure to obtain the maximum ROW_WID value from W_ORG_D and from W_PRD_OF_WRK_BAND_D if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.9.5, 7.9.5.1, or 7.9.6.
Note: If you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.6.1, 7.9.6.2, or 7.9.6.3, follow the steps in Section D.6.3, "Obtaining ROW_WID from W_PARTY_D and W_PRD_OF_WRK_BAND_D."
Obtain the maximum ROW_WID value from W_ORG_D:
In the reset_infa_seq_gen_MSSQL.bat file, go to the end of the file and locate the section similar to
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
In the code example, note the value 1234567
. You will replace this value in a following step.
On the data warehouse, run the following SQL statement:
SELECT MAX(ROW_WID)+1 FROM W_ORG_D
In the reset_infa_seq_gen_MSSQL.bat file, replace the value 1234567
with the value that was returned by the SQL statement.
Obtain the maximum ROW_WID value from W_PRD_OF_WRK_BAND_D:
In the reset_infa_seq_gen_MSSQL.bat file, go to the end of the file and locate the section similar to:
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
Add the following lines after the section referred to in step a:
IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_3000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX1 >>sequence_gen_update.bat IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_4000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX2 >>sequence_gen_update.bat
In the code example, note the values MAX1 and MAX2. You will replace these values in a following step.
On the data warehouse, run the following SQL statements:
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_EMP'
The value returned from the SQL statement above corresponds to MAX1.
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_CWK'
The value returned from the SQL statement above corresponds to MAX2.
In the reset_infa_seq_gen_MSSQL.bat file, replace the values MAX1 and MAX2 with the values returned by the SQL statements.
Execute reset_infa_seq_gen_MSSQL.bat.
Follow this procedure to obtain the maximum ROW_WID value from W_PARTY_D and from W_PRD_OF_WRK_BAND_D if you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.6.1, 7.9.6.2, or 7.9.6.3.
Note: If you are in an upgrade phase in which you are upgrading to Oracle BI Applications version 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.9.5, 7.9.5.1, or 7.9.6, follow the steps in Section D.6.2, "Obtaining ROW_WID from W_ORG_D and W_PRD_OF_WRK_BAND_D."
Obtain the maximum ROW_WID value from W_ORG_D:
In the reset_infa_seq_gen_MSSQL.bat file, go to the end of the file and locate the section similar to
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
In the code example, note the value 1234567
. You will replace this value in a following step.
On the data warehouse, run the following SQL statement:
SELECT MAX(ROW_WID)+1 FROM W_PARTY_D
In the reset_infa_seq_gen_MSSQL.bat file, replace the value 1234567
with the value that was returned by the SQL statement.
Obtain the maximum ROW_WID value from W_PRD_OF_WRK_BAND_D:
In the reset_infa_seq_gen_MSSQL.bat file, go to the end of the file and locate the section similar to:
IF %INFA_REP%==UPGRADE echo pmrep Updateseqgenvals -f"UPGRADE_7951_to_796_SBL" -t Seq_W_PARTY_D_Wid -c 1234567 >>sequence_gen_update.bat.
Add the following lines after the section referred to in step a:
IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_3000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX1 >>sequence_gen_update.bat IF %INFA_FOLDER%==HOR echo pmrep Updateseqgenvals -f "SILOS" -m SIL_PeriodOfWorkBandDimension -t Seq_4000_Plus_Sequence_Prd_Of_Wrk_Band -c MAX2 >>sequence_gen_update.bat
In the code example, note the values MAX1 and MAX2. You will replace these values in a following step.
On the data warehouse, run the following SQL statements:
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_EMP'
The value returned from the SQL statement above corresponds to MAX1.
select max(ROW_WID)+1 from W_PRD_OF_WRK_BAND_D where level_id = 'POW_BAND_CWK'
The value returned from the SQL statement above corresponds to MAX2.
In the reset_infa_seq_gen_MSSQL.bat file, replace the values MAX1 and MAX2 with the values returned by the SQL statements.
Execute reset_infa_seq_gen_MSSQL.bat.