5 SOAP Web Service Consumer Implementation

This chapter gives an overview about the SOAP Web service Consumer Implementation API designs used in the RMS environment and various functional attributes used in the APIs.

GL Account Validation Service

This section describes the GA account validation service.

Functional Area

Financial Integration

Business Overview

RMS holds the general ledger chart of account (GLCOA) information in the FIF_GL_ACCT table. A chart of account is essentially the financial application's debit and credit account segments (for example, company, cost center, account, and so on) that apply to the RMS product hierarchy. In some financial applications, this is known as code combination IDs (CCID). The GL Cross Reference form is then used to associate the appropriate department, class, subclass, and location data to a CCID and to populate that data to the GL_FIF_CROSS_REF table.

From RMS's GL Cross Reference form, RMS invokes a GL Account Validation Web service to validate the general ledger chart of accounts information against an external financial application. The segments like department, class, subclass and location cross reference to a CCID can only be established if the account is valid for the same segment combination in financial application.

This document describes the GL Account Validation Web service integration between RMS and an external financial application. In this integration context, RMS acts as the service consumer that invokes a Web service hosted by an external financial application.

Package Impact

The process flow for the Web service API.

Figure 5-1 Process Flow for Web Service API

Public API Procedures

Filename: rmsaiapub_coavals/b.pls

ACC_VALIDATE_API.VALIDATE_ACC
    (O_error_message    OUT    RTK_ERRORS.RTK_TEXT%TYPE,
     O_acc_val_rec   IN OUT    ACC_VALIDATE_API.ACC_VALIDATE_TBL)
RETURN BOOLEAN;

This function validates the segments, set_of_book_id and ccid combination in the input collection. It invokes AIA_WEBSERVICE_SQL.VALIDATE_ACCOUNT to do that.

Filename: rmsaiapub_dbcoawebss/b.pls

VALIDATE_ACCOUNT
    (O_error_message        IN OUT   RTK_ERRORS.RTK_TEXT%TYPE,
     O_requesting_system    IN OUT   VARCHAR2,
     O_set_of_books_id      IN OUT   ORG_UNIT.SET_OF_BOOKS_ID%TYPE,
     O_ccid                 IN OUT   FIF_GL_CROSS_REF.DR_CCID%TYPE,
     O_segment1             IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment2             IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment3             IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment4             IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment5             IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment6             IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment7             IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment8             IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment9             IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment10            IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment11            IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment12            IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment13            IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment14            IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment15            IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment16            IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment17            IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment18            IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment19            IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_segment20            IN OUT   FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     O_account_status       IN OUT   VARCHAR2,
     I_requesting_system    IN       VARCHAR2,
     I_set_of_books_id      IN       ORG_UNIT.SET_OF_BOOKS_ID%TYPE,
     I_ccid                 IN       FIF_GL_CROSS_REF.DR_CCID%TYPE,
     I_segment1             IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment2             IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment3             IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment4             IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment5             IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment6             IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment7             IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment8             IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment9             IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment10            IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment11            IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment12            IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment13            IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment14            IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment15            IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment16            IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment17            IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment18            IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment19            IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE,
     I_segment20            IN       FIF_GL_CROSS_REF.DR_SEQUENCE1%TYPE)
RETURN BOOLEAN;

This function validates the segments, set_of_book_id and ccid combination in the input. It invokes the RSE generated service contract as defined in the GlAccountValidationServiceCons package to make a secure Web service call.

The service function that validates the account (validateGlAccount takes an OBJ_GLACCTCOLDESC as the input and returns OBJ_GLACCTCOLREF as the output. The structure of the objects is also defined in the service contract.

Message XSD

NA

Design Assumptions

None

Table Impact

NA