You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Integration Issue – Data Overwrite When Loading IS and BS Accounts (Hybrid Planning Cube)

in EPM Platform and Freeform 5 comments

Hello,

I am working on an Oracle EPM Planning application (Hybrid Financial cube) and encountering a challenge with Data Integration while loading Trial Balance data.

Scenario:

  • The source file contains:
    • Periodic values for Income Statement (IS) accounts
    • YTD values for Balance Sheet (BS) accounts
  • Currently, two separate Data Integrations are configured:
    1. One integration to load IS accounts (Periodic values)
    2. Another integration to load BS accounts (YTD values)
  • Both integrations are executed for the same POV:
    • Entity, Scenario, Version, Year, and Period

Issue Observed:

  • When using Export Mode = Replace, running one integration clears the data loaded by the other integration, since the clearing is performed at the POV level and not restricted to specific accounts.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!