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
-
Additional Information from Accrual Plan BalanceSummary Require Table and column name for additional information fieldContent Hi Team, I need to extract the additional information field description for the Absence Pla… -
Multiple Absence Actions Sharing the Same Object IDThere was an error rendering this rich post. -
Which table to get the Plan Period Start DateSummary Plan Period Start DateContent Dear Expert, Which table to can we get the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached … -
Issue while extending offerSummary: Dear All, We are trying to extend the offer for one of the candidate and getting below error: The job offer couldn't be extended. There was a problem with the j…
-
HCM alerts real time Subject Area - data not returningSummary: HCM alerts real time Subject Area - data not returning Content (please ensure you mask any confidential information): Hello I am trying to write an Analysis usi…
-
How to report on journey task expiration configuration?Summary: Is it possible to report on journey task expiration configuration (i.e. Task 1 expires 10 days after assigned date, Task 2 expires 10 days after due date, etc.)…
-
RTF Template| Bar Graph | Error: Invalid DataSummary: Hi all, I am working on the RTF template where requirement is to show the data in the bar graph format and it is giving me error like invalid data. For testing …
-
Query to get Scheduled BIP Jobs in Oracle Fusion HCMHi All, Is there a way to retrieve the schedule details of BIP reports like job name, report name, schedule start date, schedule end date, frequency etc. using a sql que… -
Where to Find Extract Data Stores Documentation for HCM related PVO'sSummary: Hello, We are unable to find the documentation for the Extract Data Stores for HCM . The same is available for Financials, Procurement and SCM. Can you please a…
-
BI tables for standard compensation plan columns regarding salarySummary: Content (please ensure you mask any confidential information): Hello experts, which BI tables store the following standard compensation plan column fields? New … -
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… -
Approach to get historical login details for a userSummary: Hi All - The ASE_USER_LOGIN_INFO table only gives me the latest sign-out details for a user? How can I get historical login/logout data? I also tried to use Fus…
-
UI End-Date and Database Records for Bank AccountsSummary: Hi everyone, I recently inactivated a bank account using the checkbox, and now I see a mismatch with the end date. The UI shows it as 01/07/2025, but the tables…
-
Need SQL query/table to get Progress note in goal detailsSummary: In goal details, there is option to enter progress note. Need table name or sql query to get progress note. Thanks Content (please ensure you mask any confident…
-
OTBI Report coming up with blank dataSummary: We created an OTBI analysis in Recruiting in Real Time and data is coming up blank. Content (please ensure you mask any confidential information): Summary: We c… -
OTBI report export is not pulling all dataSummary: Whatever the data showing in the report is not showing in the exported data. It's only around 5,000 records. Content (please ensure you mask any confidential in…
-
Repeating Groups - Excel Template BI PublisherSummary: Hi, I am trying to create a PO History Report and I am wondering if there is an easier way to group the data by a specific PO? Right now I have PO Number and PO…
-
HDL - DeleteSummary We are trying to remove Matrix Managers via HDL; but DELETE removes all historyContent Hello! We are implementing Matrix Managers and I've been tasked with updat…
-
Which table stored the incumbent details from position?Summary: I need to get the incumbent details from the position where 1-1 position management is used. Is it only "PER_ALL_ASSIGNMENTS_M" or any other table from where we… -
Repeating Groups - Excel TemplateHello. Does anyone have any idea on how to make this kind of layout on Excel Templates using BI Publisher? How to make a repeating group like this? -
How can I retrieve the full details of each exception?Hi everyone, I’m working on a report that returns schedule exceptions using the following query: SELECT 1 KEY, pse.SCHEDULE_EXCEPTION_ID, pse.SCHEDULE_ID, pse.SCHEDULE_A… -
Issue with Views in HCM cloud Learning Management (WLF_LRNR_COMPLETION_DETAILS_V) in SpecializationSummary Joins are missing in the Specialization item type part in the Views WLF_LRNR_COMPLETION_DETAILS_V and WLF_LRNR_COMPLETION_SUMMARY_VContent In the code of the vie…
-
Headerless csv output in oracle fusion BI reportingSummary: Hi Team, We have a requirement to get the extract in CSV format without header fields in the Oracle BI report. Content (please ensure you mask any confidential …
-
Incorrect values are appearing in OTBI report for leave durationSummary: We have created OTBI report where we are fetching absence details based on year and month (monthly absence report). If employee has taken leave for single month…
-
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…
-
Error when trying to save an analysis - don't have sufficient privilegesContent Recently we started to receive the following error after editing and analysis and trying to save it. "You do not currently have sufficient privileges to save a r…
-
Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time"Summary: Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time" subject area Content (please ensure you mask any confidential …
-
Audit Report - On Folder Permissions ChangesSummary: Content (required): We have a requirement on Auditing folder Permissions Changes on any OTBI folders This report in theory needs to show us When and Who and Wha… -
How to report on comments for Checklist QuestionnaireSummary: In OTBI, Workforce Management - Checklist Real Time, I am trying to find the column that shows what comments were made in the "Comments" field in the questionna…
-
BIP report, for identifying the missing Time EntriesSummary This will be useful If we are expecting to see missing time entries in report or infolets. This SQL query logic is based on the Working hours of the User.Content…