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…
-
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o… -
HR Help Desk queue resource subject area not giving correct resultsSummary: I have an OTBI report using the above subject area which is not returning the correct results. I want a list of Queues and the Agents assigned to those queues. … -
Probation Confirmation LetterSummary: We have a Requirement to send the Probation Confirmation using Oracle BIP Bursting . Can anybody share the Bursting Logic to call the IN .rtf Template or the US… -
Call Sub Templates inside Main RTF TemplateSummary: We are facing issue while trying to call the sub Template inside the Main RTF Template. It Returns Blank Page Output for the P_COUNTRY Parameter selected from L…
-
Annual salaries for current and terminated employees in one reportIs it possible to create a report with just a list current and terminated employees and their annual salaries?
-
Report to get Original Date Earned of element entrySummary: Report to get Original Date Earned of element entry Content (please ensure you mask any confidential information): Hi Team, Greetings! Does anyone have the repo… -
Entry Grade Name and Grade NameSummary: We have a custom Vacant Positions reports used for infolets - performance tile and data report. Below are the columns and filter for both reports Right now, the…
-
Can we remove or hide the destination from Scheduling BIP ReportsSummary: We have users who run scheduled reports in BIP but we do not wish for them to be able reports using the email selector or send anywhere else. Is there a way to … -
Data Model option does not show up in BIPSummary: Data Model option does not show up in BIP Content (please ensure you mask any confidential information): Hi All, Greetings! We have added the needful BI related…
-
We need a query to get Payroll Balance group usages mapped to Balance dimensionSummary: Hi. We need a query to get Payroll Balance group usages mapped to Balance dimension. When dimension changes(Quarter, Run, Month… ) then the Balance group usages…
-
Transaction console approval Transaction history report for Resignation and Termination transactionSummary: I need to Create the Resignation/Termination approval report which should include EMP ID, Name, Resignation Date, Last working date, Submitted by, Submitted dat…
-
Need YTD hours for a timecard for an employeeSummary: I am working on an extract where I need to pull YTD hours worked for an employee ( basically for entire BU). How can I pull the YTD hours from timecards which a…
-
How to edit Organization Code?Summary: Content (please ensure you mask any confidential information): Table HR_ALL_ORGANIZATION_UNITS_F has a field named "ORGANIZATION_CODE". It has the following val… -
Candidate date of birth and gender are not pulled from OTBI reportSummary: Hi, I have used Recruiting-real time subject area ans used "person date of birth", "person gender" columns to fetch the candidate date of birth and gender. Howe…
-
Adding prompt with manager for get the entire hierarchyContent Hi, any suggestion on how to insert a prompt in a OTBI to filter the result on manager and display the direct and indirect reports. Thanks Nicola
-
FDI - error combining Contract Type (from employment contract) filter with other subject areaHello, I built a canvas in my FDI workbook combining 3 subject areas: Performance Management, Workforce Core, and Employment Contracts. A table visual containing columns…
-
Not able to join 3 subject areasSummary: We would like to build OTBI report but will require to use 3 Subject Areas: Workforce Management- Person Real Time Workforce Learning -Learning Records Real Tim…
-
Query to Pull List of Candidates and Their Supporting DocumentsSummary Query to Pull List of Candidates and Their Supporting DocumentsContent Hi Experts! Looking for some guidance. We need to build a query that lists all candidates … -
Is there any standard report for document of record audit fields?Hi, After 26A the audit field (Last updated by) of the screen "document of record" are not visible anymore. For audit purposes, HR administrator needs to view this infor…
-
Looking for a query for Oracle Fusion HCM Templates on Disciplinary ActionSummary: Templates on Disciplinary Action Content (please ensure you mask any confidential information): I am looking for a query for Oracle Fusion HCM Templates on Disc…
-
OTBI - Return transaction directly before current transactionGood afternon. I searched the Customer Connect portal for an answer to this, but couldn't find one. Seems like it should be easy, but I'm stumped. Can anyone advise on h…
-
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…
-
Technical Specialization BI Pub ReportHello everyone, We need to create a BI Publisher report to retrieve the Technical Specialization for each employee. For this, we need to extract all technical specializa… -
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b… -
Query required to fetch the fields - Resident PSD Code, Resident School District, Work PSD Code.Hi, Does anybody have a query that will fetch the fields - Resident PSD Code, Resident School District, Work PSD Code, Work School District. These fields are present in …
-
Is an Organization DFF visible in OTBISummary: I'm trying to build an OTBI Report that will show our Organizations and a DFF that is tied to Organizations. This DFF shows under the Department folder in the W…
-
Virus Scanner Not Reachable - Unable to Archive Files in My Folders / Shared FoldersSummary: Content (please ensure you mask any confidential information): Hi, We are encountering an issue when trying to archive files in My Folders and Shared Folders. E… -
Need query to compare roles for personSummary: I want to compare roles for person based on role mapping. For example , role mapping has 5 roles and person has currently 2 roles only in that role map. I want …
-
is there a way to download the each OTBI report output from Dashboard in different formats?unable to find the option to download the report output from Dashboard
-
ASE_USER_ROLE_MBR table usage restriction and alternate table suggestionSummary: Is ASE_USER_ROLE_MBR not supposed to be used for BI reporting? If yes, what is the reason, and what could be the alternate way to get the role revocation detail…