Business Flows

The Mambu-Oracle NetSuite connector’s business flow consists of extracting all Journal Lines created in the previous day from Mambu at midnight and sending them as balanced batches of Journal Lines to Oracle NetSuite.

The Journal Lines are enriched with custom fields defined in Oracle NetSuite. Custom fields are attributes and values that categorize accounting lines, such as transaction, client, account, product or branch and can be set for the following entities: Transaction, Loan/Deposit Account, Client, Product, Branch. This enrichment allows for deeper and more robust analysis and reporting of the accounting data.

Oracle netsuite connector business flows

Types of Journal Entries handled by the integration

Automatic Journal Entries

Mambu will automatically log corresponding Journal Entries for each transaction posted to a customer account. The Journal Line posted to Oracle NetSuite can be enhanced with custom data from the following entities: transaction, client, account, product, branch.

Manual Journal Entries

A manual Journal Entry can be associated with a branch. The Journal Line posted in Oracle NetSuite can be enhanced with custom data from the branch entity.

Daily/Monthly accruals

These types of Journal Entries are logged during End of Day processing in Mambu and contain information about the product and branch. The Journal Line posted to Oracle NetSuite can be enhanced with custom data from the following entities: product, branch.

Negative use cases

The MPO processes handle and record all errors generated during different phases of the connector: extracting the data, performing transformations and loading the enriched journal entries into Oracle NetSuite.

Each negative use case is handled differently depending on which phase of the process the issue occurs in.

Data extraction

In case an error occurs during this phase, the following steps are executed automatically:

  • The API call is retried a configurable number of times;
  • The error is stored in a dedicated state diagram;
  • The Journal Lines queue is emptied;
  • A task is logged in Mambu and assigned to a designated user.

→ The following steps should be manually executed:

  • Trigger the Main process, specifying the date.

Data enrichment

In case an error occurs during this phase, the following steps are executed automatically:

  • The API calls will be retried a configurable number of times;
  • The error is stored in a dedicated state diagram;
  • A task is logged in Mambu and assigned to a designated user.

→ The following steps should be manually executed:

  • Add custom field values to the Journal Lines posted to NetSuite.

Batch reconstruction

In case an error occurs during this phase, the following steps are executed automatically:

  • The error is stored in a dedicated state diagram;
  • A task is logged in Mambu and assigned to a designated user, which will indicate which of the following steps are required:

Case 1

  • Trigger the process specified in the notification (Listener).

Case 2

  • Check if the Journal Lines queue is empty;
  • Check that the state diagrams listed in the notification are empty;
  • Trigger the Main process, specifying the date.

Data dispatch

In case an error occurs during this phase, the following steps are executed automatically:

  • The error is stored in a dedicated state diagram;
  • A task is logged in Mambu and assigned to a designated user.

→ The following steps should be manually executed:

  • Check that the state diagrams listed in the notification are empty;
  • Delete the Journal Lines already posted to NetSuite for that specific date.
  • Trigger the Main process, specifying the date.