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
-
USOnline Payslip Report CustomisationHi Team, We are looking for detailed steps for customising the USOnline Payslip report, with the output format in XML. Report output should be delivered to FTP. Please s… -
Date between effective start date and effective end dateI am trying to create an otbi report on element entries historical subject area. I have to create a date filter condition in such a way so that it will ask a date from t… -
Start Date change on ORC side - Need to know table where Old start date value is storedSummary: When a candidate is in Post Offer stage and the Start date is changed to a new value, in which table does the old value reside? Context - We are trying to build…
-
Can we report on the number of job requisitions raised by "use" type (template, position etc)Summary: We are looking to establish the behaviour of users and which way they raise job requisitions in Oracle Recruiting. Is it possible to report on how many requisit… -
HCM OTBI- How do I run report to see any positions with an entry in the 'Funding Source'?Summary: Need run a report to see if there are any positions with an entry in the 'Funding Source' field however I'm unable to find the field in any HCM Subject Areas. C…
-
How can Canadian French characters be displayed correctly when using ANSI encoding?We have a requirement to send a demographic file to a Canadian RRSP vendor using ANSI encoding that supports ASCII characters. However, when we use encodings such as ASC…
-
Select a particular value from concatenated fieldSummary: To obtain a specific value from concatenated field. The business requirement is to obtain information regarding people reporting to C suite (Senior Leadership) … -
BI/OTBI Report to identify list of all users who have access to a specific employeeSummary: We have a requirement to fetch all users who have access to view/modify employment data for a given user. We explored options and we can see such information is…
-
Job requisition report not pulling all job requisitionsSummary: I created a job requisition report to show all open requisitions in a month. I need it to show any that are currently open plus those that were open and filled …
-
Bip publisher output doesn't clear cache as old message isnt clearedSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Job offer approversSummary: We need to create a report that includes: 1. Requisition Number 2. Job Offer Candidate Full Name 3. Job Offer Business Title (under Offer Assignment Details) 4.…
-
BIP Report - Certification File Attachment - Assemble URL for downloading attachment from reportGreetings, During Auditing, our desire is to be able to quickly download any Certification attachments direct from the BI Report results. I'm trying to create SQL for a … -
How to identify edited DOR in BI reportsHow to identify edited DOR in BI reports? -
OTBI Report with future hires and terminationsHello, We are attempting to build a report to help our partners keep track of I-9 completions. We are using the subject areas Worker Assignment Event Real Time and Work …
-
How can I find the system source ID/owner for payroll timecard from BI Report querySummary: We're attempting to update some timecard overtime rate entries using the HCM Data Load using USER KEY method, but system seems to still require SOURCE SYSTEM ID… -
Reported Time Card Real Time Performance Very SlowSummary: Reported Time Card Real Time Performance Very Slow Content (please ensure you mask any confidential information): Good Day, Is there a way to improve the perfor…
-
Illinois "Equal Pay Registration Certificate" reporting requirementSummary: Any suggestions or experience on how companies can best extract this data to meet this state requirement? Content (required): Good afternoon! Has anyone had to … -
default time zone when scheduling BI reportsSummary: is it possible to set a default time zone when setting the date on a scheduled BI report? our default time zone is London but when we open the calendar it defau…
-
how to assign a specific role to multiple usersSummary: We have a specific role that hold access to new features, however, when we go live this role has to be assigned to the respective users to enable/show this. I w…
-
Unable to create OTBI AnalysisHi to all, as an administrator user, when I try to create a OTBI Analysis I'm only able to view my own informations. I can't see the information about other users. The s…
-
Tables for BI Consumer role, BI Administrator Role, BI consumer role in oracle fusion HCMSummary: Hi All, I need a table name or query for BI Consumer role, BI Administrator Role, BI Author role in oracle fusion HCM. Need to write a SQL query like, who have …
-
Which table contains 'P45 Filed date' from oracle hcm payroll moduleProvide exact table name and column name to fetch ''P45 Filed date'' field. Field is from Calculation cards→statutory deductions→PAYE. Need this in data model and report.
-
Fusion table for Employee Vacation and Delegation rulesWe want to develop a custom BI Report for Employee Vacation and Delegation rules. However, we are currently facing some challenges in identifying the correct tables that…
-
Error While Creating BI Data Model using HTTP (XML Feed) option in Oracle Cloud (Release 12)Summary Error While Creating BI Data Model using HTTP (XML Feed) option in Oracle Cloud (Release 12)Content Hi Experts, I am trying to create report using HTTP (XML Feed… -
SQL query for Planned Schedules on Time ManagementHello! I need help in developing an SQL query for generating the Planned Schedules for employees on the Time Management navigation: My Client Groups>Time Management> Pla…
-
OTBI delimit data from 1 column into multiple columnsSummary: We have a report requirement where we want to delimit output from 1 column into multiple columns based on '/' delimiter Content (please ensure you mask any conf… -
Requesting details on the Fusion Tables used to extract “Tax Rate” from Values Defined by CriteriaDetails: We are creating an outbound custom BI Report to send Payroll Balance and Calculation Card details to Fidelity. One of the requirements is to extract Tax Rate of…
-
The filter should show just the Years: 2021 2022 2023 2024Hi, this is about the excel format ,When the user clicks on the filter for Date of Joining or Last Working Day, instead of seeing individual dates like:30-Jan-2023 08-Fe…
-
OTBI present last value of a column - ReportHi, we need to control when a employee change a department(from any department to any department) and this need to be done in a OTBI report to control a initiative. ive … -
SQL query to get net pay amount of an employee on the monthly basisContent Hi All, Creating an outbound interface where need to fetch the employee's monthly net amount. Hence, need SQL query for the same. Context: Employee have multiple…