Siebel CRM Integration to Oracle FLEXCUBE Universal Banking Implementation Guide > EBM Mappings Used in Online Synchronization >

QueryLineOfCreditEBM


The QueryLineOfCreditEBM integration objects, associated with the LineOfCredit EBO, are used in query operations in the Integration to retrieve limit information from Oracle FLEXCUBE Universal Banking. The application mappings used by the QueryLineOfCreditEBM integration objects for the query operation are described in this topic.

Operation

Query

Service Consumer

Siebel CRM

Service Provider

Oracle FLEXCUBE Universal Banking

EBM Request and Response Operational Elements
  • QueryLineOfCreditEBM
  • QueryLineOfCreditResponseEBM

Information about the QueryLineOfCreditEBM request-and-response messages is provided in the following topics.

QueryLineOfCreditEBM

Table 31 lists the mapping information for the QueryLineOfCreditEBM.

Table 31. QueryLineOfCreditEBM
XML Path
Oracle FLEXCUBE Service Name
Oracle FLEXCUBE Interface Object
Oracle FLEXCUBE Interface Column
Siebel Contact Business Component
Siebel Contact
Field

/Identification
/AlternateObject
Key/ID

LSFacilityService

GE-FacilityExecuteQuery-Req-Full-MSG.xsd

GEM_REQ_ENV/GEM_BODY/Facility-Full/LIABID

FINS BIB Account

FINS BIB Contact

Liability Number

/Identification/ID

LSFacilityService

GE-FacilityExecuteQuery-Req-Full-MSG.xsd

GEM_REQ_ENV/GEM_BODY/Facility-Full/LINECODE

GEM_REQ_ENV/GEM_BODY/Facility-Full/LINESERIAL

FINS BIB Limit Details

Line ID

/Identification/ContextID

LSFacilityService

GE-FacilityExecuteQuery-Req-Full-MSG.xsd

GEM_REQ_ENV/GEM_BODY/Facility-Full/LIABBR

FINS BIB Account

FINS BIB Contact

Branch Code

QueryLineOfCreditResponseEBM

Table 32 lists the mapping information for the QueryLineOfCreditResponseEBM.

Table 32. QueryLineOfCreditResponseEBM
XML Path
Oracle FLEXCUBE Service Name
Oracle FLEXCUBE Interface Object
Oracle FLEXCUBE Interface Column
Siebel Contact Business Component
Siebel Contact
Field

/Identification/ID

LSFacilityService

GE-Facility
ExecuteQuery-Res-Full-MSG.xsd

GEM_RES_ENV/GEM_BODY/Facility-Full/LINECODE

GEM_RES_ENV/GEM_BODY/Facility-Full/LINESERIAL

FINS BIB Limit Details

Line ID

/CurrencyCode

LSFacilityService

 

GE-Facility
ExecuteQuery-Res-Full-MSG.xsd

GEM_RES_ENV/GEM_BODY/Facility-Full/LINECCY

FINS BIB Limit Details

Line Currency

/RevolvingIndicator

LSFacilityService

 

GE-Facility
ExecuteQuery-Res-Full-MSG.xsd

GEM_RES_ENV/GEM_BODY/Facility-Full/REVOLVINGLINE

FINS BIB Limit Details

Revolving Flag

/Collateralized
Indicator

Not applicable

Not applicable

Y If COLLATERALCONTRIBUTION > 0 Else N

FINS BIB Limit Details

Secured Flag

/SanctionedLimit
Amount

LSFacilityService

 

GE-Facility
ExecuteQuery-Res-Full-MSG.xsd

GEM_RES_ENV/GEM_BODY/Facility-Full/DSPEFFLINE
AMOUNT

FINS BIB Limit Details

Effective Limit Amount

/AvailableAmount

LSFacilityService

 

GE-Facility
ExecuteQuery-Res-Full-MSG.xsd

GEM_RES_ENV/GEM_BODY/Facility-Full/AVAILABLE
AMOUNT

FINS BIB Limit Details

Available amount

/EffectiveTimePeriod/StartDateTime

LSFacilityService

 

GE-Facility
ExecuteQuery-Res-Full-MSG.xsd

GEM_RES_ENV/GEM_BODY/Facility-Full/LINESTARTDATE

FINS BIB Limit Details

Start Date

/EffectiveTimePeriod/EndDateTime

LSFacilityService

 

GE-Facility
ExecuteQuery-Res-Full-MSG.xsd

GEM_RES_ENV/GEM_BODY/Facility-Full/LINEEXPIRYDATE

FINS BIB Limit Details

Expiry Date

/CustomerParty
Reference/PartyIdentification/ID

LSFacilityService

 

GE-Facility
ExecuteQuery-Res-Full-MSG.xsd

GEM_RES_ENV/GEM_BODY/Facility-Full/LIABID

FINS BIB Account

FINS BIB Contact

Liability Number

/ParentLineOfCredit
Reference/LineOfCredit
Identification/ID

LSFacilityService

 

GE-Facility
ExecuteQuery-Res-Full-MSG.xsd

MAINLINEID derived main line ID from table

FINS BIB Limit Details

 

Main Line Number

Siebel CRM Integration to Oracle FLEXCUBE Universal Banking Implementation Guide Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.