Much awaited feature

it is very useful also include OAC REST API to retrieve workbook data by passing parameter values and get the corresponding DV report data

Hi Mike, Do we have any OAC REST API available that allows us to retrieve workbook data by passing parameter values (via POST) and get the corresponding DV report data? From what I’ve seen in the Oracle documentation, it looks like the available APIs are somewhat limited mainly focused on retrieving workbook/canvas details…

This is a much-needed feature.

This is needed .

@Sumanth V -Oracle issue already fixed and you can see my comments previous post. Thanks for your time and response.

Hi All , it is started working. issue is with missing below grant commands to schema GRANT CREATE SESSION TO <schema>; grant dwrole to <schema>; GRANT UNLIMITED TABLESPACE TO <schema>; after doing this step started working. Thanks for all your inputs . @tetyana from Oracle support team helped to resolve the issue.

Sumanth V -Oracle will do and keep posted updates

I will check and get back , currently could not do make changes on classic RPD model as Business users are doing preprod validation.

@Sumanth V -Oracle Yes , created tables Manually

@GayathriAnand-Oracle. I have created usage tracking tables and able to import meta data of those tables in RPD also configured tables and connection pool details on console. only challenge is to see ran reports data into tables that means not inserting stats in tables.

@Namrata Bhan-Oracle , I really appreciate every one response and I already told above post that by replace wallet and started working. I tried same thing multiple times did not work hence posted query .

Hi, Thanks for your time. it is started working after re-upload Wallet file in console connection /data . am not sure what could be the reason for not working earlier. I tried multiple times and succeeded finally .

Hi Sumanth , I am able to connect ADW from OAC and see database tables via Console →DATA Console → Connection as soon as deployed RPD with same ADW DB could not able to run the reports with Errors Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PState: HY000. Code: 10058. [NQODBC] [SQL_STATE:…

Hi RanaAshtosh, Thanks for your response. I verified connection and externalize connection already set to 'FALSE' at connection pool and verified TNS entry and did not see any difference.

No Bret Grinslade , we are using standalone PaaS OAC platform. I would like to know process to get security profile like AOR , Organization security set up from SaaS to PaaS.

Thanks for quick response Federico. Here with attached 3 screenshots. I see defualt option enabled to Limit value selection as AUTO. I have period type Year,Monthly,Quaterly & Daily, Period description has all the values like year,month-yyyy,Quarterly etc however when select MOnthly it should not limit values MOnth values…