Bhashar,
Thank you for the response a colleague just got back to me with this solution querying ASCM tables and it works.
SELECT ppnf.full_nameFROM per_users pu,per_person_names_f ppnfWHERE pu.username = fnd_global.user_nameAND pu.person_id = ppnf.person_idAND UPPER(ppnf.name_type) = 'GLOBAL'AND TRUNC(SYSDATE) BETWEEN ppnf.effective_start_date AND ppnf.effective_end_date
Hi @SQLWrangler,
Welcome to the Oracle Analytics & AI Community!
Could you please share a bit more information about your issue or requirement? This will help us better understand your situation and, if needed, replicate it to find a potential resolution.
Thank you.
The last line may not be needed:
TRUNC(SYSDATE) BETWEEN ppnf.effective_start_date AND ppnf.effective_end_date
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
How can you put a total number of records in your oracle OAC table footer
we have two seperate environments in air gap… 1- oas 2024 2- oas 2026 developers in both env, required extensions like push button, racing bar, guage…. where to download.
