Value for A Dynamic Field Is Not Loaded When An Integration Point Is Used (Doc ID 1550490.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Health Insurance Claims Adjudication - Version 2.12.3 and later
Information in this document applies to any platform.

Symptoms

On: 2.12.4.0.3 version, Integration Points

ACTUAL BEHAVIOR
---------------
A dynamic field is added for Product benefit spec limit level to accommodate certain values.
A file based import is done (productBenefitSpecRequest). Limits are loaded but the value for the dynamic field is not loaded, though the task log says it is successful.

EXPECTED BEHAVIOR
-----------------------
Expected is that the value for the dynamic field would be loaded by the IP (Integration Point) when it is provided in the request message.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.
Setup steps for the flexfield used (in this example the flexfield used is called XX_SHARED1):

a)
NAV Configuration / Extensibility / Claims, Configuration and Reference Data / Flex Code Definitions
Create flex code definition 'XX_SHARED1'.

b)
Add new line under Flex Code Field Usages.
Enter:
- Name XX_SHARED1_USAGE, Field code C01, Field Name 'Generic text 1 char', Code code, Key and Mandatory ticked, sequence 0, display Name 'XX_Shared1_display'.
Save.
c)
NAV Configuration / Extensibility / Claims, Configuration and Reference Data / Flex Codes
Tab Flex Codes opens
Flex Code Definitions
Query 'XX_SHARED1'.
Under region 'Flex Codes', values can be entered.
Entered for column XX_Shared1_display the following values (with start date):
A
B
C

d)
Now need to use this.
NAV Configuration / Extensibility / Claims, Configuration and Reference Data / Usages
Query table RCL_PROD_BEN_SPEC_LIMITS
Add:
Field Usage Name XX_SHARED1_USAGE'
Subtype 'Code'.
Field definition 'XX_SHARED1', Display Sequence 22, enter start date.

2.
Enter the product to test with:

NAV Reference Data
Products and Underwriters
Used green plus to add product PRODUCT_IP_1. Select Brand. Save.

3.
Run the request message and check the response:

a)
Check information regarding fileimport.filesrootdirectory in file ohi-claims.properties.

b)
Use the following request in soapUI:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v4="" title="Click (or CTRL+Click if using Firefox) to view" name="contextTextUrl_1367508292604" target="_blank">http://healthinsurance.oracle.com/fileimport/v4">
 <soapenv:Header/>
 <soapenv:Body>
    <v4:fileImportRequest>
       <v4:filePath>ProductBenefit_1.xml</v4:filePath>
       <v4:importProcess>productDefinition</v4:importProcess>
       <v4:responseFilePath>ProductBenefit_1_resp.xml</v4:responseFilePath>
    </v4:fileImportRequest>
 </soapenv:Body>
</soapenv:Envelope>

c)
Create file ProductBenefit_1.xml with info of the environment that is tested with and put the file in the fileimport directory.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ns2:productBenefitSpecRequest xmlns="http://healthinsurance.oracle.com/datatypes" xmlns:ns2="" title="Click (or CTRL+Click if using Firefox) to view" name="contextTextUrl_1367508292605" target="_blank">http://healthinsurance.oracle.com/products/v3">
  <ns2:products>
      <ns2:product code="PRODUCT_IP_1" elementId="PROD_IP1">
          <ns2:productBenefitSpecifications>
              <ns2:productBenefitSpecification indEnabled="Y" benefitSpecificationCode="BENEFITSPEC" startDate="2013-04-18">
                  <ns2:productBenefitSpecificationLimits>
                      <ns2:productBenefitSpecificationLimit amount="4000" limitCode="BENEFIT_LIMIT"/>
  <ns2:dynamicFields>
                              <dynamicField name="XX_SHARED1_USAGE">
                                  <value>B</value>
                              </dynamicField>
                           </ns2:dynamicFields>
                  </ns2:productBenefitSpecificationLimits>
              </ns2:productBenefitSpecification>
          </ns2:productBenefitSpecifications>
      </ns2:product>
  </ns2:products>
</ns2:productBenefitSpecRequest>


d)
Run the File based request in soapUI (send it to the specified endpoint).
e)
Check response in file import directory to know if the result is success.
g)
Check request message in UI.
NAV Operations / View Interface Task Log.


4.
Check the result in the User Interface:

NAV Reference Data / Products / Product Benefit Specifications.
Query product PRODUCT_IP_1.
Under region Limits it shows the Limit BENEFIT_LIMIT.
In the flex field in the overflow value B does not show.



Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms