You are here: Integration > Files Received

Oracle® Insurance XML Configuration Guide Release 9.4.1.0 E23637_01

# Files Received

## Description

This File rule (also referred to as AsFile) allows configuration to translate incoming data and insert it directly into the database. AsFile can also be configured to selectively insert records into the database based upon the data in the inbound SOAP message.

The configuration for each File has two sections: XMLData and XSLT. The XMLData section assigns values to attributes prior to the transformation process. The XSLT defines how the information will be transformed.

The XMLData section can be configured using the elements and attributes described below. The XSLT section transforms data according to a stylesheet. Each Attribute defined in the XMLData section that will be needed in the XSLT stylesheet must first be declared as a parameter in the XSLT.

Refer to the Administration Overview | Files Overview section in the Rules Palette help system for additional information on configuring File and the XSLT section.

Note: Parameter, Attribute and Variable are interchangeable terms depending on which section you are working with. An attribute in the XMLData section is called a parameter in the XSLT section.

## Files Received Elements/Attributes Table

Element/Tag | Definition | Attribute | Element/Attribute Value and Description
--- | --- | --- | ---
<File> | The opening and closing tag for the rule. |  |
<AssignAttributes> | Required element |  |
<Attribute> | Required element |  |
| NAME | Note: NAME=ImportName and NAME=ClassName are both required attributes. The import name is the text of the root XML node of the AsXML. The ClassName attribute should be defined as one of the objects that AsXML mapping is going to create.
GUID |
XPATH |
VALUE |
SQL |
SYSTEMDATE |
SEQUENCE |
XPATHSTRINGLIST |
XPATHNUMBERLIST |
SQLMAP |
<PreInsert> | Optional element; PreInsert allows for functionally to be exercised prior to records being inserted into the database. Only used when there is a need to call other functionality in the application. |  |
<Object> | Used to define the name of the Java class being called. | CLASS |
<Parameters> | Allows for passing parameters to the class. | NAME |
<PostInsert> | Optional element; PostInsert allows for functionally after the records are being inserted into the database. Only used when there is a need to call other functionality in the application. |  |
<Object> | Used to define the name of the Java class being called. | CLASS |
<Parameters> | Allows for passing parameters to the class. | NAME |

## XML Examples

    <File>

    <AssignAttributes>

    <Attribute NAME="ImportMapName" TYPE="VALUE">AsXml</Attribute>

    <Attribute NAME="ClassName" TYPE="VALUE">com.adminserver.utl.JibxListUtl</Attribute>

    </AssignAttributes>

    <PreInsert>

    <Object CLASS="com.adminserver.pas.webservice.bll.AsFilePostInsertIndividualActivityProcessorBll">

    <Parameters>

    <Parameter NAME="ActivityClientNumber">ActivityClientNumber</Parameter>

    </Parameters>

    </Object>

    </PreInsert>

    </File>

    <File>

    <AssignAttributes>

    <!-- Required in all AsFile interfaces -->

    <Attribute NAME="ImportMapName" TYPE="VALUE">AsXml</Attribute>

    <Attribute NAME="ClassName" TYPE="VALUE">com.adminserver.utl.JibxListUtl</Attribute>

    <!-- Additional AsFile -->

    <Attribute NAME="PlanGUID" TYPE="XPATH">/TXLife/TXLifeRequest/OLifE/Holding/Policy/ProductCode</Attribute>

    <Attribute NAME="FundGUID" TYPE="XPATH">/TXLife/TXLifeRequest/OlifE/Holding/Investment/SubAccount/ProductCode</Attribute>

    <Attribute NAME="PolicyGUID" TYPE="GUID"/>

    <Attribute NAME="ParentCompanyGUID" TYPE="SQL">SELECT CompanyGUID FROM AsCompany WHERE CompanyName='Prototype Child Company'</Attribute>

    <Attribute NAME="ChildCompanyGUID" TYPE="SQL">SELECT CompanyGUID FROM AsCompany WHERE CompanyName='Primary Company 1'</Attribute>

    <Attribute NAME="TransactionGUID" TYPE="SQL">SELECT TransactionGUID FROM AsTransaction WHERE PlanGUID = '[PlanGUID]' AND TransactionName = 'CoverageCalculation'</Attribute>

    <Attribute NAME="ProcessingOrder" TYPE="SQL">SELECT ProcessingOrder FROM AsTransaction WHERE TransactionGUID = '[TransactionGUID]'</Attribute>

    <Attribute NAME="ActivityClientNumber" TYPE="VALUE">devikar</Attribute>

    <Attribute NAME="ComputationID" TYPE="VALUE">IllustrationReturn</Attribute>

    <!--Attribute NAME="PolicyNumber" TYPE="POLICYNUMBER" PLANGUID="PlanGUID" POLICYGUID="PolicyGUID" COMPANYGUID="CompanyGUID">PolicyNumber</Attribute-->

    <Attribute NAME="PolicyNumber" TYPE="SEQUENCE">PolicyNumber</Attribute>

    </AssignAttributes>

    <PostInsert>

    <Object CLASS="com.adminserver.pas.webservice.bll.AsFilePostInsertIndividualActivityProcessorBll">

    <Parameters>

    <Parameter NAME="ActivityClientNumber">ActivityClientNumber</Parameter>

    </Parameters>

    </Object>

    </PostInsert>

    </File>

Copyright © 2009, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices

Open table of contents