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

Any one help me on above column

Hi Team, MAX(Rating Level Name ) applied then sorted the issue. Thanks, Ajay

Hi @Bhaskar Konar ,@Venkat Koduvayur-Oracle Thanks for reply. please find xml of above report. XML of report rating level.txt Regards, Ajay

got it "Profiles rating models- Rating Level"."Rating level Name"

yes, i have same above coulmns but we need all questions ina row

Hi@Swapnil Kashid , actually I'm sceeduling to me even my side also this report missing the count I'm adaminstrator.

No, I'm the admin and I'm schedling the report to recipient

it is possible in OTBI ?

yes, we export another way like Export analysis >formatted we miss the some employees count. for this way we Export analysis > data > excel we get each row have person number, name some columns coming each row with full count

HI Team, Any update on issue. Thanks,