Reports
Discussion List
-
Report to show 2 sets of data based on dates selected by the userSummary Report needs to show several fields for different dates(not necessarily the current and previous values)Content Hi All, I have built a query that returns data ba…User_2025-02-04-08-51-08-912 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Management Reports in Planning/EPBCSContent Will the Management Reports feature from Narrative Reporting be made available within other EPM business processes? I seem to remember talk of "Distributed" Mana… -
Financial Reporting Web Studio connectionSummary Reporting Studio asking for a DB connectionContent Hi Friends, In FCCS, when I open Web Reporting Studio & insert a grid, I get a Pop-up Window asking for DB con…Amit Agarwal-158816 45 views 3 comments 1 point Most recent by Vasantha Kumar Raman Financial Consolidation and Close -
Descendants level 0 in reportSummary Descendants level 0 in reportContent Hi All, I have to create a Financial Report in FCCS and I need to use the function Descendants level 0 of a spefic total acc…Antonio Barbaro 55 views 3 comments 0 points Most recent by Antonio Barbaro Financial Consolidation and Close -
Need to be able to identify all BIP Reports and Analyses that use particular field as filterSummary Need to be able to identify all BIP Reports and Analyses that use particular field as filterContent Does anyone know if there is an Oracle program that will iden…Rich R 46 views 3 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for HCM -
Getting data from a Data Model to test it (Ad Hoc)Content After the direct SQL query was removed, I am now forced to create a report for my data model when I want to see the data in any other format than XML or more tha…MaartenDIF 60 views 6 comments 1 point Most recent by User_2025-02-06-06-17-13-684 Reporting and Analytics for ERP -
Unable to See FR Web Studio Folders and content under SmartviewSummary Unable to See FR Web Studio Folders and content under SmartviewContent HI all We have an issue with SV and FR folders not displaying under SV. We can see the PBC… -
How to hide data model and edit access for BI ReportsContent Hi Export, We have a requirement to give only view access for BI Report and nothing other than. So we are planning to hide the data model so that a user can not …MohammadAfghanul Khair 289 views 4 comments 0 points Most recent by MohammadAfghanul Khair Reporting and Analytics for HCM -
Export PBCS Reporting Web Studio report to Excel with numeric formatting instead of textSummary Export PBCS Reporting Web Studio report to Excel with numeric formatting instead of textContent Whenever we open a PBCS Reporting Web Studio report in Excel all …User_2025-02-01-06-21-55-603 63 views 5 comments 3 points Most recent by User_2025-02-10-06-33-58-444 Planning
-
From which customer table can we find order_type fieldSummary From which customer table can we find order_type fieldContent Please suggest from which customer table can we find order_type fieldNageshwaran1 53 views 6 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for ERP -
New Role only seeing their information on any report ran in Reports & AnalyticsSummary PAYADMIN_READONLY_DATA_DATAContent Created a new role in HCM and it only when reports are ran it only shows their information, unless it is a line manager, then …Gabe K 57 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Environment variablesSummary Display current user details in environmentContent Hi, Has anyone come across any OTBI environment variables. Or is there a subject area that displays the curren…User_2025-02-05-23-02-10-916 90 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
ESS Access to Custom BI Publisher ReportSummary Access to a Custom BI Publisher Report as Employee Self ServiceContent Hi Friends We have a custom BI Report and one of the parameters is the name. Right now thi…Mansur Khalil 79 views 15 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Time entry hours by various time codes otbi/reportSummary Time entry hours by various time codesContent Hi, We have some time codes which are not payroll time types specifically. Either they are part of 'Regular Hours' …Anuradha T 60 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Check-In Performance Template BIP table Joins.Summary Can anyone please explain how goals and its feedback are tied/joined to check-in peformance template for reporting purpose using BI Publisher.Content We have a B…User_0REWN 78 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Create dashboard prompt using column with custom formulaSummary Analysis has calculated column with bins. How can I create a dashboard prompt using this column?Content I created a column that bins seniority years (seniority u…
-
ESS Administrator / Monitor / Operator rolesContent Hi I'm trying to find information on what exactly entails the roles: * ESS Administrator Role * ESS Monitor Role * ESS Operator Role Trying to give a user access…
-
Requisition approval notificationSummary Can we use seeded BIP Requisition approval notification as a FYI notification for submitter?Content Hello, We have a requirement to send a FYI notification for t…
-
Report needed for default expense accountSummary Report needed for default expense accountContent Hi I am trying to get a report of all users on oracle and their default expense account on OTBI but cannot find …User_2025-01-29-02-09-34-137 163 views 9 comments 1 point Most recent by User_2025-02-05-23-22-15-856 Reporting and Analytics for ERP
-
Can we create a multiple selection paramter in the custo ess job?Summary Can we create a multiple selection paramter in the custo ess job?Content Hello , We have create a one custom job for the BIP report and now the users are excepti…Koteswararao Yenikepalli 54 views 1 comment 0 points Most recent by Vikas Tiwari Reporting and Analytics for ERP -
Issues with the File Transfer Utility and the new Bursting commandSummary Online documentation seems to be incorrect on new file transfer utility bursting commandContent A couple of us cool cats attempted to try out the new bursting fu…WomanInEPM 47 views 10 comments 0 points Most recent by User_2025-01-30-18-01-31-461 Narrative Reporting -
Multiple attachments through BIP BurstingContent Hi All, Can we send multiple attachments (PDF, Excel) for an employee through BIP bursting in a single mail? Thanks, Visu
-
Approved GoalsSummary Need to find dates when Goals were approvedContent Hi, I need to find all Goals that were approved between the 20th - 23rd July but when I look I see there are m…User_2025-02-05-22-44-35-842 23 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
OTBI Anchoring date variationSummary Try to change Anchoring date in Performance Subject AreaContent Hi all we try to change in our OTBI reports the Anchoring Date of Performance Subject area: 1) Wo…Marco Francia 34 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Cycle query for Structures and Components.Content Hi there. I'm trying to get a by level BOM with tables EGP_STRUCTURES_B and EGP_COMPONENTS_B. It's not so easy to relate as in EBS, you guys have any good cycle …User_2025-02-07-06-48-26-537 22 views 1 comment 0 points Most recent by Ahmed Mousa Reporting and Analytics for ERP
-
PER_JOBS_F.APPROVAL_AUTHORITY Translate ValuesSummary Trying to pull in the Name (translate value) for the Approval Authority code on JobVersion 20B -
How to get invoice_number against transaction in RA_CUSTOMER_TRX tableSummary How to get invoice_number against transaction in RA_CUSTOMER_TRX tableContent Please help us to get invoice_number against transaction in RA_CUSTOMER_TRX tableNageshwaran1 94 views 5 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
Transfer ReportingContent Hello everyone, I am trying to get a transfer report built in OTBI. I have the basis of the report built and it is pulling the employees that I am looking for. H…Andy Whalen 59 views 2 comments 0 points Most recent by User_2025-02-01-03-43-13-079 Reporting and Analytics for HCM