Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Passing Period to On-prem Oracle EBS DB using EPM On-Prem Agent from ARCS

Summary:

Passing Period to On-prem Oracle EBS DB using EPM On-Prem Agent from ARCS

Content (required)

We plan on using Agent as shown in

https://us.v-cdn.net/6034893/uploads/attachments/55088-9-451453.mp4

However, we are stuck at passing the period to the query

In ARCS we created a custom sql that works on our onprem Oracle DB using Application -> Data Exchange -> Actions -> Query. The query requires bind variables ~PERIOD~ to be passed to it for getting only 1 period worth of data

In ARCS DM created target application of type Datasource -> On Premises Database

Point the Target Application (data source) to the query (defined earlier)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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