2 Payments Scripts

This topic provides overview of the PAYMENTS SCRIPTS that requires manual execution in the database.

Post OBPM database installation, below are the list of properties to be updated in the payments table:
  1. Update PMTM_JOB_PARAM table.
    • UPDATE PMTM_JOB_PARAM SET PARAM_VALUE = 't3://10.10.10.10:1010' WHERE PARAM_NAME = 'PM.CTX.PROVIDER';;

      replace “t3://10.10.10.10:1010” with “t3://Weblogic_IP:Server_Port” or“t3://hostname:Server_Port

    • For PM.CTX.CONNFACTORY the appropriate connection factory needs to be provided. For example: jms/PMQCF.
  2. Create or Update the PMTM_SYSTEM_PARAMETERS table changes in the PMDSYSPM screen.
    For Parameter name and value, refer to the PMTM_SYSTEM_PARAMETERS table.

    Table 2-1 PMTM_SYSTEM_PARAMETERS

    PARAM_NAME PARAM_VALUE
    PM.CTX.FACTORY

    For Weblogic, the value is weblogic.jndi.WLInitialContextFactory

    For Websphere, the value is com.ibm.websphere.naming.WsnInitialContextFactory
    PM_CTX_PROVIDER

    For Weblogic, the value is t3:// Weblogic_IP:Server_Port or t3://hostname:Server_Port
    PM.CTX.CONNFACTORY

    The appropriate connection factory value needs to be provided which is created in the JMS Server.

    For Example: jms/PMQCF
    C2B_FILE_PATH Enter the C2B path maintained in the server.
    DD_FILE_PATH Enter the DD path maintained in the server.
    DEBUG_PATH Enter the PM DEBUG path maintained in the server.
    DISPATCH_PATH Enter the DISPATCH path maintained in the server.
    DEBUG_LEVEL

    OFF / DEBUG / SEVERE / INFO – Set as per the log level required.
    REST_BASE_URL_MS

    Configure a valid URL for the OBPM API Gateway Router.

    Example: http://0.0.0.0:0000/obpm-api-gateway/

    Replace the IP/Host and Port Number appropriately.

  3. Update the CSTM_EXTERNAL_SERVER_DETAILS table.
    • For the field CONTEXT_PROV_URL, update the values in the weblogic application server as follows:
      • Non-Clustered Setup: Update the value as t3:// Weblogic_IP:Server_Port or t3://Host Name:Server_Port
      • Cluster Setup: Update the value as t3://HOSTNAME1: PORT 1,HOST NAME2:PORT 2.
    • Maintain the QUEUE_FCTRY_JNDI value as jms/PMQCF.
    • Maintain the CACHE_QUEUE_JNDI value as jms/CACHE_TOPIC.
  4. Log Configuration:
    • PLATO_LOGGER_PARAM_CONFIG: Update LOG_PATH and LOG_LEVEL appropriately.
    • PLATO_DEBUG_USERS: Insert the user and service entries to enable the service level log file generation.