Reports
Discussion List
-
Position Request Status ReportHello, I am looking for a report that will give me all the positions requested for New Position, Backfill/Replacement, and Promotion by leader. Ideally the report captur… -
Report on User Name Last Updated DateSummary: I'm looking for a report to tell me the last updated date / last updated by for the User Name, please Content (please ensure you mask any confidential informati… -
How to fetch comments and attachments from hcm extract and bip report?Summary: I want to know, how to fetch comments and attachments from HCM extract and BIPreport? Content (required): Version (include the version you are using, if applica…
-
OTBI filter - Two columns don't matchSummary: Is it possible to create a filter (maybe a new column to calculate?) to only provide results if two columns don't match? I can't imagine it's a common thing, bu…
-
Dynamic SQL in query BISummary: I have a custom criteria in Person Security Profile and it contains an SQL query. I am able to retrieve that query on BI and I want to use that query in a WHERE… -
Benefit Enrollment Report which has all Life events and the Enrollments in an excel format?Summary: Content (please ensure you mask any confidential information): Can someone share the report format where we have the following format Effective date Life event …Hariharan_Sivan 3 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
OTBI Agent Not Sending Files to Distribution List EmailGood Day Experts, We have an OTBI Agent that is not sending the file to a distribution list email. The OTBI Agent is sending our dashboard to an excel file. Sending to i…
-
OTBI Report data issueSummary: OTBI Report data issue Content (please ensure you mask any confidential information): Hi All, We developed OTBI report with Workforce Management - Worker Assign…
-
When the employee open a report we need to send one email to same employeeSummary: When the employee open a report we need to send one email to same employee Content (please ensure you mask any confidential information): Hi Team, We have a req…
-
Query to find BIP report schedule detailsSummary: Query to find BIP report schedule details Content (required): Hi Team, We have requirement to fetch the schedule details of a BIP report like schedule start dat…Vasanthakumar Ravi 2.5K views 8 comments 1 point Most recent by Dev V Reporting and Analytics for HCM -
Generate an OTBI or BI report that notes mileage or kilometer distance from home zip to work locatioSummary OTBI or BI Publisher SQLContent Does any one know of a way to get, for each Employee, the distance in miles or kilometers from the worker's home zip to work loca…User_2025-01-28-21-53-32-678 49 views 2 comments 2 points Most recent by Sonia Canumay Reporting and Analytics for HCM -
table record to use for non benefits employees to new benefitsSummary: Hi, Writing a report to check the list of employees who are newly enrolled in the benefits. please share the table name which give the field name to separate th…
-
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…Dasari Dileep 266 views 5 comments 0 points Most recent by kanchana venkatasubramanian Reporting and Analytics for HCM
-
How to add values from column to Dynamic column in OTBIHi All, We have a requirement, to add one column values (Answer) to Dynamic columns (Question). Please see the below screenshot to clearly understand the requirement. We…Chaitra Lakshmi Krishna 42 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Licenses & Certs appearing on OTBI report but not seen in systemSummary: We are seeing a few different scenarios where our OTBI report is pulling in active (not expired) Content Items for employees, but we're not seeing them represen…Jessica D 61 views 5 comments 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
We need to get Timecard reason on like WFH or Client Site and so onWe need to get Timecard reason on like WFH or Client Site and so on please help with relevant tables
-
BIP error oracle.xdo11g.xqxp.XQException: FORG0001Summary: BIP error oracle.xdo11g.xqxp.XQException: FORG0001 Content (please ensure you mask any confidential information): Hi Team, Greetings! We have run into error for…Parag Hiremath 260 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
BIP Reports Metadata tablesSummary need Metadata tables for BIP reportsContent I am looking for the fusion table(s) that store metadata of reports (such as created by and timestamps). can someone … -
Is Oracle BI Publisher Desktop Plug-In freeSummary: The Oracle BI Publisher Desktop Add-In, which can be downloaded to work with MS Word and Excel, requires a separate license for installation on machines. We are…User_OPF0Z 170 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Dies anyone know the table and field for "Enrollment Type Description" in OBTI Learning?Summary: Does anyone know is what the table and field that correspond to "Enrollment Type Description" and/or "Enrollment Type" in OBTI. Specifically under "Workforce Le…
-
Unable to see all privileges in Security - Roles and Privileges Real Time SAWhen I am trying to fetch roles & their respective privileges from subject area(Security - Roles and Privileges Real Time). It is not fetching all the privileges. Can so…SHRUTI PRIYA 21 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to report on Workforce Compensation Change Statement Volumes executed by managers?Summary: We have our Compensation Change statements configured to Printed and delivered by managers, we would like to monitor and report on how many managers are accessi…Adam_Cantwell 13 views 1 comment 0 points Most recent by Adam_Cantwell Reporting and Analytics for HCM
-
Sql query required to identify time card approver and assignee detailsSql query required to identify time card approver and assignee details. We tried to join hrc_txn_header, hrc_txn_data and fa_fusion_soainfra.wftask to get the details. B…Abhishek Jois 242 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
How can we call BIP Report from Offer Progress Redwood Page through parameterSummary: Navigation: MyClientGroup>Hiring>Job Offer>Progress Content (please ensure you mask any confidential information): Version (include the version you are using, i…Nagendra Chitra-Oracle 23 views 0 comments 0 points Started by Nagendra Chitra-Oracle Reporting and Analytics for HCM
-
Converting to dateSummary: We have hire date and we are using this to create a two new columns called 'Current Year Anniversary Date' and 'Days to Anniversary Date'. It used to work earli…Simranjeet Singh 32 views 2 comments 0 points Most recent by Simranjeet Singh Reporting and Analytics for HCM
-
How to create report for this absence plan pageSummary: Hi , I want to code this page , can anyone help me in this . And i want to get the it as of balance calculation date my report should work. Content (please ensu…Vishnupriya 12 views 1 comment 0 points Most recent by Ionela - Oracle Reporting and Analytics for HCM
-
if a journey- checklist is deleted in ORC, what are the ways we can check who has deletedSummary: if a journey- checklist is deleted in ORC, what are the ways we can check who has deleted the checklist. We wish to capture the data of deleted ones Content (pl…
-
Need to get referrer Job Title and Referrer assignment status in OTBISummary: We are using "Recruiting - Recruiting Real Time" subject area to get Requistion number, requistion title, referrer person number, referrer person name, worker p…Rama123-Oracle 2 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to display column label values dynamically in a Matrix report using BI PublisherHi, We have a Matrix report requirement using BI Publisher where we need to bring across the row and column label values dynamically (as values are not constant) as per …Tejashree S 55 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM