Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
How to Output a Table Entered in HTML Format in a Document Using BIPSummary: I am creating a document using BIP. I want to output table data entered in HTML format. I would like to confirm the following two points: What kind of SQL state… -
Need a report which can provide details if any scheduled job runs and BI report run got missed.Hi Team, We have a requirement in place that if any report schedule and job schedule got skipped due to any reason then we need a BI or OTBI report by which we can track…
-
Consolidated List of OTBI and BI Publisher Reports Posted (9 December 2014)Content The following is the list of published OTBI and BI Publisher reports between 15 October 2014 and 9 December 2014: * Fusion Benefits: Dashboard for Costs and Tota… -
How to customize seeded Payment Register ReportSummary: How to customize seeded Payment Register Report Content (please ensure you mask any confidential information): Hi All, We got a requirement to add new columns i…
-
Query to get Statement of Earnings (Payroll -> Person Results -> Calculate Payroll)Team, It would be helpful if you can guide me on how to fetch Earnings Value. (Highlighted one).
-
OTBI Analysis - How do you select the gross earnings for the max Date Paid per employee?Summary: We are able to get a list of gross earnings for each worker per pay date but we only want to SELECT the gross earnings associated with the max check date (Date …
-
Exception: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violationSummary: Failure: Due to oracle.xdo.server.ReportException: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violation Content (please ensure yo… -
OTBI to show future effective datesSummary: Hi Community, Please refresh my mind: how to make the OTBI to show future dates from EFF table? Thank you, Alvaro Couto Content (please ensure you mask any conf… -
What is required duty, privilege to work on Manage Extensible FlexfieldsI need to do the below task: When I search for the Task, the task appears but is disabled. What role access, duty role, privilege should I have to edit it? Search and go…
-
Rating Mismatch in BI ReportSummary: Hi Team, Created a BI report to fetch the goal section rating. We have 5 point rating scale for Performance Evaluation. But when we query, it gives 7.5 for the …
-
Assignmentrecords exist prior to the hiredate.Either delete assignmentrecords or change the hiredateSummary: While trying to change the hire date of an employee through HDL getting below error Error: Assignment records exist prior to the hire date. Either delete the as…
-
abcdabcd -
Table / View for New Features and Opt In Features?Summary: Is there a table / view that can be queried via BIP which would allow us to create a report of all of the implemented and non implemented features as seen in th…
-
Performance Document Manager Overall rating doesn't apear within OTBI reportSummary: The issue arises with the rows displaying employee answers: the Manager Overall Score appears as “NA” instead of the actual score. Subject Area: Workforce Perfo…
-
How to report on 'Complete' Date in Oracle Cloud PayrollSummary: Our clients need the ability to be able to run a report to identify the tax liabilities generated based on 'Complete' Date (all on and off cycles completed on a…
-
disable_date not populated in HR_ALL_ORGANIZATION_UNITS_X after inventory org is disabledHi Team, We have disabled the inventory org and we are checking below condition but org.disable_date is not populated. Can you please help how we can populate org.disabl…
-
FDI impact on SaaS Performance?Summary: FDI has been set up to do additional reporting. We´re worried about how it can impact on SaaS performance. Content (please ensure you mask any confidential info…
-
Is there any analytics for ORC on how many visitors visited/view job postings?Content Need an analytic from the very beginning of applicant funnel. Where i want to see how many has actually visited/view the job. Is this possible for ORC? In Taleo …
-
Hide Schedule and Job option from reportSummary: Hide Schedule and Job option from report Content (please ensure you mask any confidential information): Hello experts, does anyone know how to hide the followin… -
BI Reports are failing with error as Could not connect to OBI Presentation ServiceSummary: BI Reports are failing with error as Could not connect to OBI Presentation Service Content (please ensure you mask any confidential information): Hi Team, Greet…
-
How can we create a distribution list in Oracle fusion Bi publisher?I need to share a custom report with multiple users through the following steps: Schedule → Output → Destination Does anyone have any idea about configuring a distributi…
-
SUPPLIER AND PER [ERSO JOINING QUERYSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
What is the fast formula definition for Enterprise Hire dateSummary: I'm building a fast formula that will pull the Enterprise Hire Date of an employee for an eligibility profile. Need your help please. Content (please ensure you…
-
Total earnings inaccurate based on positions in Gross Earnings ReportI created an OTBI report include employees' 'Name', 'Position' and 'Gross earnings'. For prompt of time range, I use 'Pay period start date' and 'Pay period end date'. A…
-
How to display Active employees count month wiseSummary How to display Active employees count month wiseContent Is there any way on calculating employee count by month in OAC. The starting point is an Employees table …
-
Position Hierarchy ReportContent (required): Looking for BI report to get the current logged in person's position and the positions under his hierarchy. Version (include the version you are usin… -
Position Grade Code and Position Grade Name not being populated in OTBIHi all, We have an issue that the Position Grade Code and Position Grade Name is not being populated in OTBI. The only field that is populated is "Valid Grades" and this…
-
HDL - DeleteSummary We are trying to remove Matrix Managers via HDL; but DELETE removes all historyContent Hello! We are implementing Matrix Managers and I've been tasked with updat… -
In Oracle Fusion HCM, eText template with UTF-8 character set converting space to special character.Hi Community, I am facing an issue in eText template with UTF-8 character set, whenever for a field if it has space as a value it's converting space to special character…
-
Need to get Original Start Date on Report with Data ModelSummary: We have a Change Report but need to add Orig. Start Date - OSD. The report is based on a Data Model and I'm not sure what the coding is for OSD or how to get th…