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
-
Point in Time Headcount with Salary report - isolated doubling of salarySummary Our "point in time" report is mostly working. For a very small percentage, the salary amount is being doubledContent We have a report that is working fairly well… -
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 HCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Devel… -
pass parameter in formula in 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…
-
How to obtain the history of when a role is assigned and revoked to a userSummary: Hello All, As an Audit Requirement we need the complete history of when access is provisioned to a role and it is revoked. The following table ASE_USER_ROLE_MBR…
-
Standard payroll reportsSummary: Hi All, Please share all the payroll standard reports list. Best Regards, Sateesh
-
How to fetch custom attribute of Legal Entity in BIP?Summary: How to fetch custom attribute of Legal Entity in BIP? Content (please ensure you mask any confidential information): I have this custom field: I cannot see it i… -
How to print data from different levels in the same line in Etext templateHi All, I am using EText template for HCM Extract which results in Employee having Multiple Balances. The Requriement is to display the employee record along with all th…
-
BI Publisher - RTF Template - Numbered List in Offer LetterSummary: Hello everyone, I am new to build the BI Publisher, I would like to check a feasibility for my client requirement. My client offer letter has a numbered list e.…
-
How to display a BIP Report in multiple excel sheetsSummary: How to display a BIP Report in multiple excel sheets Content (please ensure you mask any confidential information): Hi, we would like to display the output of a…
-
Table FND_SESSIONS, columns FIRST_CONNECT and LAST_CONNECT, what do they mean?Summary: Content (please ensure you mask any confidential information): Can someone explain what FIRST_CONNECT and LAST_CONNECT columns in table FND_SESSIONS represent? …
-
Query to fetch legal reporting unit mapped to a legal entitySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Can we create custom views in Oracle fusion?Summary: Can we create custom views in Oracle fusion? We need to create the view to use it in a value set.
-
Issue occurring that seems to double values in certain fields e.g. FTE and SalaryContent We're experiencing an issue whereby assignment information in certain fields is multiplying; giving us inaccurate data. It's not occurring in the majority of cas… -
Unable to find Job Requisition & Offer DFFs in PVOsSummary: We are looking for the PVO(s) that shows the Job Requisition and Job Offer DFFs (IRC_REQUISITIONS_DFF & IRC_OFFERS_DFF). We have been unsuccessful viewing this …
-
How to list all locked users?Summary: How to list all locked users in BI Publisher? Content (please ensure you mask any confidential information): Table PER_USERS and PER_LDAP_USERS are related to u…
-
Which BIP table stores the attachments under Talent Profile?Summary: Which table stores the attachments under Talent Profile? Content (please ensure you mask any confidential information): I'm trying to fetch this attachment unde…
-
About OTBI, BI and EXTRACTSummary: Use cases for OTBI, BI and EXTRACT. When we use Extract, when we use BI and when we use OTBI Content (please ensure you mask any confidential information): Hi T…
-
Query to Get Created BIP Jobs and OTBI Agents in Oracle FusionGood Day Experts, I need to have a report listing all of our team's created BIP Jobs and OTBI Agents. Are there any available query to get this information (Job or Agent…
-
Display date in a pivot table (both for OTBI and BI Publisher)Summary: Display a date in a pivot table (OTBI and BI Publisher) Content (please ensure you mask any confidential information): Hi, I wish to create a pivot table like s…
-
Viewing reports history submitted by the userSummary: Our target is to see the reports history submitted by all the users in the fusion HCM. Please advise accordingly how can I retrieve this information. Content (p…
-
Certain talent dashboard is unable to fetch data for talent admin role in Redwood 25B InstanceSummary: In one of the 25B Redwood non-prod instances(eg. instance A) ,the below issue is encountered. There are multiple Talent reports and all are working as expected …
-
SQL query to create value set for Manage Organization Tree Node namesSummary: We need to establish a value set to define the node names under Manage Organisation Tree. Do we have any SQL query to get to get the Node Name? If not please te…
-
How to set a display order for the columns of a BIP Report (csv output)Summary: How to set a display order for the columns of a BIP Report (csv output) Content (please ensure you mask any confidential information): Hi, we created a BIP repo…
-
Career StatementsSummary: Creating a Career Development's analysis report and I am unable to locate Career Statement in the subject area. Content (required): Looking to add Career Statem…
-
Reporting on Career StatementsSummary Enhanced Talent Profile & Reporting on Career StatementsContent Hi, Prior to upgrading to the Enhanced Talent Profile we used the following subject area and colu… -
Unable to get data for Bursting even if no Bursting Parameters passedI am using below query. Requirement is to send email notification when :Mode of Report='Email' and this is working fine. If the :Mode of Report='Print' , the report shou…
-
How to display OTBI report in Journey task "report"Summary: Hi Team, I have a OTBI report and I want to display in journeys where employee can see the data and esign. I am using advanced task and but report is not coming…
-
OTBI Report does not show Person Legislative information DetailsSummary: Our business has created few reports where they are capturing personal details of users and it includes person legislative info but in OTBI the data is coming b…
-
Highest Education level not showing in OTBI person profile subject areaSummary: Hi Team, we have need to extract the report of each employee of highest education level but not coming in workforce profile - person profile real time . ANy one… -
Which table stores Payroll Association dates?Summary: We are able to report on Payroll Relationship Final Close date and specific Payroll Assignment dates, but cannot find the data for Payroll Association Final Clo…