Hi All, Present my Cloud Customer Connect registred with current Oraganization mail so I can able to transfer into next organization right ?. with history of below. Thanks.

@Gianni Ceresa, yes, I'm asking need Orcale SQL for OAC to develop the reports and dashboards. Thanks, Ajay

need any SQL for or anyother languages

Hi Abhishek, In OTBI most of subject areas available in below cloumns Worker assigmnent real time subject area -in worker folder please find. "Worker"."Enterprise Seniority Date" "Worker"."Enterprise Hire Date" -------------------------------------------------------------- SQL Issued- SET VARIABLE PREFERRED_CURRENCY='User…

I'm also looking this type report.

Hi, @ravikiran goda-Oracle , any help on BIP query . THanks, Ajay

Sure, will check and update you on ? Thanks, Ajay

Hi @Bhaskar Konar Thanks for reply. PFA Xml ORC.txt

In BI taken table -IRC_OFFERS Ir column-TO_CHAR(ir.EXTENDED_DATE,'MM/DD/YYYY') as EXTENDED_DATE. but we need OTBI ? entire report ready but need above column also Any one help me

Hi @Bhaskar Konar , yes, I tried above navigation also but not showing data, its blank, any other ? Thanks, Ajay