Integration of EPM Agent with ERP Subledger Using SQL & Loading Fixed Asset Depreciation Data in EPM
Hello,
We are looking to integrate Oracle EPM with our ERP subledger using the EPM Integration Agent. Specifically, we would like to:
- Use SQL queries to extract data directly from the ERP subledger tables.
- Leverage the EPM Integration Agent to securely connect and transfer this data into Oracle EPM Planning.
- 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?
Tagged:
0