Reports
Discussion List
-
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.8K 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? -
Open button missing on Dashboard report, how to get it?Unable to see the Payables Withholding Tax Report Open button missing for this Dashboard report, I added BI Admin roles but can't see itEswarvoona-Oracle 1 view 0 comments 0 points Started by Eswarvoona-Oracle BI Publisher Learning Center -
How to call an Integration in OIC from ESS Job in Oracle Fusion SaaSSummary: How to call an Integration in OIC from ESS Job in Oracle Fusion SaaS Content (required): I have an Integration in OIC and I want it to be triggered by submittin… -
How to add values from column to Dynamic column in OTBIHi All, We have a requirement, to add one column values (Answer) to Dynamic columns (Question). Please see the below screenshot to clearly understand the requirement. We…Chaitra Lakshmi Krishna 41 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
How to display number into decimal number in Oracle cloud sqlHi Team, Need to know about the function to convert integer into decimal like 185 it should display 185.00 -
Reporting Lease balance in functional currencySummary: We are configuring the standard Lease accounting module for the customer and we need your help and support regarding the reporting of Lease accounting balance i… -
Report on inception to date activity on the Revenue aspect/Invoice aspect Development SOW projectsHello, We have a required to build a BIP report on inception to date activity on the Revenue aspect/Invoice aspect Development SOW projects. We need to fetch the financi… -
Licenses & Certs appearing on OTBI report but not seen in systemSummary: We are seeing a few different scenarios where our OTBI report is pulling in active (not expired) Content Items for employees, but we're not seeing them represen…Jessica D 61 views 5 comments 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
Seeded report listingSummary: Hello Experts Can someone help me with the listing of PPM (PFM + PEM) seeded reports ?Navya Krishna Yarlagadda 42 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Project Management -
We need to get Timecard reason on like WFH or Client Site and so onWe need to get Timecard reason on like WFH or Client Site and so on please help with relevant tables -
General Guidance on BICC/BIP for PVO JoinsSummary: General guidance on Fusion BICC/BIP for PVO joins & if Fusion supports AI/ML analytics? Content (please ensure you mask any confidential information): My unders…