Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FDM - 11.1.2.3.500 - Trying to run a load rule via batch

User_BP7C5Dec 5 2019 — edited Dec 6 2019

Hi,

We are trying to run a load rule via batch. We have set the EPM_ORACLE_INSTANCE environment variable.

Here's the batch we are attempting to run.

2019-12-05_8-26-56.png

It looks like it tries to do something then we get this. We are not connecting to any source ERP system so not sure why it would be trying to use ERPi. It's been eons since we have even thought about ERPi. The load rule we are running we can manually execute via the client with no issues. This is our first attempt at trying to automate this so please forgive our ignorance. We do this with no issues on PBCS and later versions of FDMEE, but this instance unfortunately is 11.1.2.3.500

Any guidance is appreciated as we are stuck in the mud

pastedImage_0.png

Comments

J.A.

Hi

Truncate is a DDL operation, do you have DDL replication enable ? in your OGG environment

Maybe you need a historical table on your target DB, so maybe you can create a Job to copy the Data from the target table to the historical table.

Regards

Frak!!!

you need to check if you have enable a DDL replication at the source database? if the DDL installed and enabled, you can control which DDL to capture from the extract and replicat by using DDL Include and DDL exclude parameters.

1 - 2

Post Details

Added on Dec 5 2019
#business-intelligence-applications, #essbase, #fdm, #fdmee, #financial-data-management, #performance-management-applications, #planning
9 comments
446 views