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
-
Which table stores Career sites details in Recruiting?Summary: Which table stores Career sites details in Recruiting? Content (please ensure you mask any confidential information): Version (include the version you are using… -
personal email otbiSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Subject Area: Payroll - Personal Payment Details Real TimeHello, Could anyone help or confirm if the Subject Area: Payroll - Personal payment details real time can extract the Account Suffix for our Personal Payment Method? Cou…
-
How to hide Schedule option from BI Reports for ManagersSummary: We created a one of the report and provided folder read access to manager role, however - customer wanted to restrict the managers to stop schedule this report.…
-
[nQSError: 60009] The user request exceeded the maximum query governing execution time.Hi All, We have an OTBI report ,with "payroll-Element Entries history real time" subject area, when user run the report with date parameter they get the following error.…
-
How to eliminate duplicate measure after joining 2 OTBI subject areaSummary: Hi all, I have a report with 2 subject areas (HCM and Projects) Is there a way to show for highlighted values 8, instead on 40 reported hours? Basically is the …
-
FDI - Is there a Manager Flag or Supervisor Indicator field available for selectionSummary: Is there a specific field within FDI that can be used to check if an Employee is also a Line Manager? e.g. If I used the the Subject Area MTS HR Analytics - Wor…
-
Unable to add security permissions for HCM seeded report folderWe want to provide customized access to the seeded HCM report folders on the Reports and Analytics page, but we're unable to modify their security permissions directly. …
-
Original hire dateSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
What is the exact query to get all values of transaction consoleSummary: What is the Backend Query to get the transaction details of a particular transaction as it is appearing in the transaction console. Content (please ensure you m…
-
How to connect organization hierarchy with job requisition?Summary: I am using recruiting real time subject area and trying to connect Job Requisition with Level 3 Organization Name but unable to get result on the Level 3 org na…
-
Historical FTE values in BICCHi, The customer would like to extract assignment history data, including FTE, using BICC. I found that we can retrieve historical assignment data through HcmTopModelAna…
-
Unable to add security permissions for HCM seeded report folderWe need to give customized access to seeded HCM report folders in the Reports and Analytics page but unable to edit security permissions for the same. We have copied the…
-
Estado: HY000. Código: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] Se ha producido un errorSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
OTBI British Summer Time effecting dates in Payroll - Element Entries History Real TimeSummary: British Summer Time (GMT +1) is producing incorrect results from the date Prompt using Effective Start annd End Dates Content (please ensure you mask any confid…
-
Impact on BIP Schedule if Only Data Model is ChangedSummary: I’m planning to make changes to the data model of a BIP report. I want to confirm whether modifying only the data model will have any impact on the current repo… -
Can we filter data using values from two columns?Summary: To obtain the data using values from two different columns. Content (please ensure you mask any confidential information): I am working with Workforce Managemen… -
How can we convert CLOB datatype to string in OTBI Reports?Hello, We are trying to remove HTML tags from a CLOB datatype column in OTBI report by using Substring and Replace function in the analysis. This is resulting us to get …
-
Organization tree OTBISummary: We have an Organization Tree in Fusion HCM where: LE = Top Parent Node Division = Child Node under LE Departments = Child Nodes under that Division LE-->Divisio…
-
How to get shift name start time, end time for certain date, from the work schedule caledarSummary: In oracle Fusion, We need a query to identify the shift name , shift start time and shift end time as the following parameters shall be passed Emp number Date C… -
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… -
Oracle FDI – HCM securityHello Everyone, We have a requirement to restrict all access to C-Level executive data (e.g., CEO, CFO, CHRO, etc.) within Oracle Fusion HCM FDI Analytics. This restrict… -
How to display report parameters on the OTBI report output.How to display report parameters on the OTBI report output.
-
OTBI Report with SQL query filterSummary: Hi Team, We have a custom reporting requirement that involves applying complex, SQL-based filters. We are planning to implement this logic within an OTBI report…
-
Are there any seeded alerts for HR Help desk ?Summary: Hello Experts, We are looking to implement HR Help Desk for a client. However I am a little puzzled regarding the notifications capabilities of this module. Is …
-
BI Author user should have Read only access to Specific folder in Fusion BI CatalogSummary: Hi Team, We have a requirement where the user with BI Author access should have read only access on Specific folder in BI Catalog,Please let me know if you have…
-
Need to Extract Termination Transaction Approval DetailsSummary: Need to Extract Termination Transaction Approval Details Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to … -
OTBI Analysis Report – Duplicate Rows Issue Even After Enabling DISTINCTSummary: I am working on an OTBI analysis where I am seeing duplicate rows in the output. For example, the same Person Number and Person Name (e.g., "101 – Ben") is repe…
-
Want to fetch row values based on another column's value.I want to print mid salary values which are highlighted in screenshot, based on columns "overtime" and "grade rate name".
-
SQL query for Time Entries with Payroll result for the selected periodHi All, I have a requirement to fetch the columns as attached in the excel screenshot. The challenge i'm facing is i'm not aware how to join the Time Entries with Payrol…