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
-
Common Question: I didn't get any rows in the subject area, what's wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row… -
Common Question: How to Ask for HelpSummary: How to ask for help in Reporting and Analytics for HCM Content: 1-Start by naming your subject area. If you don't know that, see: Common Question: In what parti…
-
Common Question: How to paste or copy an XMLSummaryExplains how to paste an XML ContentOften you may see sample reports in this forum, and this how you copy and paste the XML. 1-select new analysis 2-select a subj…
-
How to retrieve all active recurring ESS scheduled processes in Oracle Fusion CloudHi Experts, In Oracle Fusion ClouD, how can I retrieve a list of all active ESS scheduled jobs along with Process Name, Request ID, Submitted By, Frequency, Next Run Dat… -
Recruiter DashboardSummary: Today, Recruiters and some internal teams rely on multiple reports to understand the following: requisition status, candidate movement, Recruiter workload, and … -
Candidate Type in OTBII need to build a report of all candidates that we have in ORC, including their current candidate type. Example: the candidate below is Employee: But when i create an OT…
-
Query to get the user login time for last 365 days in fusion HCM ApplicationSummary: we are trying to find out the login timings of a Common user, we use this user for scheduling purposes, need a query to fetch the login timings of this user. Co…
-
Human Capital Management - Transaction Administration Real Time - Assignee person is missingSummary: Hi, I am trying to create analysis to show all pending approval transactions using Human Capital Management - Transaction Administration Real Time, but I am una…
-
Export Excel Output to PDF in Landscape Mode Without Data TruncationAfter downloading the report output in Excel format, the user would like to export the same Excel file to PDF format in landscape orientation without truncating any data…
-
Query to find fusion user details with their rolesI need to create a BI report which retrieves user information like user_id,username , email of the users along with their role information like role_id,role_common_name,…
-
HCM Extract PGP encryption appends .txt extension — supported workaround?Summary: We are generating an HCM Extract file and applying PGP encryption for SFTP delivery. The file is encrypted successfully, but the resulting filename includes an …
-
Profile BIP_CLIENT_REFRESH_TIME_HCM is not working as ExpectedStep1 Manage Administrator Profile Values Search for Profile :BIP_CLIENT_REFRESH_TIME_HCM Profile Value is 1440 Step2 we updated the profile value to 15 at Site level Sa…
-
ACA Eligibility Process updates Assignment Record with same action/action reason again on run dateSummary: When we run ACA Eligibiliy process lets say on 12/31/2025. It updates Assignment Record with previous/top of stack action and action reason. So if top of stack … -
Can we combine Recruiting subject area with Position subject areaHello, Are the two following subject areas compatible for combination in an OTBI analysis ? - Worforce Management - Position Real time - Recruiting - Recruiting Real Tim…
-
Changing time zone for BI reportsSummary: I need to keep the time zone as GMT-05:00 Eastern Time ( US & Canada) for all BI reports when I'm scheduling jobs. I followed the instructions of this document …
-
Feasibility on BI Publisher to UCM content Secure User Access for Reports DownloadsSummary: We would like to check the feasibility of scheduling BI Publisher (BIP) reports using the UCM Content Server as the delivery method instead of email. We have mu…
-
Impact on legal entity name changeSummary: Dear Expert, We have changed the Legal Entity name in the production environment. Could you please confirm whether this will have any impact on payroll extracts…
-
ORA_ELEARNING type: course or offer?Summary: Content (please ensure you mask any confidential information): I create a course and an offer, both of type ORA_ELEARNING. How to tell if these 2 learning items… -
Canadian Designated GroupsSummary: Add additional values to the Canadian Designated Groups Content (please ensure you mask any confidential information): In the Additional Person Info > Canadian …
-
Oracle fusion hcm OTBI Subject area for person extra infoSummary: I am looking for subject area in oracle fusion HCM that store person extra information. (i.e. Region (PEI_INFORMATION1), Capability (PEI_INFORMATION2), Service …
-
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens…
-
Unable to pull Action Reason from Job OffersSummary: After enabling Action Reason on Job Offers based on 26A feature, we are able to view Action Reason on offers. We need to access this Action Reason in Fast Formu…
-
How to remove Home / Catalogue line from dashboard?Summary: I need to hide the line from a custom dashboard (not a BIP report) Content (please ensure you mask any confidential information): Version (include the version y…
-
While creating Value set on oracle fusion getting error.The value column is not valid. (FND-2806)Summary: The value column is not valid. (FND-2806) In value set TID_Grade_Value, value column LISTAGG(distinct(prv.value), '; ') WITHIN GROUP(order by prv.value ) "UPGRA…
-
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…
-
We have requirement to create goal report contain all information like measurement and tasksSummary: Any Help regarding creating goal report to have goal info and measurement and tasks Content (please ensure you mask any confidential information): Version (incl… -
OTBI send ouput by email as attachmentSummary: On 26C. We developed a custom report and like to schedule it to run and receive the output as an attachment in an email However, I'm not getting any email. Is t…
-
RTF Template with the excel output format generating null rows in each excel sheetWe have created a report with RTF template and set the output format to Excel. The excel output has multiple sheets, but there is an empty row in all the excel sheet. We…
-
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R… -
Unable to configure scheduler profile in OTLSummary: Can any one share implementation guide or steps for configuration of scheduler profile in OTL Content (please ensure you mask any confidential information): Ver…
-
Help with Case When statementWe need to derive a Vacation Tier based on either the Assignment, Job, or Years of Service for an employee. It needs to first look at the Vacation Tier field on the Assi…
-
HSDL for Work Schedule AssignmentSummary: Does anyone have an HSDL template to assign Work Schedules? Content (please ensure you mask any confidential information): Version (include the version you are …
-
Where can we find Leave Balance in OTBI Subject areaDear , I want to leave balances for my users i created a otbi report (Workforce Management Absence Real time) but cant able to find leave balances in front i can see tha…