Reports
Discussion List
-
can we restrict/hide viewing few columns based on rolesIn custom reports, i want to hide few columns based on the roles. I want to restrict the access of columns to few employees only. Is it possible to achieve?Reshma Eldho 8 views 1 comment 0 points Most recent by Divya Mangtani Reporting and Analytics for ERP -
FND_FLEX_VALUE_NORM_HIERARCHY is not available in fusion. Please suggest the replica table in FusionSummary: We have DWH implemented and as part of cloud transformation we are migrating from EBS to Fusion Cloud ERP. Hence, from DWH perspective, we are in process of ana…
-
Unable to access the Standard Invoice screen from the OTBI Action Link ReportSummary I am trying to navigate to the Standard Invoice Screen from the custom OTBI Report via Action LinksContent Hi , I had created a custom report with the Payable In…User_4A8FM 121 views 16 comments 1 point Most recent by Joanne Heathcote Reporting and Analytics for ERP -
Display modification in SmartView ad hoc analysisIn SmartView ad hoc analysis, I want to display hierarchies in a way where the parent value appears first, followed by the child value. How can I change this setting?
-
Synchronize Hierarchies from EPM to ERPIn EPM, we have established a project hierarchy under an "All Projects" node, with dimensions assigned by department. Our goal is to ensure these hierarchies are accurat…
-
Query for Approval DelegationContent Hello, I am looking to build a BIP Report which displays whenever someone has delegated approvals to someone of a lower job level - does anyone know where this i…Elliot Hall-Walker 249 views 3 comments 1 point Most recent by Gopi Krishna Pokuru Reporting and Analytics for ERP
-
SQL script for job roles inherited by data rolesSummary: Trying to build a query to fetch users with their data roles and inherited job roles. I am able to fetch the data roles and job role assigned assigned directly …Vaishnavi Agrawal 21 views 2 comments 0 points Most recent by Vaishnavi Agrawal Reporting and Analytics for ERP
-
NEW REPORT: Journal and Transaction Details ReportSummary: The Journal and Transaction Details report lists general ledger journals and subledger transactions activity along with header, line, and distribution-level det…Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle 868 views 31 comments 7 points Most recent by Rahul Sood-Oracle Reporting and Analytics for ERP -
Limit rows displayed on template in Bi Publisher.Summary: We have a rtf contains 3 paragraphs. The second paragraph should display a maximum of 10 employees per page, and the third paragraph should be displayed on all …Salma Mohamed Salem 197 views 5 comments 0 points Most recent by NagarajuKunchala Reporting and Analytics for ERP
-
How to identify new lines in a PO through tables?Hello community, We are customizing the purchase order PDF, and in a requirement my client asks to show the new lines that have been included in a change order after the…Fernando Chavez 5 views 1 comment 0 points Most recent by nothingname Reporting and Analytics for ERP -
conditional formatting in RTF for duplicateSummary: Is it possible to format rows so that a value is filled with yellow when the value is present in the data more than once? Content (please ensure you mask any co… -
Keyboard Accessibility Tab Order in Oracle Analytics Cloud Fusion Data IntelligenceIs it possible to set a tab order for a Keyboard Accessibility requirement in Oracle Analytics Cloud part of Fusion Data Intelligence? It currently take 30 tabs to get t…
-
Payables XML can't perform a substring to a concatenated string inside a for-eachSummary: When creating a payment request, we need to have all invoice numbers concatenated in the same field "Ref" from the XML template. However, the bank only allows l…Emma Fayos García 9 views 0 comments 0 points Started by Emma Fayos García Reporting and Analytics for ERP
-
Enter prompt variable in SOAP executeXMLQuery requestSummary: We have a report on which i have added a prompt variable to filter based on the email address. This works in the report itself: But when i try to get the report…
-
Is there a way to sort date type columns by default?Summary: Is there a way to sort date type columns by default? We want to sort this column with the DD/MM/YY format but by default we can only sort it by MM/DD/YY, if we …
-
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…Nalinee Uppiah 894 views 3 comments 1 point Most recent by Tom John Bontoyan Reporting and Analytics for ERP
-
Run large BIP reports using ScheduleReportWSSServiceSummary: In the following document Oracle advises using the ScheduleReportWSSService for executing BIP reports with substantial data volumes. Fusion Application BI Publi…Pradeep Moganti 21 views 1 comment 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How restrict custom BI report data based on flexfield segment valueSummary: How restrict custom BI report data based on flexfield segment value Content (please ensure you mask any confidential information): Hi All, We want to restrict c…
-
How to minimize the input parameters for the multiple Grid in a single FRS ReportSummary: Hello Exports, I have Created the complicated Income statement (IS) in (FRS) and the same/single report having 4 different Grid (Child) with in a report. While …
-
Terms & Conditions in PO PDFSummary: Hi Fellow Developers, The requirement is to host Terms and Conditions file in Oracle cloud and it should be printed as hyper link in PO PDF. when ever a Supplie…Dhilip Kumar P. 11 views 4 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
Is there a list of Essbase cubes and fields available for Cloud ERP?We are trying to find a list of all Essbase Cubes and the fields in those cubes so we can create reports more effectively in SmartView. Does anyone know where we can fin…DougDowler 81 views 5 comments 1 point Most recent by Antima Rai-Oracle Reporting and Analytics for ERP -
Custom Role to Run FRS Reports in OTBIHello, Is there a custom ERP Self Service role that can be created to allow users to be able to view and run FRS reports in OTBI? Or does it have to be a full ERP licens…Erik Nicholson1234 11 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Construction Industry Scheme (CIS)Summary:Construction Industry Scheme (CIS) Under the Construction Industry Scheme (CIS), contractors deduct money from a subcontractor’s payments and pass it to HM Reven…
-
Payables Trial Balance ReportSummary: I've set up a role so GL Users can run this report but when they do it errors with a permissions issue. Is it right only Payables Managers can run this report, …JohnG 30 views 3 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Employee Location not visible in custom report output for certain usersSummary: We have created a program that extracts all the posted journals for a set of accounts. In our implementation, Employees are stored as parties for making payment…Anand Balasubramanian 19 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
R13 How to generate a Trial Balance Report from OTBISummary R13 How to generate a Trial Balance from OTBContent R13 How to generate a Trial Balance from OTBIHello : I was wondering if you can share with me any document ho…gabriel kinovisques-163562 241 views 9 comments 0 points Most recent by Sachi Patel Reporting and Analytics for ERP
-
Unable to find the table and column in which "Grouped construction in progress" flag at project ExpContent Hi All, I am able to find the "Grouped Construction in Progress" flag at project expenditure level. please find the navigation attached. I'm unable to find the f…
-
sql query to fetch item number detailsSummary: We need a SQL query to fetch the item number, business unit, inventory item id, unit cost, total cost, sub inventory code, organization name. Kindly let us know…Dilip.Murugan-Oracle 850 views 11 comments 0 points Most recent by User_2Y0JM Reporting and Analytics for ERP
-
Hide Catalog Menu from OTBI reportSummary: we open a report from application by the following URL: https://xxxxxxx.oraclecloud.com/xmlpserver/Custom/xxxxx/SCM/Procurement/Purchase disbursement report/PO_…
-
submit multiple HCM Extract from OICWhen I submit multiple HCM extracts from an OIC flow using a while loop for incrementing (1 corresponds to extract 1, 2 to Extract 2 and so on), sometimes I get a SOAP f…Aloka Bhattacharya 8 views 0 comments 0 points Started by Aloka Bhattacharya Reporting and Analytics for ERP