Data Applications → BlackLine Account Reconciliations for Oracle Cloud ERP

Overview

Close faster and fix your fragmented financial close process, so you can reconcile with confidence. After consolidating your data in Incorta, you and business users can quickly resolve any transaction discrepancies. Send the data back to BlackLine in a secure format in near real-time or using scheduled data transfers. From BlackLine, you can also drill down into your subledger data in Incorta to support your decisions.

Leverage the data application contents to streamline and enhance your data analysis.

Learn how this data application helps meet your business goals.

For business benefits, refer to the data application on Incorta.com.

Requirements

Enterprise users can self-install this data application. If you’re a trial user, select Contact to Install on the data application in the Incorta Analytics Marketplace, and Incorta Support will help you.

To use this data application, you must configure an Oracle Cloud ERP data application to use with this BlackLine data application. For instructions, refer to Configure the Oracle Cloud ERP Data Application.

Physical schemas

• Fusion_Fin_Common: This schema holds the common financial tables
• Fusion_FND_Common: This schema holds the common foundation tables
• Fusion_HR_Common: This schema holds the common HCM tables
• Fusion_Party_Common: This schema holds the common party tables
• Fusion_AP: This schema holds the Accounts Payables tables
• Fusion_AR: This schema holds the Accounts Receivables tables
• Fusion_GL: This schema holds the GL tables
• BL_Fusion_GL: This schema holds the Blackline tables
• Fusion_XLA: This schema holds the XLA tables
• Fusion_XLA_MV: This schema holds the XLA materialized views.

Business schemas

FusionBlackLineDM: Provides user-friendly business views that include all the attributes and metrics needed for BlackLine account reconciliation for Oracle Cloud ERP.

Dashboards

All Dashboards are under the Blackline Templates for Oracle Cloud ERP folder.

Customizable dashboards include:

• General ledger journal details drill dashboard
• Subledger drill dashboards for accounts payable, accounts receivable, inventory, projects, and fixed assets

Dashboard tabs contain insights:

• ‘Accounts for BlackLine’
• ‘Subledger drill ‘
  • AR
  • AP
• ‘Drill Reports’→’GL Journal Details’

Tables

Here are the tables the data comes from in Incorta (ER Diagram for BL_FUSION_GL schema):

Installation and configuration

Here are the steps:

1. Install the data application
2. Set up the BlackLine data destination
3. Configure the dashboard to use the data destination
4. Set up the BlackLine data application
5. BlackLine drill-down setup
6. Load schemas
7. Confirm primary BlackLine objects

Step 1: Install the data application

If you have access to install or request the data application in Incorta Analytics:

1. Sign in to Incorta Analytics.
2. Select Marketplace in the navigation bar.
3. Search for and select the BlackLine data application for your data source.
4. Select Install or Contact to Install.

To install in the CAP (Administrators only):

1. Sign in to the CAP.
2. Select Data Apps in the navigation bar.
3. Search for and select BlackLine data application for your data source.
4. Select Install.

Step 2: Set up the Blackline Data Destination

Here are the steps to configure BlackLine as a data destination in Incorta:

1. Sign in to your Incorta cluster
2. In the Navigation bar, select Data → + New → Add New Data Destination
3. Create a new BlackLine data destination. Refer to Concepts → Data Destination for more information.

Step 3: Configure the dashboard to use the data destination

Configuring a dashboard schedule for the Accounts for BlackLine dashboard allows Incorta to transfer the data file to the configured remote server, then upload it to BlackLine.

1. In Incorta Analytics, open the Accounts for Blackline dashboard.
2. Select the share icon on the top right, and select Send/Schedule a Report. Enter the following data for BlackLine to import:
   • Under Name, enter a name.
   • Under Channel, select Data Destination, then select BlackLine.
   • Under Directory, select the SFTP directory.
   • Enter a File Name, such as GLAccounts_Incorta.
   • If you need a timestamp in the file name, select Append Timestamp.
   • Under Schedule, set the dashboard schedule to run after the schema load has completed.

Step 4: Set up the data application

1. In Incorta Analytics, open the BlackLine data application.

2. In the XX_GL_CODE_COMBINATIONS table in the BL_FUSION_GL schema, review and edit the SQL logic to reflect the segments for each of the charts of accounts you are interested in sending to Blackline via Incorta. Your segments and chart of accounts IDs depend upon your Oracle implementation.

   Data application logic:

   • The chart of accounts ID is 2001, and Account is mapped to Segment 3.
   • Inter Company Affiliate is mapped to Segment 5.
   • Line of business (LOB) is mapped to Segment 2.

