Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Passing Period to On-prem Oracle EBS DB using EPM On-Prem Agent from ARCS — 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

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

Accepted answer
11
Views
1
Comments

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!