4 Troubleshooting Application Workflows

This topic describes the troubleshooting functional workflows applicable to Oracle Banking Liquidity Management.

This topic contains the following subtopics:

4.1 Oracle Banking Liquidity Management – Subdomains List

This topic describes about the Oracle Banking Liquidity Management Subdomains List.

The subdomains of Oracle Banking Liquidity Management are shown below

Figure 4-1 Composition of Oracle Banking Liquidity Management



4.2 Micro Frontend Architecture

This topic describes about the Micro Frontend Architecture

The Micro Frontend Architectures of Oracle Banking Liquidity Management are shown below:

Figure 4-2 UI – Micro Frontend Architecture



Figure 4-3 Services – Micro Frontend Architecture



On successful login, the Oracle Banking Liquidity Management dashboard screen appears depending on the user privileges.

Figure 4-4 Oracle Banking Liquidity Management Dashboard



  • User Role Issues

    Role Profile includes access rights to the functional activities that are common to a group of users. A user can be linked to a Role Profile by which you give the user access rights to all the functional activities in the Role Profile.

From Home screen, click Security Management. Under Security Management, click Role.

Only authorized users can access the system with the help of a unique User Login ID and password. The user profile of a user contains the details of the user in four sections - User details, Status, Other details and User role branches.

From Home screen, click Security Management. Under Security Management, click Role.

Note:

Make sure that the required Role and User Applications are mapped to the user.

4.2.1 First level issues

This topic describes the possible issues that may occur during the basic investigation.

This topic contains the following subtopics:

4.2.1.1 Error Message not shown

This topic describes about Error Message not shown.

If there are any improper calls, check the ERTB_MSGS table of the respective schema to understand the cause of the error.

  1. Press F12 to open the Networks.
  2. Check the error code in the response.

Query: SELECT * FROM ERTB_MSGS WHERE ERR_CODE=’GCS_AUTH-03’

4.2.1.2 Setting Log file path

This topic describes about Setting Log file path.

Log generation path needs to be defined in PLATO_LOGGER_PARAM_CONFIG table of PLATO schema.

Query: Select * from PLATO_LOGGER_PARAM_CONFIG;

Figure 4-8 PLATO_LOGGER_PARAM_CONFIG



4.2.1.3 Dynamic log generation issues

This topic describes about Dynamic log generation issues.

For generating dynamic service logs, insert the data to PLATO_DEBUG_USERS table.

Query: Select * from PLATO_DEBUG_USERS;

Figure 4-9 Service Logs



Note:

Login to WINSCP and check server logs. Log files for each service will be generated based on the user_id, branch_code and date at the path provided in the plato_logger_param_config table
4.2.1.4 Call is failing in Gateway

This topic describes about Call is failing in Gateway.

If any API call is failing in Gateway, hit the same API endpoint without passing through api-gateway via the postman.

Note:

Restart the specific services if required.
4.2.1.5 Logs are not generated

This topic describes about Logs are not generated.

If you are not getting logs, put the loggers across API, hit through postman, and test again.

4.2.1.6 Code error in GCS side

This topic describes about the error code in GCS Side.

If there is any error in GCS side codes, use java de-complier to debug the error.

4.2.1.7 404 Error

This topic describes about the 404 Error

The possible causes for 404 error are as follows:
  • Check service is not running on Eureka
  • Check if service is deployed in Weblogic
4.2.1.8 500 Internal Error

This topic describes about the 500 Internal Error

The possible causes for 500 internal error are as follows:
  • Issue with Plato entries
  • Issue with Eureka
  • Service may not be up
  • Issue with any peace of code

The server side debugging is needed for the above-mentioned issues, if it is not captured in logs.

4.2.2 Transaction Data Verification

This topic provides the systematic instruction to verify the transaction data.

Follow the best practices mentioned below to avoid getting any errors:

  1. In the IN request and OUT response, verify that all the field data is going to service side.
  2. If there is any error related to SMS, check for the availability of SMS entries.
  3. Validate the endpoints and data.
  4. Validate the request headers passed during the API call.
  5. Verify that the data entered in the screen is accurate.
    For example: The Account Number should be valid.

4.3 Payment Service Integration Troubleshooting

The topic describes the possible issues that may occur in payment service integration.

The possible issues and causes are described in the following subtopics:

4.3.1 Balance Fetch (FCUBS) is failing

This topic describes about the Balance Fetch (FCUBS) is failing.

If Balance Fetch call (FCUBS) is failing, check the lmx_tb_messageLlog table for the request and response xml. Execute the following query to verify results:

SELECT * FROM LMX_TB_MESSAGE_LOG WHERE EXTSYSLOG_ID IN (SELECT ID FROM LMX_TB_EXTERNAL_SYSTEM_LOG WHERE STRUCTURE_ID = 'ST2021218141725' and METHOD_NAME='BALANCEREQ') AND MSG_LOGDATE='23-FEB-21'

Figure 4-14 Balance Fetch (FCUBS) is failing



4.3.2 Accounting call (FCUBS) is failing

This topic describes about the Accounting call (FCUBS) is failing

If accounting call (FCUBS) is failing, check the LMX_TB_MESSAGE_LOG table for the request and response xml. Execute the following query to verify results:

SELECT * FROM LMX_TB_MESSAGE_LOG WHERE EXTSYSLOG_ID IN (SELECT ID FROM LMX_TB_EXTERNAL_SYSTEM_LOG WHERE STRUCTURE_ID = 'ST2021218141725' and METHOD_NAME=' FCUBSIFSERVICEFSFS') AND MSG_LOGDATE='23-FEB-21'

Figure 4-15 Account calling (FCUBS) is failing



4.3.3 OBPM call is failing

This topic describes about the OBPM call is failing

If OBPM call is failing, check the LMX_TB_MESSAGE_LOG table for the request and response xml. Execute the following query to verify results:

SELECT * FROM LMX_TB_MESSAGE_LOG WHERE EXTSYSLOG_ID IN (SELECT ID FROM LMX_TB_EXTERNAL_SYSTEM_LOG WHERE STRUCTURE_ID = 'ST2021218141725' AND MET

4.4 Troubleshooting SMS Errors

This topic describes about Troubleshooting SMS Errors.

The possible issues occur in Security Management System are mentioned below.
  • Unable to login after launching the application.
  • Menus are not displayed after logging in.

4.5 Oracle Banking Routing Hub Configuration

This topic describes about Oracle Banking Routing Hub configuration.

Refer to Routing Hub Configuration User Guide for the detailed explanation.