3. In the Mv_Active_Account MV in the BL_FUSION_GL schema, review and edit the SQL logic that determines if an account is active or not. The logic depends upon your requirements.

   Data application logic:

   • If the account is enabled, the account is active.
   • If the account is disabled and the status change is in the current period, the account is active. If the opposite is true, the account is inactive.

4. In the Mv_Account_Activity_in_Period MV in the BL_FUSION_GL schema, review and edit the SQL logic that determines if there is an account activity in a given period. Your logic depends on your requirements

   Data application logic:

   • If there is a period_net_balance of 0, there is no activity in the period.
   • If the opposite is true, there is an activity in the period

Step 5: BlackLine drill-down setup

In your BlackLine environment, go to ERP Drill Down settings and apply the following step:

Complete setup in BlackLine and Incorta to enable drill-thru from Blackline to Incorta for GL journal details and subledger drills.

1. In BlackLine, download the Account group template for all periods. You only need to do this once before the first full load.

   • Under Reporting, run the Account Template Report with All Periods and GL and Group Accounts selected.
   • After the report completes, download the file in CSV format.

2. In Incorta, upload the file following these steps. Repeat them whenever an updated version of the account groups needs to be uploaded to Incorta:

   • Upload the .zip file to Incorta from Incorta UI Data/Local Datafiles/Blackline Account Groups - This needs to be done prior to the full load. This step should be done as needed (typically twice a week).
   • Download the Account group template from Blackline (for all Current and Previous periods only).

3. In BlackLine under Reporting, run the Account Template Report.

   • Select Current and Previous Period and GL and Group Accounts.
   • After the report completes, download the file in CSV format. This creates a zip file.

4. In Incorta, upload the .zip file to Incorta from Incorta UI Data/Local Datafiles/Blackline Account Groups, replacing the existing file.

5. In BlackLine under ERP Drill Down Settings, do the following:

   • Enter the following URL making sure to enter your cluster name and dashboard ID:

   Copy
   https://<cluster_name>.incorta.com/incorta/#/dashboard/<dashboard_ID>/params?filters=[{ "field": "FusionBlackLineDM.Accounts.SEGMENT2", "operator": "IN", "values": ["[BL-Seg2]”] },{ "field": "FusionBlackLineDM.Accounts.END_DATE", "operator": "IN", "values": ["[BL-PeriodEnd]”] },{ "field": "Fusion_FIN_COMMON.Ledger.LEDGERID", "operator": "IN", "values": ["[BL-Seg4]”] }]&merge-filters=true
   
   

   • Add a drill down named Oracle GL Detail BL Accounts. The drill dashboard is Blackline Templates for Cloud ERP/Drill Reports/GL Journal Details.

6. In Incorta, open the dashboard Content/Blackline Templates/GL Journal Details.

   • Add a drill down named Oracle GL Detail BL Groups. The drill dashboard is Blackline Templates for Cloud ERP/Drill Reports/GL Journal Details.
   • Replace the bold text below to reflect the values in your Incorta production environment. Open the dashboard: Content/Blackline Templates/GL Journal Details in Incorta and grab the URL making sure to enter your cluster name and dashboard ID.

   Copy
   http://<cluster_name>.incorta.com/incorta/#/dashboard/<dashboard_ID>/params?filters=[{ "field": "FusionBlackLineDM.AccountGroups.Entity_with_plus", "operator": "IN", "values": ["[BL-Seg1]”] },{ "field": "FusionBlackLineDM.AccountGroups.Group_Account_with_plus", "operator": "IN", "values": ["[BL-Seg2]”] },{ "field": "BlackLineDM.Accounts.END_DATE”, "operator": "IN", "values": [“[BL-PeriodEnd]”] }]&merge-filters=true   
   
   

Step 6: Load schemas

In Incorta, load the following schemas in an incremental load, per your schedule. Do a full load first, if you haven’t already.

1. BICC offerings:
   • Incorta Common
   • Incorta Finance Common
   • Incorta AP
   • Incorta AR
   • Incorta GL

For more information about BICC offerings and configuration, refer to Configure the Oracle Cloud ERP Data Application.

2. Incorta schemas (run in order):
   • Fusion_HR_Common
   • Fusion_PARTY_COMMON
   • Fusion_FIN_Common
   • Fusion_FND_Common
   • Fusion_AP
   • Fusion_AR
   • Fusion_GL
   • BL_FUSION_GL
   • Fusion_XLA
   • Fusion_XLA_MV

Step 7: Confirm primary Blackline objects

In the BlackLine application in Incorta Analytics, confirm that these are the primary objects:

• Schema: BL_FUSION_GL
• Business Schema: FusionBlackLineDM
• Dashboard Folder: Blackline Templates for Oracle Cloud ERP
• Session Variable used in the Accounts for Blackline dashboard to return the current and last two GL periods: $var_BL_PeriodName