Integration of EPM Agent with ERP Subledger Using SQL & Loading Fixed Asset Depreciation Data in EPM — Cloud Customer Connect
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

Integration of EPM Agent with ERP Subledger Using SQL & Loading Fixed Asset Depreciation Data in EPM

in Planning 10 comments

Hello,

We are looking to integrate Oracle EPM with our ERP subledger using the EPM Integration Agent. Specifically, we would like to:

  1. Use SQL queries to extract data directly from the ERP subledger tables.
  2. Leverage the EPM Integration Agent to securely connect and transfer this data into Oracle EPM Planning.
  3. Extract data from the "What-If Fixed Asset Depreciation Report" in the ERP system and load it into EPM Planning for forecasting and analysis purposes.

Questions/Requests:

  • Can the EPM Integration Agent be configured to connect to the ERP subledger using SQL?
  • Are there any limitations or best practices for extracting data from ERP reports like the What-If Fixed Asset Depreciation Report?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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