Modules Impacting With Change of APPS and WCI Schema Passwords Reset

1.      Modules Impacting With Change of APPS and WCI Schema Passwords Reset

1.1      Data sources

1.       Open the Weblogic Console.

2.       Click on Lock and Edit.

3.       Go to DataSources àClick on each DataSource à Connection Pool à Change password à Click on save.

4.       Repeat all steps for all the DataSources and finally click on “Active Changes”.

5.       If promted, restart the Admin Server.

1.2      ODC – With Import Server

1.       Pause the Import Server either from services or directly from the server settings.

2.       Click on Setup à Batch Setup

3.       Select Configure à Configure DB Connection à Change the password in the password field.

4.       Restart the Import Server.

1.3      ODC – Without Import Server (Scanner Machines)

1.       Open Registry Editor (REGEDIT).

2.       Go to the registry key: (for 32-bit systems) - "HKEY_LOCAL_MACHINE\SOFTWARE\Captovation\eCapture\Imaging Systems\eCapture" (for 64-bit systems) - "HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432NODE\Captovation\eCapture\Imaging Systems\eCapture".

3.       Rename the registry setting: "ConnectString" to "ConnectString01".

4.       Close the registry editor.

5.       Reopen Capture. The user should be prompted to configure the Batch Setup options. 

6.       Configure the database connection settings and ensure "Allow saving password" is selected. (The details can be coped over from ODC servers)

1.4      ODC – Change in the database lookups

1.       Open Oracle Document Capture.

2.       Open file cabinets.

3.       From the window Open Commit profile “INVSupplemental” using path “File Cabinets” -> “INVSupplemental”    -> “Database Lookups” -> “Invoices_Suppliers”

a.        Click on “Configure” button

b.       Check the value of below fields and correct them

                                                               i.      Data Source – sd12t

                                                              ii.      Enter information to log on to the server – select 2^nd option “Use a specific user name and password”

                                                            iii.      Username- apps

                                                            iv.      Password – Get it from UAT configuration excel.

                                                              v.      Check the check box against “Allow saving password”

c.        Click on “Test Connection” button.

d.       This should show you the successful message.

                                                               i.      Click on OK for this popup

e.       Click on “OK” on the window “Data Link Properties”

4.       Repeat steps 3 and 4 for supplier documents also.

a.        Use path “File Cabinets” -> “Supplier Documents”    -> “Database Lookups” -> “Suppliers”

1.5 OFR

1.       Change the passwords in the “ini” file. Please find below the snippet.

SQL_VL_01_ConnectionString=Provider=OraOLEDB.Oracle;Data Source=SD12T;UserIdDd=APPS;Password=Aztec1areonfire#;

SQL_VL_02_ConnectionString=Provider=OraOLEDB.Oracle;Data Source=SD12T;User Id=WCITEST_ODC;Password=TodayisFeb25th#;

SQL_VL_03_ConnectionString=Provider=OraOLEDB.Oracle;Data Source=SD12T;User Id=APPS;Password=Aztec1areonfire#;

ASA_VL_01_ImportODBCUser=APPS

ASA_VL_01_ImportODBCPWD=Aztec1areonfire#

2.       After making changes to .INI file, double click on .sdb file and click on ‘save’ button in OFR designer to take the changes in effect.

3.       Update vendor pool manually, save the project and restart OFR services (RTS and Monitoring).