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
-
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… -
performance tile DescriptionSummary: When we drag the mouse above some graphs we can see the analysis name description with more information. We would like to know how can we enable this feature to…
-
Matrix Manager Missing in BICC ExtractWe are using BIACM Extract (PVOs) to expose HCM data to PowerBI. Based on the document Rel13_21.x_BICC_HCM_Database_Mapping_with_ViewObjects, we understand that the PVO … -
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…
-
The XML which we have pulled for the Job History doesn't hold the Job statusThe XML which we have pulled for the Job History doesn't hold the Job status if it is success or failed the against individual employee if the job is success of failure …
-
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 …
-
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…
-
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…
-
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…
-
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… -
JOLTS ReportSummary JOLT Report Content (please ensure you mask any confidential information): Looking to see if anyone has ever created this report and if so if they could share Jo… -
What are the options to have read only capabilities to BICC (BI Cloud Connector) in OracleWhat are the options to have read only capabilities to BICC (BI Cloud Connector) in Oracle
-
BIP Scheduled Trigger Failing - Help NeededSummary: Hi all, I'm trying to add a schedule trigger to my BIP report that's currently scheduled, but when it runs with the code, it fails with the following message: D…
-
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…
-
Example Feedback Report query for BI Publisher based on Feedback requests and Questionnaire tablesSummary: Our requirement is to generate a report based on feedback requests and questionnaire (eg. Annual Performance Feedback) tables. Manager will submit Feedback Requ…
-
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…
-
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…
-
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…
-
sql query to get person payment amount typeSummary: sql query to get person payment amount type Content (please ensure you mask any confidential information): Version (include the version you are using, if applic…
-
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… -
Query Regarding Adding a Secured List Table to Oracle BI Data ModelSummary: Query Regarding Adding a Secured List Table to Oracle BI Data Model Content (please ensure you mask any confidential information): Hello, I am working on a BI d…
-
How to obtain the history of when a role is assigned and revoked to a userSummary: Hello All, As an Audit Requirement we need the complete history of when access is provisioned to a role and it is revoked. The following table ASE_USER_ROLE_MBR…
-
Copying OTBI reports in bulkSummary: Copying OTBI reports in bulk Content (please ensure you mask any confidential information): Hi Team, Greetings! There is a requirement to copy multiple OTBI Rep…
-
Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time"Summary: Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time" subject area Content (please ensure you mask any confidential …
-
I am trying to add Division to an analysisSummary: I am trying to create a "Master Employee Data" report that includes payroll information so I'm using the Compensation Details - Salary Details Real Time subject…Jenna Savage - Hunter Douglas 72 views 12 comments 0 points Most recent by Jenna Savage - Hunter Douglas
-
How to make bold font in a custom formulaSummary: Using subject area WFM Worker Assignment Real Time, field Worker/Address Line 4. Is there a way to modify this formula to show 'MISSING' in bold red text? CASE …
-
how to convert blob type to actual text in oracleSummary: the underlying tables store the xml data of employees in blob format, the customer wanted to see the exact content of this File_data column in output results.. …
-
BI report does not open in android devicesWe have a third party payroll integration and we have a report so that payroll outputs can be pulled from self service. When this report is opened from the mobile applic… -
I was trying to create a report to pull employees, excluding the managersHow to pull employees using OTBI and to exclude managers who are also an employee. please share ideas thanks.
-
401K Annual Census ReportSummary: We are new to Oracle Cloud and looking for a 401(k) or 403(b) Annual Census file. It would include Name, SSN, DOB, Hire Date, Term Date, Status, Gross Earnings,…