Reports
Discussion List
-
User does not see a delivered reportSummary: User does not see a delivered report Content (required): User clicks on Schedule New Process, and types "Reserve". She only gets results for the Reserve Detail …Brad Kirschner 11 views 5 comments 0 points Most recent by Brad Kirschner Reporting and Analytics for ERP -
Dynamic Logo in RTF Template in FusionContent Hello Team, Could you please let us know how can we use the Dynamic Logo in RTF Template in Oracle Cloud/Fusion. Same logo is called in many other reports and ou… -
EEO and VETS Reporting Set upSummary: Hi All, I am trying to run the delivered EEO and VETS reports from My Client Groups> Payroll> Submit a Flow area . But nothing is appearing in the LE dropdown a…Gaurav Rath- PGC 21 views 3 comments 0 points Most recent by Gaurav Rath- PGC Reporting and Analytics for HCM -
Display Report Job ID INSIDE the BIP ReportSummary: Display Report Job ID INSIDE the BIP Report Content (required): Is there any way we can display the "Report Job ID" INSIDE the BIP Report? or use it in the burs…Vinay Gharge 111 views 2 comments 0 points Most recent by Vinay Gharge Reporting and Analytics for ERP -
Download BIP Output based on Report Job IDSummary: Download BIP Output based on Report Job ID Content (required): Is there any API to download the BI Publisher output in XML format based on the "Report Job ID" w…
-
Attendance Register Report for LearnSummary Attendance Register Report for LearnContent Does anyone have an Attendance Register Report for Learn? To list delegates within a specific ILT Offering / Activity…Ruzwan Akram 72 views 2 comments 0 points Most recent by Esther Hess Reporting and Analytics for HCM
-
Using Session Variable can be used in BIP report to restrict data based on the user who will run it?Summary: Is Using Session Variable can be used in BIP report to restrict data based on the user who will run it? Content (required): Hello, I am running a BIP report reg…Hazel De Castro 41 views 7 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
Report to find details of history of all reportsHi Team, Could you please let me know if there is a way/ there is a report to retrieve details of all custom reports (OTBI/BIP) in terms of last updated by and last upda…Swapnil Kashid 41 views 2 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Is it possible to have an audit for FR reports?Summary: Customer wants to know if by any way we can get usage statistics for FR reports from system. They have a bunch of legacy FR reports and want to know which ones …
-
Need a query to get the Fixed Assets category combination along with all its account combinationsSummary: Need to get the following accounting combinations of the category combinations in accounting rules; Cost, clearing, depreciation reserve, depreciation expense,c…Dian Minshan 1.7K views 1 comment 0 points Most recent by Ahmed Mousa Reporting and Analytics for ERP -
View all intercompany AR and AP invoices in one place in Supply Chain Financial OrchestrationSummary: Hello All, I would like to see a consolidated/aggregated AP/AR invoices for BU/LE in Supply Chain Financial Orchestration. Or atleast query and view the AP/AR i…Vishnuvarth Subramanian-Oracle 31 views 1 comment 0 points Most recent by Satya Ganti-Oracle Supply Chain Financial Orchestration
-
How can we fetch "Non-Union Benefit Eligibility Dates" in OTBI ?Summary: From the attached screenshot we can fetch all the fields under Extra Information in Workforce Management - Person Real Time subject area except Non-Union Benefi…AaronJai 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need a BI Publisher Add-In Supported by MS Office 365Summary Need a BI Publisher Add-In Supported by MS Office 365Content Hi, We need a BI Publisher Add-In Supported by MS Office 365. Please provide a link to download the … -
Waterfall Chart data decimal issueSummary Color bar not showing up correctly due to 1 decimal.Content Hi, We are having an issue with the waterfall chart. 1. When we keep the decimals up to 1 the zero da… -
BI publisher not workingSummary Unable to use BI publisher in ExcelContent Hi folks! I need to modify a Excel Template for a Oracle Cloud report. It seems that my BI publisher is not working pr…
-
How do I schedule a Job, So that a Job starts when earlier scheduled Job is completed.Summary: Schedule a Job for 10 sets of Employees so that each job set starts before earlier Job completes Content (required): I need to schedule a Job for 10 sets of emp…Anjan Polimera 11 views 1 comment 0 points Most recent by Anjan Polimera Reporting and Analytics for HCM
-
Table for Pension Scheme name stored at PAE at UK calculation CardSummary Table for Pension Scheme name stored at PAE at UK calculation CardContent Hi Experts, I am try to pull the Active Qualifying Scheme for employee stored at PAE UK…
-
OTBI Previous Job History/Records Without Logical SQL or Custom-SQL/BIP - Possible?Summary History records of a personContent Hello, Can anyone please help me with the below scenario? I would like to get previous job changes/history (and few additional… -
Is there a way to display the values selected in the Prompt on the DashboardSummary Is there a way to display the values selected in the Prompt on the DashboardContent I created a dashboard, which contains the prompt and result area. as shown in… -
full outer join in BIP fusionHi, I have two queries and I want to use full outer join in BIP but it does not work. I am using select * from t1 full outer join select * from t2 on t1.A = t2.A but giv…Morad Alshammari 31 views 10 comments 0 points Most recent by Morad Alshammari BI Publisher Learning Center -
ESS Job ArgumentSummary ESS Job ArgumentContent Good People, We have a single argument for an ESS Job which is a STRING field. Unfortunately in the values we have DATA with comma e.g. A…Soumya Prakash Parhi 59 views 2 comments 1 point Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP -
Cannot Open Next Generation Reports in ExcelContent It's not possible to download next gen reports in Excel. I found a document on the Oracle Support. The Excel download is currently not available (only for Narrat…User_NJ6WE 57 views 5 comments 0 points Most recent by Ija Vidaurri Financial Consolidation and Close
-
Send remittance advice report querySummary: Send remittance advice report query Content (required): We want to customize send remittance advice process. And we need the seeded report data model query acce…Priyanka More-Oracle 123 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
To create custom subject areaHi All, Could you please let us know if there is a way to register a sql query as a custom subject area that can be used for creating an OTBI report. Our requirement is …Swapnil Kashid 81 views 4 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
OTBI Analysis takes about 20 minutes to return results, how to improve performance?Summary: OTBI Analysis for Master Headcount Report takes 20 minutes to display results. Content (required): Our client is migrating from EBS to HCM Cloud. Currently they…Vinay Hardas 81 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Merging cells for header row in management report gridSummary: Hi, I am wondering if if is possible to merge the cells of a row in a management report grid to be able to generate a heading row (top row or somewhere else)? I…
-
How to get a PTO Accruals report with ONE line of data for balance per EE?Summary: We are using a 3rd Party for our PTO Accruals (UKG). Primary issue: Some EE's are in 2 plans, so they have 2 lines of data. The issue is that UKG will only pick…
-
How to get a details of Clock Entries missing for 3 days or more (OTL Module)Hello all (Report Description: The list of employees who have missing clock entries for 3 days or more should appear in the custom report) can anyone please tell me wher…