Reports
Discussion List
-
Report showing enrollments As Of Prompted DateSummary: Requirement is for an OTBI report showing enrollment detail as of a prompted date and plan(s). For example, what employees were enrolled in Voluntary Life as of… -
Beneficiary missing some dataSummary: Hello! I am using subject area Benefits - Enrollment Real Time to pull out primary beneficiaries. I have a record in file that is missing some data. EMP Person …Sarah D 41 views 5 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
How to setup dynamic filters in BIP report?The dynamic filter should adhere to the following logic: Year: If today falls between February and December, use the current year. If today is in January, use the previo…Janardhan ACS-Oracle 44 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
Profile id not available for some employeesSummary: Profile id not available for some employees Content (please ensure you mask any confidential information): Hi experts, we want to create a report that retrieve … -
Can I switch off the "No Data to Display" text for a suppressed report gridI have a Report grid that displays capex spend by program of work categories. Conditional row suppression is used to ensure only the relevant program line items are disp…
-
How can I work with user defined dimension that exceeds 2 M cells?Summary: I'm currently working with a report with several attributes to displayed. They are needed to label the business units from the user. When trying to run my repor…
-
is there any way to hide the rows in excel using bi publisherSummary: Hi, I am new to bi publisher and wanted to have this in my report template using excel. is there any way to hide the rows in excel using bi publisher that is be…
-
Documenting the Technical part of Dashboard customizationSummary: Hello, We utilized the Oracle cloud prebuilt dashboards, added custom formulas, new attributes, groups and documented the technical part of custom changes with …
-
AR Aging Report Issues in BI PublisherHi everyone, I'm hoping to get some help with an AR Aging Report built in BI Publisher. I inherited this report from someone else, and I'm facing two issues: Missing Cus…
-
StevenRigby 1 view 2 comments 0 points Most recent by Raavi Divya sri-Oracle Profitability and Cost Management
-
unable to select prompts on a epbcs report grid for graphSummary: Hi All, I am currently trying to create a report in epbcs reports module for a graph. I have many grids on the report and I need to show a graph for a certain a…
-
Exporting to excel corrupts the title's formattingHas anyone noticed the title formatting is jammed together when exporting to Excel. There's no issues when viewing in HTML. I have attached the screenshots below. The fi…
-
Parent manager 2 job tileFrom the Worker Assignment Real Time Subject Area I could get the Parent Manager 2 Name. How do I get the Parent Manager 2 Job Title ?Trupti Khodke 13 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
DOJ from date and to date , DOE from date and to date parameter not working in BIP reportHello , I have create Date of Joining date parameter and Date of Exit parameter, however when user try to select dates and filter records , records are not getting filte…
-
How to build a repot to get all action changes on the EMP recordI am using Worker Assignment Event real time subject area, to pull all the actions that happened on the employee record. When I add action and action reason I noticed th…Trupti Khodke 73 views 14 comments 0 points Most recent by Trupti Khodke Reporting and Analytics for HCM
-
Report detailsHi, There are lot of reports we are using and we want to know security of each report. Is there any way to find out below details from system 1)List of reports 2)Roles/p…Namrata_20 24 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
can we use fetch multiple columns using single case statementHi Team, i am using the case statements as below to retrive the data for a single person but it is giving me the 4 rows for same person is there any way to group them al…Chetana Pawar 23 views 1 comment 0 points Most recent by Swathi Shetty Reporting and Analytics for HCM
-
Books in Narrative reportingHello Everyone, We have included few reports in book which are having the prompt to select the members. While running the book we have to manually select the members for…
-
Costing of PositionContent Hi All, I am trying to get the Costing of position in SQL query. Does any have the SQL which can give the costing details of position. Thanks,Misbahul Khair-266763 479 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Journey report - display 'Saved as Draft' status in the reportHello, Related to Journey, I want to create a report that shows the task's progress status for each performer. In case of the performer saves the task as "Saved as Draft…Liran 23 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
Dynamic Period and Year selection in bulk set of reportsSummary: How to setup reports to enable all users (+/-50) to be able to pull any reports/books for any month (not only the current month) at any time. Content (please en… -
Certain Term'd EEs not displaying in Transaction Accuracy Audit ReportSummary: Using the Transaction Accuracy Audit Report from the Powered Reports and Analytics/Human Capital Management/Workforce Administration folder in the Reporting Cat…CGardner01 3 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
Days of service calculationHi Team, I am using "Workforce Managemnet - Work Relationship Real Time" subject area and I want to calculate "Days Of Service" only for Terminated employees. I want to …Raghu_Nandan 21 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
How to get Collective Agreement detail from Workforce Management - Worker Assignment Event Real TimeSummary: Before 24A we were able to get the Union member and bargaining unit on our analysis from collective agreements folder of Workforce Management - Worker Assignmen…
-
How to create a financial report showing 12 months rolling backSummary: I need to create a report that always shows data for 12 months period back starting the choice made on a prompt for year and period Content (required): So, if I…Gianluca Natili 97 views 8 comments 0 points Most recent by User_PN40M Financial Consolidation and Close -
OTBI Report: Worker Number nullSummary: In a custom OTBI report, starting from this month, suddenly the Worker Number, from "Workforce Management - Work Relationship Real Time"."Work Relationship Deta…Gian Luca Triglia 15 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Create SQL Group By Effect in NR ReportQuestion: Is there a way to use the NR report building tools to create the same result as a SQL "GROUP BY" clause? Background: I'm trying to create a report in NR, which…
-
How to get the Name equivalents of RECRUITING_LOC_HIERARCHY_ID and RECRUITING_ORG_HIERARCHY_ID?I'm trying to get the Recruiting Type, Recruiting Location Hierarchy and Recruiting Organization Hierarchy from the Areas of Responsibility - Scope section, but I only h…