Business services can be accessed from outside the application via XAI inbound service, or from within the application via scripting, Java, or info zones. Below is an example to what you can do with a business service wrapping an info zone.

 

Generally, a business service is specific to a page service program which references a maintenance object, that means one business service = one service program = one maintenance object.

There have been quite a few threads in the forum around this topic where the business service is misconstrued to perform services only on a single object, for e.g. only for CILCSVAP - SA Page Maintenance, CILCPRMP - Premise Page Maintenance, CILCACCP - Account Page Maintenance, etc.

 

So what do you do when you want to retrieve some "non-persistent" field or information associated with some object/entity? Consider few business requirements:

·         Retrieve all the field activities associated to an account.

·         Retrieve the last bill date for an account.

·         Retrieve next bill date for an account.

 

It can be as simple as described below, for this post, we'll use the first scenario - Retrieve all the field activities associated to an account. To achieve this we'll have to do the following:

 

Step 1: Define an info zone

 

(A basic Zone of type F1-DE-SINGLE - Info Data Explorer - Single SQL has been used; you can use F1-DE - Info Data Explorer - Multiple SQLs for more complex scenarios)

 

Parameter Description	Value To Enter
User Filter 1	F1
Initial Display Columns	C1 C2 C3
SQL Condition	F1
SQL Statement	SELECT     FA_ID, FA_STATUS_FLG, CRE_DTTM FROM     CI_FA WHERE     SP_ID IN         (SELECT SP_ID         FROM CI_SA_SP         WHERE             SA_ID IN                 (SELECT SA_ID                  FROM CI_SA                  WHERE                     ACCT_ID = :F1))
Column 1	source=SQLCOL sqlcol=FA_ID
Column 2	source=SQLCOL sqlcol=FA_STATUS_FLG
Column 3	type=TIME source=SQLCOL sqlcol=CRE_DTTM order=DESC

 

Note: Zone code specified was 'CM_ACCTFA'

 

Step 2: Define a business service

Create a business service linked to 'Service Name' FWLZDEXP - Data Explorer.

Schema will look like this:

 

 

 

 What's next? As mentioned above, you can invoke this business service from an outside application via XAI inbound service or call this business service from within a script.

 

Step 3: Create a XAI inbound service for above created business service

 

 

 

 

Step 4: Test the inbound service

 

Go to XAI Submission and test the newly created service