nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

App Engine - Financial Consolidation load from integration to cubes

mark-raynham

I've written an App Engine script to refresh metadata and trial balance data from the Data Lake into the relevant staging and integration tables for eventual loading into Financial Consolidation. The script will be run manually by the end user as well as on a schedule.

I don't see a specific APE command to load the data from the BudgetingMain integration table into the consolidation cubes other than the ModelingExecuteIntegrationDataImport command which seems to be specific for the Budgeting and Planning module as it references the BPDVERSION which is not a dimension in consolidation.

I've tried using "SET_001" as the BPDCYCLE and "V01" as BPDVERSION but it errors with this:
Executing the process failed with an error. The returned message was: An error has occurred:
Calling function 'ModelingExecuteIntegrationDataImport' failed with this message: Invalid 'cycleElement' parameter value 'SET_001'

Any help is appreciated.

Find more posts tagged with

Comments

mark-raynham

After speaking to someone on the Infor support desk it seems like there is no function that will do the very last part of the end-to-end data load process (loading from BudgetingMain into the Financial Consolidation cubes).

I'm also surprised there isn't an enhancement request for this so am I the first consultant that wants this functionality because it feels like it really should already be there especially after all these years with relational modelling in v12?!!!

In the meantime I'll write a script that separately loads from the relational table to TFINANC, TDETAIC and TSEGMC like I've had to do in the past when ImportMaster isn't available.

mark-raynham

Enhancement request has been raised. Please vote for this as it is key functionality that should already be there.

https://mingle-portal.us2.prd3.inforcloudsuite.com/v2/CONCIERGE_PRD/?LogicalId=lid://infor.cxp.1&Tab=ERS&ERId=126821

Rui Ferreira

Hi Mark,

To import data from integration table you need use the function ConsolidationLoadDataFromIntegration.

Think that you dont't need create Enhancement request.

Base in you explanation to integrate data from Data Lake to Consolidation you need,

Create a Connection to data lake in your app
create temp table in staging to storage data from data lake, in my opinion is better than a load query directly in BudgetingMain table, because you have more flexiblity to check data from data lake and filter or edit
Create a load query to extrat data from data lake to temp table
Create a load query to import data from temp staging table to BudgetingMain table,
then create an AppEgine process update your temp table, BudgetingMain table and import data in consolidation, with follow guide lines
1. excute load query of Data lake in staging table use function:ModelingExecuteTableDataLoadQuery
2. excute load query import data from temp table in BudgetingMain tableuse function::ModelingExecuteIntegrationTableLoadQuery
3. import data in FinCons Model from BudgetingMain use function::ConsolidationLoadDataFromIntegration

Regards

Adolf Staudigl

Hi Rui,
Thanks for your reply, which provides a great example of a process flow for consolidation data.
I just wanted to add that the Consolidation loading function is documented here: https://docs.infor.com/depm/latest/en-us/depmolh_cloud/default.html?helpcontent=application_engine_cloud/iwh1610364480093.html (ConsolidationLoadDataFromIntegration)

This standard function includes data validation and ensures consistent data loading across all entity cubes (Finance, Detail and Segment), as well as supporting the upload of transaction currency balances.

mark-raynham

Hi Rui,

Thank you so much for the function. It is a relief to know that there is such a function.

I promise I searched long and hard for this via the official docs but even the search "consolidation data load" didn't make things any clearer and other than scanning the whole list of runtime functions it felt like a "needle in a haystack" search!!!

I'll update the enhancement request to tell Infor to delete it.

Copyright © 2025 Infor. All rights reserved.