Reports
Discussion List
-
Query bursting combined with Union AllI prepared a report using more than one UNION ALL and I want to send it as a notification, for this I prepared bursting and used it from the FROM condition of the first …Cansel Karasoy 191 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Calculating Past Experience of employees in HCM BISummary Calculating Past Experience of employees in HCM BIContent Hi; I was trying to calculate the total past experience of the employee in BI with the below formula bu…User_2025-01-22-18-29-47-758 126 views 3 comments 0 points Most recent by Vishnupriya Reporting and Analytics for HCM -
Reporting on approval transaction commentsSummary Reporting on approval transaction commentsContent Is it possible to report on the comments submitted under Attachments and Comments section for approvals not yet…Emily Robinson 185 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BIP - Organization HierarchySummary: Hello, Does anyone tried creating report in BIP with organization hierarchy details? For example: Enterprise Division Business Unit Department Level 1 Departmen…
-
Query to get time card approver name and approved dateSummary: I need query to get time card approver name. Content (required): I need query to get time card approver name. Version (include the version you are using, if app…Swati U 2.2K views 4 comments 0 points Most recent by Durgadevi-Oracle Reporting and Analytics for HCM
-
New hires are not showing in SQL reportSummary: New hires are not showing in SQL report. We created report by using Data model. When we export the report, there are not some new hires in it. Content (required…
-
Static/Reference Variable does not work for embedded reference doclet reportI have a Report Package which has a management report as an embedded reference doclet. I want to use static/reference variables in this embedded reference doclet but I'm…
-
Report for Equal Pay Registration Certificate in IllinoisSummary: Has anyone built a report for the Equal Pay Registration Certificate now required in Illinois? Attached is the template we were provided, which is missing quite…Melissa Gettman 11 views 1 comment 0 points Most recent by Jeremy Miller-Oracle Payroll and Global Payroll Interface (GPI)
-
produce cost centres from 2 area onto one reportSummary: extracting table tables onto one report Content (required): I'd like to be able to validate the date between cost centres show in "Departments" in HCM vs " Cost…Jeanette.Spalding 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Custom report to see who is listed as Read Only AccessSummary: Hi, Our Audit team would like a security report that lists everyone we have setup for READ ONLY access under Manage Administrator Profile Options Content (requi…Darrin N 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Financial Reporting Report failing after dimension uipdateSummary: Hi everybody, i have a quite complex P&L report with a lot of aggregation that takes 20 seconds to open. After a db refresh due to dimension update (about 6 dim…
-
Core HR Seeded report.Summary: Hi Expert, Does anyone one have core hr seeded report path, where I can see all seeded report. If possible, please share the document. Thank you! Content (requi…Mohammad Afghan 51 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Learning item access group -BIP table to fetch Person Number List details for Learning access groupSummary: I am working on one BIP report where I am fetching one column to learning access group members using Person Number List options. In which table the person numbe…Kamini Kaushik-Oracle 41 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
Can we change sign of accounts based on rules in EPRCS?Summary: Need crete a report with base level accounts where signage change required based on Account Number . Account starting with 1 Series -> + Ve 2 Series -> - ve and…AlokPriyadarshi-Oracle 21 views 3 comments 0 points Most recent by AlokPriyadarshi-Oracle Narrative Reporting
-
User ID impersonation to Data sourceSummary: User ID impersonation to Data source Content (required): When we are creating NR reports, we are giving Datasource connection hardcoded with Administrator Crede… -
Display multiple selected Prompt Members in Report Text HeaderOur report is set up to allow a user to run a report for one or multiple members of an Attribute dimension (the "Section" attribute dimension.) This is accomplished usin…
-
Change alias on the sender email IDContent Currently, when scheduled reports are received, they come from planning-test-[zone name] . Is it possible to change the alias (planning-test-[zone name]) to some…
-
there are a function or conditional that allow merge names to don't repeat?Summary: Guys, I'm creating a table where the intercompany dimension must be in a column and I'm using the level 0 function. The point is that I don't want the name of t… -
Change of Owner in Catalog FoldersSummary: What are all the actions that trigger the change of ownership for folder, sub folder and reports under it? Please explain in what all cases "System Account" is …
-
Find and Replace PROD path reference in extractsSummary: Find and Replace PROD path reference in extracts Content (required): Hi Team, Greetings! We have multiple extracts with reference to Production path on SFTP or … -
"Remove content control" in Word docletIn my PDF report package, I have a Word doclet that has a report embedded as a reference doclet. If I download the Word doclet and open the report, I can see the report …
-
How to export all pages on a dashboardHello, Is there any way we can export a full dashboard and it return the full table of results rather than just the rows shown on the dashboard page? Thanks, Stacey
-
Creating a database connection in Reporting Studio in EPBCSContent Hi, We tried to create a database connection in reporting studio in EPBCS. Navigation = Reporting > Explore Repository > Explore > Tools > Database Connection Ma…
-
Do I have replace report in Report Package everytime I enter data in planningHello Experts, I have a Report Package in Narrative Reporting which has a reference doclet report, which is sourced from the EPM Planning cloud. Every time I update data…
-
Excel report headers not displayed properlySummary: Content (required): Report headers are not displayed properly when downloading / bursting reports in excel format while they display just fine in PDF format. We…
-
Could please help me on to find FTE cloumn in OTBI subject areaSummary: Hi Team, We need FTE column in OTBI report, I have taken worker assignment real time but I can't find out FTE column. Any help me on . PFA. Content (required): …AjayKumar Maddipati 34 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to retrieve the OLD payroll frequency and NEW Payroll frequency in the BIPHi ALL, Kindly support me to resolve below issue: I have a requirement to retrieve the OLD payroll frequency and NEW payroll frequency in BI report. Following with other…RamkumarKadhiravan 21 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
SQL to retrieve fields for BI ReportSummary: Hi All Please share SQL query to fetch below details for generate bursting report. Thankyou, Ram Content (required): SQL to retrieve Employee Number, Employee N…RamkumarKadhiravan 71 views 8 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM