21.1 Troubleshooting the Problems

1. Problem: Batch Failed to Execute.

   Solution: Before executing a batch, check if the following services are running on the Application Server (For more information on how to check if the services are up and on, and how to start the services if you find them not running, see the Oracle Financial Services Analytical Applications Infrastructure User Guide).

   • Iccserver
   • Router
   • AM
   • Messageserver
2. Problem: SCD is not processing a particular Hierarchy.

   Solution: If SCD wants to process a DIM_PRODUCT Hierarchy SYS ID (say 1000018711), then the entry should be available in the table SETUP_MASTER as:

   Table 21-1 Hierarchy SYS ID

   V_COMPONENT_CODE	V_COMPONENT_DESC	V_COMPONENT_VALUE
   22	PRODUCT_HIER1	1000018711

   For more information, see the tables used by the SCD Component section.

3. Problem: During the execution of the ALMBI Transformation, the program may not complete successfully.

   Solution: Check for the existence of the PROCESS_ID and LAST_RUN_AS_OF_DATE combination in the FSI_PROCESS_RUN_HISTORY table.

   The following SQL Query can be executed to check the status:

   "SELECT * FROM FSI_PROCESS_RUN_HISTORY"

4. Problem: Failed to execute ALMBI Transformation after the SCD Process has run.

   Solution: Execute DIM_RUN Population, as mentioned in the section before ALMBI Transformation.

   The following SQL Query can be executed to check the existence of the process in the DIM_RUN table:

   SELECT * FROM DIM_RUN WHERE V_RUN_ID = '<PROCESS_ID>'.