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
-
Common Question: I didn't get any rows in the subject area, what's wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row… -
Common Question: How to Ask for HelpSummary: How to ask for help in Reporting and Analytics for HCM Content: 1-Start by naming your subject area. If you don't know that, see: Common Question: In what parti…
-
Common Question: How to paste or copy an XMLSummaryExplains how to paste an XML ContentOften you may see sample reports in this forum, and this how you copy and paste the XML. 1-select new analysis 2-select a subj…
-
OTBI Pivot Table Issue–Unable to Retrieve Questionnaire Response Text and Response Answer CorrectlyWe are using the subject area Workforce Management - Checklist Real Time to retrieve the following attributes: Questionnaire Question Text Response Answer Response Text … -
Unable to find “Enterprise Scheduler Job Application Identity for HCM” user/Application RoleSummary: Unable to find or assign “Enterprise Scheduler Job Application Identity for HCM” user after recent Oracle release Content (please ensure you mask any confidenti… -
Time cards ConfigSummary: Exam Leave - for regular employees (not on Union Job Codes) - should be allowed on Public Holidays and Weekends. Today, system does not allow me to enter this l…
-
How is everyone handling and accessing metadata within OracleSummary: Looking for metadata for both business and log-based data. Would like the Oracle dictionary rather than re-creating the wheel. Where can I locate a full table a… -
Leave balance ytd in oracle payroll run resultsSummary: Hi All, We have a requirement to get the Sick leave ytd balance in the report. Could you please help me to get the query for the same? or How can we get the Sic…
-
Learning OTBI reports does not retrieves data when item has no access view modeHello, I'm trying to build a report from the subject area Workforce Learning - Learning Management Real Time to extract learning history of workers (completed courses). … -
Inquiry on Table for Bursting Email TrackingSummary: Inquiry on Table for Bursting Email Tracking Content (please ensure you mask any confidential information): In accordance with the requirement report, emails ha…
-
Requirement for Encrypted File Generation in UCM via BIPSummary: Hi, We are currently using Bursting in BI Publisher, where a .csv file is generated as the output and placed in the UCM Content Server. However, we have a requi…
-
Can we restrict OTBI report 'edit' access for user to edit OTBI Analysis created by themselves onlySummary: How can we restrict user to edit only the OTBI Analysis created by themselves, provided 'BI Author Role' access has been assigned to the user and user should ha… -
To hide "Home", "Catalog" option while opening an OTBI Dashboard via Widget on Home Page.Content We have a requirement where we need to call an OTBI dashboard via Widget on the Home Page. The road block is to hide the Home, Catalog, Advance, etc. tab that ar…
-
Certified Payroll Report - Fusion PayrollSummary Need to create custom balance for Certified Payroll ReportContent Hi All, Business Requirements :- We have a requirement where they want to have a custom Report …
-
Work Schedules for non-primary assignments in Person Real Time Subject AreaSummary: I'm trying to report on the work schedules for employees with multiple assignments. However the OTBI Person Real Time Subject Area / Person Schedule Assignment … -
HCM Extract changes only with dynamic group criteriaHI All We have a requirement for HCM changes only extract for interfacing data in payroll system. Oracle HCM is the master employee system and we have a thrid party payr… -
Report for getting shift overlap or shift with open end dateSummary: Report for getting shift overlap or shift with open end date Content (please ensure you mask any confidential information): Hi Team, Greetings! If anyone has an… -
Powerpoint export of BIP report is showing unnecessary boxesHi , We have BIP report which has rtf template and when we are exporting this report in ppt format output is showing unnecessary boxes which are difficult to edit in ppt…
-
Need Table name to pull Time Entry Layout Component in Time and LaborSummary: Need Table name to pull Time Entry Layout Component in Time and Labor Content (please ensure you mask any confidential information): Hi, Need Table name to pull… -
Which BICC PVO can be used specifically to extract data from PER_WORKING_HOURS_PATTERNS_F?Summary: Which BICC PVO can be used specifically to extract data from PER_WORKING_HOURS_PATTERNS_F? The lineage documentation (https://community.oracle.com/customerconne…
-
BPM Worklist: SQL query to skip approval if job requisition is pipelineSummary: I need to skip the job requisition approval in 2 scenarios: Job requisition is created as pipeline Job requisition is not having position id However the skip ru…
-
Need table name 'Source: Talent Profile’ information displayed in the Candidate Search HCM?Summary: Please provide the table name in Oracle Fusion HCM that corresponds to the under-Degree 'Source: Talent Profile’ field shown on the Candidate Search page. This … -
PER_PERSON_EIT_EFF flex fields are not appearing in OTBI Subject AreaSummary: Some PER_PERSON_EIT_EFF flex fields are not appearing in OTBI Subject Area Content (please ensure you mask any confidential information): See screen shots of Fl…
-
custom US Cheque Report repositioning when printed to a copierHi, I have built a custom US Cheque Report based upon Oracle's seeded US report. I am having issues after a test payroll is ran and converted to pdf and at that point th…
-
Audit Report - On Folder Permissions ChangesSummary: Content (required): We have a requirement on Auditing folder Permissions Changes on any OTBI folders This report in theory needs to show us When and Who and Wha… -
I need to create an analytic in OTBI To identify what work schedule is assigned to employeesI am trying to create a simple analytic in OTBI to show all employee names, their assignment numbers and the names of the assigned Work Schedule for each assignment. It …
-
Get list of all BI Publisher reports that use a specific data modelSummary: Is there a way in BI Publisher to get a list of all BI reports that are using xyz data model as the DM, in order to understand the impact of making changes to a…
-
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…
-
Grouping data in Excel TemplateSummary: I am trying to group data in my Excel Template. Every employee has 2 annual leave plans. This is how the data currently display when I group by G_1. I want to g… -
Need SQL Query or OTBI report to display OTL Calculated HoursContent Hi All, Pls share Subject area or SQL query to get the OTL calculated hours. For Ex: In a week employee entered 42 hours under Regular. When we click on NEXT but…
-
difference between legal employer hire date and enterprise hire dateSummary difference between legal employer hire date and enterprise hire dateContent Hi, Please find attached screenshot of Manage Work Relationships for a person: 63060.… -
OTBI report has increased massively since 26BHi, A report that was taking 9 seconds to run is now taking 706. This is since 26B came in on Monday. I will attach the report xml, and I have run a Performance check us…
-
In OTBI - How can we restrict user to create and edit report only in My FolderSummary Need to restrict the users to have the right to create edit update the analysis only in My Folder.Content Need to restrict the users to have the right to create …