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 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) … -
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? -
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 … -
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.
-
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… -
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…
-
Sample Report: Workforce Compensation Market CompositesSummary: Sample report showing how you can report on market composites within Compensation - Workforce Compensation Real Time Content (please ensure you mask any confide… -
Time Entry Audit Report for Reported timecards.Hi Team, I am trying to build a report, where we will show the Time audit details like Person Number, Time Type before change, Time Type after change , Timecard start ti…
-
How to make comparison between dates in FFSummary: Content (please ensure you mask any confidential information): Hello experts, we built the below FF. However it seems not working the highlighted condition in b… -
Request for SQL/OTBI to Extract Scheduled Process Parameters (ESS)Details: We are looking for a way to extract Scheduled Process details (ESS), specifically the following information that is visible in the UI for processes such as Calc… -
is there way to hide Page Options - Edit dashboard - we have access it through work areaSummary: Dear exports, We have created work area and provided below static url of the dashboard link to access the report. The manger's are able to see the ritNow, the c…
-
Email notifications the view is overlapping in mobile viewSummary: Hi folks, Email notifications in the view are overlapping only in the mobile view. Has anyone come across this issue? Regards, Sowmiya Velusamy Content (please … -
Can I speed up the search for people who successfully completed a course?Summary: I need to generate a list of who's completed a specific course. I don't care how often they've completed it - I just need to know if they've got at least one su…
-
Oracle table for termination reason in bip reportSummary: Unable to find the following data in oracle tables. I'm able to capture in otbi report, but we need a BIP report with same data and unbale to find in action rel…
-
OTBI Filter Criteriaanalysis result in error when no prompts are selected Errore Errore di visualizzazione della vista Errore durante l'elaborazione della query (SQLExecDirectW). Dettagli e…
-
Learning related subject areaI need to create report based on these inputs but I am unable to find relevant columns from the learning related subject areas. I am not aware of the proper columns. htt…