Reports
Discussion List
-
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… -
Payslip - Other Deductions Section is showing doubled amountSummary Need help in determining if the issue is just with the BI Report or if the dataset is pulling in the wrong informationContent An employee had his garnishment (In…User_2025-02-04-08-51-08-912 54 views 2 comments 0 points Most recent by Saisandeep Nutheti Reporting and Analytics for HCM -
OTBI report update historyWe have several OTBI reports being updated that are not deployed by our support team. How is the owner updated to System Account? Is there a way to get the audit history…Angela Grace 12 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to show person data at the time of absence submission in OTBI?Summary: We have a requirement to show the person data at the time of submitting their absences. But the OTBI report brings the latest job name, FTE, department, busines…Ridma Karunanathan 11 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
admin is unable to see contents in user foldersSummary: In the past we have been able to see the contents in a users folder when in Admin view. Now we can no longer see the files. Has anyone else experienced this iss…
-
Questionnaire report with Question that has multiple answers - duplicating rowsSummary: Has anyone successfully been able to get a report on questionnaires that has a 'check multiple choices' question on one row for an employee who selects multiple…Rachael Puthoff 22 views 2 comments 0 points Most recent by Rachael Puthoff Reporting and Analytics for HCM
-
How to pull data from Additional Compensation in BIP ReportsHello Experts, Does anyone know how to or who has available SQL to fetch these data from Additional Compensation ThanksJoliver Caangay 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
23D:AUDIT MASS DOWNLOAD OF DOCUMENT RECORDS-hr_dor_mass_requestsHello All I am trying to query the hr_dor_mass_requests and its populating the values. It populates the numeric values for status and object version number as 3,4,7. wha…
-
Audit Report for Talent for changes in skills and qualification pageSummary: Audit Report for Talent for changes in skills and qualification page Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there…Parag Hiremath 2 views 0 comments 3 points Started by Parag Hiremath Reporting and Analytics for HCM -
Which table contains the information from Manage Legal Reporting Unit HCM Information ?Summary: Content (please ensure you mask any confidential information): Which table contains the information from Manage Legal Reporting Unit HCM Information? Version (i…OliveiraRR 23 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Performance Document - Current ApproverSummary Need report for who is the current approver of a perfomance documentContent I have the report which shows the Next Performance task status. Which is great, but i…
-
Historic Grade Steps in OTBISummary: I can see a previous grade step and current grade step using the screens, I wish to see the same information using OTBI. Content (required): When I create an An…ScottHillier 85 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Non-typeable flags - Audit ReportI cannot put the flag on "Show User-Related Details", "Show Attribute Details" and "Show additional object identifier columns", when exporting audit reports. What role/p…Greta S 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
ORA-01719: outer join operator (+) not allowed in operand of OR or IN with payroll reportHi, The environment was recently upgraded to version 24D. Following this upgrade, the payroll report started encountering the attached error during execution (ORA-01719:…Saurav R-Oracle 111 views 1 comment 0 points Most recent by Matthew Hancock Reporting and Analytics for HCM
-
We need to know table which stores Absence StatusContent Hi , We need to know which table stores status shown in attached screenshot. I have checked columns ABSENCE_STATUS_CD and APPROVAL_STATUS_CD in table anc_per_abs…Nidhi Chhajed 689 views 13 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
how to customize employee promotion letter notificationSummary: how to customize employee promotion letter notification Content (please ensure you mask any confidential information): Hi Team, We got a requirement to add new …
-
I am not able to fetch the pay value for Social Security DeductionsI am not able to fetch the Pay Value of Social Security Deductions For Oman Salary Payment Report in Oracle Fusion Cloud HCM . Can someone help me out with the query or …Tuhinaa Nanda 3 views 1 comment 0 points Most recent by Tuhinaa Nanda Reporting and Analytics for HCM
-
Need SQL Query to fetch degree of the employeeSummary: Hi experts, I need an SQL query to retrieve the degree of an employee. If possible, please provide sample data along with the table and column names to help me …Arti_Priya 55 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
HSDL Updates to Requisition are not captured in IRC_LC_HISTORY TableSummary: When a requisition is updated using HSDL and if EXT_PUBLISH_JOB_STATUS , EXT_PUBLISH_JOB_END_DATE columns are being updated without any change to phase or state…vinay karumanchi 13 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Spreadsheet Data Loader (HSDL)
-
Assignment Manager (Unsecured) significantly slower in Workforce Performance Subject AreasSummary: Material / significant slowness that appear to be driven by [Assignment Manager (Unsecured)] folder within Workforce Performance Subject Areas, relative to othe…
-
OTBI Dashboard only shows Indirect on promptSummary: OTBI dashboard is only showing Indirect in drop down prompt. Need to be able to choose between Direct and Indirect reports. Content (please ensure you mask any … -
OTBI - Calculate age in years and monthsSummary How to calculate the age in years and months?Content Hi, In OTBI I want to create a column which present the full age of the employee, for example 43.12 (means 4…Yaniv 824 views 18 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
how to convert blob type to actual text in oracleSummary: the underlying tables store the xml data of employees in blob format, the customer wanted to see the exact content of this File_data column in output results.. …Rama123-Oracle 46 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to get one time data in audit tables after enabling auditing for HCM processes.Summary: How to get one time data in audit tables after enabling auditing for HCM processes. Content (please ensure you mask any confidential information): We have enabl… -
Generate a count of employee self service requests for certain employee data fieldsSummary: Is there a way in OTBI to generate a count of the number of times an employee changed personal information data in self-service over a period of time? My unders…
-
MMM-YY date format, grouping dates and showing same value in promptWhen doing the custom data format for a date field as MMM-YY, how can that be achieved in the prompt so that they're only having to select a single value for the month a…
-
Fetching Job Requisition with Sensitive Information in OTBIHi Team, We are fetching job requisition details from OTBI in the Recruiting - Recruiting Real-Time subject area. However, we also need to retrieve additional candidate-…Jeeva - Cloud Vantage 18 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Query to get REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, REQUISITION STATUSSummary: Can anyone please help me in writing a Oracle SQL Query for BI Report to fetch columns like REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, RE…a.w.anand 2.2K views 9 comments 0 points Most recent by Gongati Nandish Kumar-Oracle Reporting and Analytics for HCM
-
Fast Formula with FF type "Extract Criteria" is not working when we are trying to add it in extract.Summary: Hi Team, We have designed extract to pull the employee assignment details but it was picking the multiple records for an employee. We used fast formula in "Filt…
-
Is it possible to add a Field Tag inside the Textbox in RTF TemplateSummary: We have a requirement to add name field inside a text box and add a photo inside a circle shape. I tired, but not able to add those fields. I even tired to add …Sujeeth Chinta 75 views 9 comments 0 points Most recent by User_OCKZO Reporting and Analytics for HCM