Reports
Discussion List
-
FRS with records exclusion for given company/PBSSummary: is it possible with FRS to exclude certain CoA records for one PBS value but include for other PBS value? Content (please ensure you mask any confidential infor…Roman Havrylyak 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
OTBI - Withdrawn Sickness output not displaying in Absence Real TimeI have built an OTBI report in Workforce Management - Absence Real Time, that I intend to use to report on sickness absence with a 'withdrawn' status. However, nothing i… -
Financials Cloud OTBI Release 12: Subject Area Description DocumentSummary This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.Content Use this…Anand DN-Oracle 395 views 6 comments 3 points Most recent by Ajay Hareesh Reporting and Analytics for ERP
-
How to merge customer names with transactions in a grouped SQL query?Hello, I have this customer ABC having multiple transaction i want to merge the cells that have the same customer name and make it appear one time, i am using select fro…Omran Zeaiter 31 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Receivables Sales VAT Register for Italy ended in error without outputSummary: Dear All, I ran Receivables Sales VAT Register for Italy and Purchase VAT Register for Italy but they ended in error Content (please ensure you mask any confide… -
Scheduled Jobs ErrorSummary: Hi Team, We have few scheduled jobs which will run on daily basis. Recently few system automated jobs and manual scheduled jobs ended in error without any log f…Sesha Sailini 21 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Trending FRS Report to exclude 13th Period?Summary: How to exclude 13th Period in Fusion FRS Report? Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snip…Prakash.Malmarugan 111 views 6 comments 0 points Most recent by Kenney Reporting and Analytics for ERP
-
What are the Table names for fields "Other Communication Accounts" and "Order of Preference"Content (please ensure you mask any confidential information): What are the Table names for fields "Other Communication Accounts" and "Order of Preference". Need to fetc… -
Rest API to GET reports from BIP in Fusion Financials SAASSummary Is there a Rest API to get BI Publisher reportsContent Hi All Is there a Rest API to call BI Publisher reports from Fusion Cloud Financials within SAAS financial…
-
Republish option not enabled in scheduled BIP reportsIn some of the scheduled BIP reports with excel template, the 'Republish' option is not enabled. Even after checking Save Data for Republishing, clicking on 'Republish' …Sharmava 62 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
OTBI GL Subject Area: 'General Ledger - Journals Real Time' unable to find the 'Approval Date'Summary: Hi All, While developing OTBI report for General Ledgers, We are unable to see the 'Approval Date' for the journal in 'General Ledger - Journals Real Time'. Kin…Venkat_P-Oracle 101 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
How to get list of custom BI and OTBI Reports in FusionSummary How to get list of custom BI and OTBI Reports in FusionContent Hi, Do we have any standard ESS job or tables which can give us below details of custom report: Na…Nidhi Chhajed 1.3K views 8 comments 0 points Most recent by Arun Raj Reporting and Analytics for ERP
-
How to remove Contract Template PDF Cover Page?Summary: How are we able to completely remove/delete the cover page on the contract template PDF page? We were able to remove the signature lines on the last page but ha… -
Create Rules XML File for BI Extender Automation - NO LOVwhen i run Create Rules XML File for BI Extender Automation program, its not showing in any LOV in parameter, role is already assigned to user What could be reason ?Sandeep Nihalani 119 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Oracle Analytics Cloud (OACS) Training for a BeginnerSummary: Oracle Analytics Cloud Training for a Beginner Content (please ensure you mask any confidential information): Hello, Can anyone recommend training or resources …Lola Kassim 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
formatting currency through DM or RTF?Summary: when customizing a DM and RTF, I need to format the currency into $****,****.XX format. Content (please ensure you mask any confidential information): Should I … -
Need Custom Advance Shipment Report fileSummary Need Custom Advance Shipment Report Sample fileContent Need Custom Advance Shipment Report fileNageshwaran1 29 views 1 comment 0 points Most recent by Mahmoud Abdulghany Reporting and Analytics for ERP -
Query To Find Label Name For Each Node ValueSummary: Dear All, I need a Query to extract Label Name for each Node Value. Content (please ensure you mask any confidential information): Dear All, I need a Query to e…Elisa Riz 83 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
how to calculate BEG_BALANCE_CR for QTD in glSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…User_L7QIF 12 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Deep Link to navigate to CHANGE REQUEST,PROPOSAL or CONCEPT using OTBIHI All, We could see the deep link doesn't work for CHANGE REQUEST, PROPOSAL ,CONCEPT and REQUIREMENTS. If I try to use OTBI dashboard a blank page opens up. However, wh…Swapnil Kashid 2 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
SQL query to get transaction date on statement lin, joining CE_BAT_TRANSFERS with CE_STATEMENT_LINESI'm trying to create a query where I want to find the transaction date of an Internal Bank Transfer. The goal is to create a report which is used for reconciliation of b… -
How can we merge multiple OTBI report lines into one lineWe are building one report which contains project wise team member details. As per the requirement, we should have one line in the report for each project displaying eac…Sanket.Kakde 468 views 7 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Can I change bip:AUTHOR on a saved BI report?Summary: Is it possible to change the bip:AUTHOR value on a saved BI report? Content (required): I want to make some reports public that I've exported to a .CATALOG file…JimCC 83 views 5 comments 0 points Most recent by Shanmugaraja_Karunamoorthy Reporting and Analytics for ERP
-
Custom BIP Report Dynamic Column IssuesSummary: The requirement is to print the output in below format: For each period, there should be a row and corresponding value in dynamically generated column. Ex.- For…
-
BI Excel Template missing formula when data generatedSummary: I've created a BI Excel template based on a DM and the requirement is to have certain columns color coded in the end of the report and also have a formula field…KrishnakumarPathipati 31 views 5 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
retrieve latest entry from table OKC_K_HEADERS_TLSummary: I am trying to get only the entry that has the most recent creation date from this table. Content (please ensure you mask any confidential information): Creatio…
-
Identifying Underlying Queries for SmartLOV/ VOs In BI PublisherSummary: Content (please ensure you mask any confidential information): Hi experts, Would any of you know how to identify the underlying query for a view object in BI Pu…
-
Adding a custom report to DOR screenSummary: Adding a custom report to DOR screen and need the report to fetch data related to current employee but the report fetches null. Content (please ensure you mask …Salma Mohamed Salem 11 views 0 comments 0 points Started by Salma Mohamed Salem Reporting and Analytics for ERP
-
Etext template output file(.txt) is unable to print Arabic language in sequenceSummary: We have custom Etext template under disbursement payment file formats. In that Supplier name is required to show in Arabic language in output file. for testing …SireeshaJaladi 43 views 2 comments 1 point Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
Oracle EBS - invalid SessionSummary: Oracle EBS - invalid Session Content (please ensure you mask any confidential information): How can this be resolved fndgfm.jsp error : The current session is i…