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
-
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…
-
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… -
Any function is available that can be used in OTBI reports for calculating annual leave balance.Summary: Any function is available that can be used in OTBI reports for calculating Annual leave balance. It should work same as 'balance calculation' in oracle fusion h…
-
primary address querySummary: Content (please ensure you mask any confidential information): Is it possible to tell when an address is set as primary? I see both PER_ADDRESSES_F and per_pers…
-
sql query to get job level in oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…