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)
Tagged:
0