Category 81
Discussion List
-
Query to get balance value from run resutsSummary: Need a query to fetch value for given balance name('Gross Pay') and its dimension('Core Assignment Tax Unit Run'). the query should get value from run results n…Jaeyshree Kumaran 2.5K views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Line Manager DOR- with 0 CountSummary: I have created a Line Manager report with no filters - the intention was the manager can view all their direct and indirect reports. But as there is no filter t…
-
OTBI reports doesn't display all the information loaded in the systemSummary: Content (required): Hello experts, we have noticed that some OTBI reports display 25000 rows at maximum and some information is missing. We suppose that for rep… -
How to get the total Headcount of Employees and contract worker on monthly basis.Summary: We are trying to create a dashboard using Analysis Report, but when we try to fetch the headcount of employees and contract workers through analysis, there is a…Harish.M 526 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Getting Shift Hours For An Employee On Particular DateSummary: Folks, We have a requirement to fetch the Hours On Date. Example. Find the screenshot attached. If we pass parameter date as 03-Dec-2018 then 35 hours 77777700-…
-
Need SQL to fetch all Fast Formula and mapped HCM extractsSummary: Need SQL to fetch all Fast Formula and mapped HCM extracts Content (required): Version (include the version you are using, if applicable): Code Snippet (add any…
-
Accomplishment person profile database item Value Column NameSummary: Hello experts, when creating custom sections for person profile, I can see the Value Column Name for the flexfield as for example ATTRIBUTE_NUMBER1. What is the…
-
Privileges required to open Payroll Element Entries - Real Time subject areaSummary: Hello experts, do you know the privileges required to open Payroll Element Entries - Real Time subject area? Thanks in advance for your time! Kind Regards, Vale…Valerio Curzi 12 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Top 10 Percent PaidSummary Need to pull the top 10% paid US staff Content Hi, I need to create a query that shows me my top 10% paid staff. The legal definition is: "In determining which e…user6284475 33 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Where do we define additional Manager detailsSummary: Hi Everyone, I am trying to find out where can we define Manager details in Assignment screen. Attaching screenshot for referencce. Content (required): Version … -
Termed employee report with both Manager hierarchy AND final salarySummary: Has anyone written an OTBI report to pull termed employees and include both Manager hierarchy AND also final salary? Content (required): Has anyone written an O…User_2025-02-04-15-06-22-759 23 views 1 comment 3 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report Vacant PositionsSummary: How to report Vacant Positions. Content (required): How to identify "empty seats" on a Pooled Position and report Single Positions without incumbents Version (i…Fabian Galarza - HCM Cloud 51 views 5 comments 1 point Most recent by Fabian Galarza - HCM Cloud Reporting and Analytics for HCM
-
Is there an HDL loader for the Federal Calc CardSummary: Hi All, I am looking to see if there is an HDL loader than be used rather than the HSDL loader CA Tax Credit Information Is there someway to cross reference whi…User_2025-02-04-08-51-08-912 21 views 4 comments 1 point Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
SQL query to get the costing details at the element entry level.Summary: Hi , I have a requirement where I need to fetch the costing details at the element entry level. I have developed the code ( PFA) but not able to get the costing… -
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 12 views 2 comments 0 points Most recent by Kamini Kaushik-Oracle Reporting and Analytics for HCM
-
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 63 views 6 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
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 33 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
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 25 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 151 views 2 comments 1 point Most recent by Aaron Hager Associated Bank Reporting and Analytics for HCM
-
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 42 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 37 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 24 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 22 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
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 12 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
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 52 views 7 comments 0 points Most recent by Akhil M Reporting and Analytics for HCM -
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 63 views 0 comments 0 points Started by Kamini Kaushik-Oracle Reporting and Analytics for HCM
-
Success Criteria (HTML Tags) are not exported to excel- ErrorSummary: A few days back, I was able to download the development goals success criteria on EXCEL with data format set to HTML. However it is not working now. I have to c…
-
ORC fields mapping with HCM TablesSummary: We're looking for mapping documents to associate each ORC field to the correspondent item in the HCM tables (e.g. ATTRIBUTE_CHAR1 etc) Content (required): Hello…gguittini 152 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM