Time Zone Value In OAC DV Workbook And Classic Analysis (Doc ID 2913696.1), there is an enhancement for this. not sure if it is resolved.

Hi Gianni, I am on OACS, Version 12.2.9.0. I am trying to run an OACS visualization based on a filter condition to pick up only orders between previous day 4.30pm London UK time to current day 4.30pm London UK time. tried using FROM_TZ(CAST(SYSDATE-1 AS TIMESTAMP), 'UTC') AT TIME ZONE 'Europe/London' but this function is…

below should work for you SELECT TO_CHAR(FROM_TZ(CAST(last_update_date AS TIMESTAMP), 'UTC') AT TIME ZONE 'Australia/Sydney','DD-MM-YYYY HH24:MI:SS') AS last_update_date_Aus, last_update_date FROM ap_invoices_all

needed feature for OAC

Thanks Steve for your response, but my requirement is when there are no records, output should be something like below with all headers and no output sent as attachment through mail Thanks, Viswanath.

How will the OAC hierarchy be reflected? What would I do if I desired the parent-child hierarchy? - Advised to user Admin tool to design your rpd for custom heirarchy and upload it from console rather than using pre-built model from console.

can you try to reinstall with different location pointed with different name and give a try.

This can be resolved by simply creating a new hidden prompt Period Num in dashboard which will take input as Period Name from main dashboard prompts next in other section place the report which will automatically pick up period Num from above hidden prompt. in this case no changes to existing report is needed, report was…

hi @Michal Zima , tried already the option of Descriptor ID column which perfectly used to work for me in 11g but it is not returning any value to report . please let me know if i am missing something here

hi @Gianni Ceresa , this is based on Calendar functionality and rpd has been built to bring in both period name and period num for same year. Here my issue is my report has 60 unions and each union report have filters like '"Fiscal Calendar"."Accounting Period" <= (@{PERIOD}{6})' and Accounting quarter filter like "Fiscal…