How to export Period and Years dimension values ​​from PBCS to ADB (EPM Integration Agent) — 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

How to export Period and Years dimension values ​​from PBCS to ADB (EPM Integration Agent)

in EPM Platform and Freeform 2 comments

Summary:

Hi,

I'm trying to create an integration in order to write back data from PBCS to ADB using the following procedure:

https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/diepm/epm_agent_auto_writeback.html

in the Insert Query I'm using dimensions name enclosed in ~~ as per guide:

https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/diepm/epm_agent_writeback_insert_104x17308b3f.html

it works for all the dimension except for Years and Period, where:

  • for Years dimension ~Years~ (I've already tried both Year and Years) is not replaced and the INSERT fails with ORA-00911: invalid character
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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