Category 81
Discussion List
-
View Display Error- Odbc driver returned an error (SQLExecDirectW).Summary: I created one OTBI analysis with some filter as prompted. The analysis is working fine with admin roles but when line manager is running report it is showing Vi…Kamini Kaushik-Oracle 11 views 2 comments 0 points Most recent by Kamini Kaushik-Oracle Reporting and Analytics for HCM -
Is it possible to create drilldown in BI publisher report?I have worked with drill down options in OTBI & OAC. Want to check if this option is available in BIP. Can you please advise?
-
How do I turn an OTBI Dashboard into an Infolet?Summary: Looking to convert some of the delivered dashboard into infolets Content (required): Version (include the version you are using, if applicable): Code Snippet (a…Jean M Christenson-Oracle 71 views 6 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
Extract Completion DataSummary: Does anyone have a report to extract all completion records from Learning Cloud? I don't see a User Entity in HCM Extracts for Learning. Content (required): Ver… -
Historical Position Change Report All In OneSummary: Our Benefits team wishes to have a report to view historical employment data in one snapshot, to aid in our retirement eligibility process. Does a report like t…User_2025-02-11-20-55-10-551 31 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Turn Off Elimination for historical periodsIs there a way to turn off elimination in FCCS for (historical) periods? Background:. We have a pretty standard application which consolidates many entities from a GL. O…Ken Chen666 21 views 4 comments 0 points Most recent by Ken Chen666 Financial Consolidation and Close
-
How to avoid Line Manager seeing personal and family contact names in ReportsSummary: How to avoid Line Manager seeing personal and family contact names in Reports Content (required): How to avoid Line Manager seeing personal and family contact n… -
Passing parameters to schedule event trigger in flow patternSummary: Hi All, We have defined a flow pattern consisting of different tasks. We have the parameters in the flow which is linked back to the individual tasks. One of th…Anirudh Udupa 21 views 2 comments 0 points Most recent by Anirudh Udupa Reporting and Analytics for HCM
-
Query the email sent in the BIP ReportHello All, We have checked that there is an available record to check the scheduled process that trigger the report that does the email bursting. What we wanted to check…Don Martin Querrer 161 views 2 comments 1 point Most recent by Aaron Hager Associated Bank Reporting and Analytics for HCM
-
How to Capture activities within the Offering?Summary: I currently have a report built in OTBI and looking to pull in data that includes the status of the activity. Currently it is only pulling the status of the ove…User_2025-02-11-00-58-38-371 21 views 0 comments 0 points Started by User_2025-02-11-00-58-38-371 Taleo Learn
-
Need OTBI Subject Area and columns for incomplete tasks under Allocated Checklist.Summary: We have a requirement report incomplete tasks under Onboarding Checklist, I used Workforce Management - Checklist Realtime subject area. I am able to get the ch…Raghavendra M 41 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query the email sent in the BIP ReportHello All, We have checked that there is an available record to check the scheduled process that trigger the report that does the email bursting. What we wanted to check…Don Martin Querrer 11 views 0 comments 0 points Started by Don Martin Querrer Reporting and Analytics for HCM
-
Min, Mid and Max Salary Ranges missing for some associates in OTBI Report. How can we fix this?Summary: Unable to pull Salary Range Min, Mid and Max for some associates in OTBI report. Content (required): Hello, While pulling a report created in OTBI the Salary Ra…AH SL 31 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
FCCS Hybrid Cube Report runs in seconds, when before as a FR report run for 20 minutes.Hi All, We recently migrated an FCCS application from legacy to enterprise. Once in enterprise license we activated the dense sparse optimization. Amazingly enough, the … -
How to translate link text in Analytics Dashboard?Summary: How to translate link text in Analytics Dashboard? Content (required): We have created a dashboard with link tool, now the requirement is to translate the capti…Punam Roy Karmokar 21 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
How to convert scientific number to decimal in BI report?Summary: In a report for corporate rate, value is fetched as 6.666666666666666666666666666666666667E-02 We tried with using to_number to convert this but it kept giving …Priyanka More-Oracle 21 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Adding if/then statement in attribute for extract definitionSummary: I have an employee extract that creates new users in a third party system when new hires added to HCM. One of the requirements is to pass the users reimbursemen… -
Cost center detailsSummary: Hi, Can anyone provide SQL to get cost center details of the department. Content (required): Version (include the version you are using, if applicable): 21C Cod…Reddykrishna Chidella-Oracle 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Need advice on creating Dashboard for Current Year and Previous Year data togetherSummary: I have a requirement to create a dashboard for some of the KPI accounts. It should display data for the current month and 5 previous months (with comparison aga…TarunG-Oracle 31 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Manager Proficiency result for Competency Assessment ReportSummary i cant find the competency assessment column that shows assessment resultContent I wanted to compare target competency assessment and manager competency assessme…Michael Nega Gebrehawariyat 24 views 1 comment 0 points Most recent by User_2025-02-10-15-51-50-906 Reporting and Analytics for ERP -
How to extract Termination Notification details which are still under approvalSummary: I am trying to create a query to extract Termination Notifications, which are still under approval. Following is the query that I prepared. But it's ending into…Dharmendra Shukla 51 views 7 comments 0 points Most recent by Akhil M Reporting and Analytics for HCM