Generate Accounting Detail Message

Oracle Health Insurance application provides a means to generate accounting detail message process that reads accounting details and creates a corresponding accounting message in JSON format.

To generate accounting message, see Generate Accounting Detail Message for more information.

The parameters for the activity are:

Table 1. Generate Accounting Detail Message Request Parameters
Name	Description
Description	The description of the long running operation.
Created Date From Created Date To Creation Time From Creation Time To	Evaluate to `true` if the creation date of the Accounting Detail falls within the parameters. If the time element is not specified, it works as follows: If the time element for Creation Date From is left unspecified, it translates to 00:00. If the time element for Creation Date To is left unspecified, it translates to 23:59.
Origin	Possible values Registation-R or Financial-F. Allows to select accounting details linked to either registration or financial. When not specified both are considered.
Group Account	Evaluate to `true` if the accounting detail is for the specified group account.
Incremental	When set to `true`, it excludes the accounting details which are handled, that is, have GL Extraction Batch Id and GL Extraction Date Time set. Default is set to `true` (Yes).
Grouping	Evaluates to `true` if the financial transaction set grouping matches the specified criterion. When not mentioned, no restrictions apply.
GL Extraction Batch Id	When specified, the batch selects the accounting details sent previously under the batch ID, thereby acting as a "resend" function. Note that once the accounting messages are "resend" a new batch id and date time gets updated against the accounting details. For subsequent runs the new id should be considered.
Data File Set Code	Data file set code.

Processing

The system selects accounting details (not void) as specified by the above criteria. The selected accounting details are then grouped (amounts are added) using Bulking group GL file, amount currency, reversal indicator, and invoiced indicator into a single JSON element.

Some elements may lose their significance when grouping is applied - for example, subject ID may become irrelevant if grouping is across multiple policies.

Stamping of Results

The result of the accounting message creation is recorded on the Accounting Details. The activity id and datetime message created are captured.

Accounting Detail Message

 {
    "id":
    "jobId":
    "messageDate":
     "accountingDetails":[{
        "description":
        "subject":
        "bulkingGroupGLFile":
        "reversal":
        "invoiced":
        "distributionAccount":
        "ledgerId":
        "accountingDate":
        "transactionDate:
        "category":
        "source":
        "currencyCode":
        "amountDebit":
        "amountCredit":
        "accountingPeriod":
        "glSegment1": to
        .. "glSegment30":
        "attribute1": to
        .. "attribute30":

     }]
 }

Accounting Message Element: This element has attributes that relate to the accounting message itself. Attributes in this JSON are all populated by a fixed logic in the Generate Accounting Message activity.

Table 2. Accounting Message Element
Element	Source of Value	Note
id	Simple Sequence.	Unique ID of message generated by Oracle Health Insurance.
jobId	Activity ID that created this accounting message.	Unique ID of the Accounting Message Creation activity.
messageDate	System Date and time.	Date / Time the message was created.

The system writes all the accounting messages to a JSON file (data file). The system might create multiple JSON files to avoid the creation of large data files with many accounting messages. These multiple files are placed in one data file set. The system leverages notification (activity notification) to deliver the links to download the data files.

Error Message

This process can result in the following error messages with the elementId attribute set to the policy code (when applicable):

Table 3. Error Messages
Code	Sev	Message
FIN-IP-ACDE-001	Fatal	At least one of the following must be specified: Transaction Creation Date (From/To). GL Extraction Batch ID. Grouping.
FIN-IP-ACDE-002	Fatal	Date (time) from should be on or before the date (time).
FIN-IP-ACDE-003	Fatal	No other selection criteria must be specified when GL Extraction Batch Id is specified.
FIN-IP-ACDE-004	Fatal	Group account code is unknown.
ACT-FL-DAFI-001	Informative	Messages are written to the Data File Set { data file set id}.