Category 81
Discussion List
-
Embedded Reports and the environmentSummary: Every time we take a release, I have to relink all of our embedded reports to point to our TEST environment. Content (required): Is there any way that we can ha…User_2025-02-04-08-51-08-912 1 view 2 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Reporting Requisition Detail with Pending Worker DetailSummary: We have a requirement to report all Pending Workers which works fine, but we also need to include some basic Requisition detail such as Req Number and Title. Wh…Emily Robinson 11 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Back end table storing Costing type and Distribution groupSummary: Please share the back end table and column names storing costing type and distribution group name Content (required): HDL load fails with message A distribution…
-
Excel formula in BI reportSummary: Need to include excel formula like DATE and DATEIF based on hire date pulled in one column Content (required): Hi Our requirement is to calculate a date using e…Poornima Paliwal 31 views 4 comments 0 points Most recent by Poornima Paliwal Reporting and Analytics for HCM
-
Report for tracking duration of TerminationsSummary: We have a need to report on the duration of termination, in specific, how long was the time period between when the termination request/workflow was initiated a…Adil_R 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
ETL lineage for Oracle Fusion HCM AnalyticsSummary: Looking for ETL Lineage / Data lineage for Oracle Fusion HCM Analytics. FAW Content (required): Looking for ETL Lineage / Data Lineage for Oracle Fusion HCM Ana…Mangesh Bhanage 41 views 2 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Can you create custom subject areas for a SAAS implementation?Summary: It appears that custom subject areas can be created - but I am not able to find if this is available for standard SAAS HCM Cloud implementations or if any addit…Karen Costakes 21 views 1 comment 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Subject Area - Column collapse aggregationSummary: Subject Area - Column collapse aggregation Content (required): Hi, I am trying to build a report to display Position FTE, and Incumbent FTE. However, to calcula…User_2025-02-11-21-40-21-159 11 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Gross Pay Balance for full Fiscal Year for all EmployeesSummary: I need to create or run a report for all employees to get the Gross Pay for each employee for our full Fiscal Year. Format of data needed Person Number Display …Andrew_Schmitz 157 views 1 comment 1 point Most recent by Jaeyshree Kumaran Reporting and Analytics for HCM -
Inactive terminated employee learning records in Learning Records Real TimeSummary: Content (required): Hi there how can I find the learning records of an employee who has been terminated and is inactive? When I run a simple report in the subje…Bobby Jourdan 21 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
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.6K 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 541 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 11 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 32 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 21 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 22 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 11 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 64 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 31 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 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 155 views 2 comments 1 point Most recent by Aaron Hager Associated Bank Reporting and Analytics for HCM