Reports
Discussion List
-
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… -
25A-SOAK- Project Reports ending into errorProject Summary Reports are ending in error with below message. The same reports are up and running in Production and other environments where 25A has not yet been appli…Tina_Motwani 22 views 2 comments 0 points Most recent by Sue Gordon - Frontera Consulting UK Project Management
-
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… -
For the custom reports User is not able to see the data in the report outputSummary: For the Custom Reports, users are not able to view the data when they run the report. Content (please ensure you mask any confidential information): Version (in…
-
OTBI - Read Only ModeSummary: I have a service account that is set to Read Only Mode within Fusion, however when navigating into OTBI the account is no longer in read only mode and can edit,…
-
Smartview account description truncatingSummary: The customer has identified that the account description in Smart View (ESS) is truncating to 80 characters. This is making account identification by name impos…Maria Smith- de Novo Solutions 21 views 4 comments 0 points Most recent by NarayananS Financial Consolidation and Close
-
Is there any way to view report usage in Planning?Summary: My organization is interested in seeing how many times the reports we have developed have been run. Is a there any way to view this data? There doesn't appear t… -
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 11 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Query to get the final approver of AP InvoiceSummary: Hello, We have a requirement to fetch only final approver details along with Invoice/Requisition in a Invoice and requisition workflow report. Current report is…Sushmitha G 142 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP
-
Can reports be sent to users via email in Narrative Reporting?Summary: We need to be able to send reports created in Narrative Reporting via email to different users. We would like to know how this can be done and, if possible, if …
-
Is there a way to pull a member property that highlights the parent ownership?Summary: I want to suppress on a base member when the parent ownership is 0%. Is there a member property i can enable in NR that would pull parent ownership? Content (pl…mattk1528 1 view 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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…
-
We need a table to get the data for the setup Manage Labor Costing RulesSummary: Hi Team, We need a table or SQL query to get the data for the setup Manage Labor Costing Rules Content (please ensure you mask any confidential information): Ve…
-
Bursting Email attachment with a constant attachment.Summary: Is there is any possible way to add an extra constant attachment (pdf) to send an email bursting along with report attachment? If it is Possible please help me …Goutam5555 11 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Help to extract usersSummary: I need help to extract the following information: Person Number Email Username User Status (active or inactive) Does anyone know the query to do this? Thanks, A…
-
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…
-
Dynamic BIP Query executionWe have a requirement to execute dynamic query using BIP in oracle ERP Saas and was going through this (Doc ID 2636492.1) which says passing dynamic query as parameter d… -
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.7K 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 46 views 2 comments 2 points Most recent by Sonia Canumay Reporting and Analytics for HCM -
No Books visible in the EPM Books listSummary: We have not yet explored EPM Books and while I have enabled the extension, it's not showing any books in the list of book names. Content (please ensure you mask…Erringc 11 views 3 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close -
Could you share documentation about the types of charts that can be created in Narrative Reporting?Hello! We need documentation on the types of charts that can be used in the Narrative Reporting instance, along with details for each of them.
-
How to call one particular data model query into another report's Data Model without repeat query.We had a requirement that I have to use the query written in report-1 in report -2 without writing the whole query. I just want to refer that report-1 query and will bui…Nalsoft Pvt Ltd 11 views 0 comments 0 points Started by Nalsoft Pvt Ltd BI Publisher Learning Center
-
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…
-
Scheduled HTML output report does not deliver the message put in the Output tab of scheduled pageHello All, Hope you are doing fine. There is a business need to keep the output type as HTML of a Oracle fusion BIP report. Also when this report is run through scheduli…
-
how display member name alias on a formI am having trouble displaying the member name and the alias side by side in the rows of this form. What is shown below is the alias. The member names are the actual acc… -
Can we schedule a BI Report run and place the generated file in an SFTP location?Summary: Can we schedule a BI Report run and place the generated file in an SFTP location? How can we do this?