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
-
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 … -
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… -
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…
-
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… -
Sql query to get the payroll balance ITD value from the below image It is not from balance resultsHi Team, I need an sql query to fetch the payroll balance ITD value from the below screens (Not from balance results which can be seen in person results). For an employe…
-
Run Payroll Costing Results - load column into FDI?Hello, Is there a way to take a column from the seeded Run Payroll Costing Results report and move that into FDI for reporting use? The need for it is stemming from payr…
-
Organization Calendar Events with Coverage Area Data Extraction QuerySummary: Query to extract Organization Calendar Events with Coverage Area (Geography) Content (please ensure you mask any confidential information): Hi, We have a requir… -
OTBI - "Workforce Management - Documents of Record Real Time" returns 0 resultsWe are experiencing an issue with an OTBI analysis using the "Workforce Management - Documents of Record Real Time" subject area. When we include only worker-related col…
-
Issue w/ Balance Definitions with several elements for rolling 12 months not producing correct valueIssue with Balance Definitions made out of several elements for rolling 12 months as the dimension but the results don't change at all and tested for multiple users with…
-
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… -
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…
-
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 …
-
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…
-
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). … -
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 … -
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… -
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…
-
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…
-
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…