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

SAP ERP to Oracle EPM Mappings

in Planning 5 comments

Summary:


Content (please ensure you mask any confidential information):

Hi

We have below scenario with a client.

Client is using SAP as its Core ERP. and we are extracting actuals to budget from SAP.

SAP has three dimensions namely, GL Account, Cost Center and Functional Area for us to extract.

Functional area is what SAP uses as reporting. However Report requirements in Oracle is different to SAP, so we cannot make use of Functional area dimension for Oracle Reporting.

Because of it, we have created mappings in EPBCS Rules as below for each report area, combining 3 dimensions. (GL,CC, and FA) It should be noted that, there are no parent child hierarchy relationships for this client, and its GL hierarchy and CC hierarchy is built with lots of ineffiencies, where we cannot use any sort of a range to define a report area. Hence the mapping is built as below

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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