Reports
Discussion List
-
ESS Job > Schedule Report > Enabling of Request Delivery Status Notification and Read ReceiptSummary: Hi, We are having some issues with sending Invoice PDF to our customer from an ESS Job. The name of the ESS Job is Print Receivable Program. We were told that s…marc.joed.de.guzman 32 views 3 comments 1 point Most recent by Maricel Ortega Receivables & Collections -
What is the difference between Apply of the filter and Refresh of the report outputSummary: We have built a report within a Subject Area, for which we have created a Dashboard. In this Dashboard, there is a section for the Prompt and a section displayi…AnnelizeHenskens 11 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Adding comments to FRS reportsSummary Add comments to specific cells in an FRS reportContent Hi All, Hopefully someone out there can help me with this, as its driving me slowly mad. We are currently …JennyB 44 views 1 comment 1 point Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP -
OTBI “General Ledger - Journals Real Time” which fields are these in the journal load FBDI template?Hi Guys In OTBI for “General Ledger - Journals Real Time” I can see 2 fields for a Journal Header I can potentially leverage: Journal Header "Additional Information (Nam…
-
How to find number of days for a month in FRSHow to find number of days for a month in FRSLakshmiVanarasi 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
FRS- How to replace Period Name with Calendar Date in Column HeadersSummary: Content (required): Hello. For columns in Income Statement we would like to be able to use the Calendar Date instead of the Period Name. For example, if Period …Marisa Escobar 66 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Which table holds the error details for failed records from "Customer Credit Hierarchy" conversion?Summary: Hi Team, In order to get the details of loaded and failed records when building a custom Reconciliation Report (BIP) for "Customer Credit Hierarchy" conversion,…
-
Need Audit tables list in Oracle cloudSummary Enabled Audit feature for Supplier header and supplier sitesContent Hi, Need help in Audit tables list for Oracle cloud, as per the requirement we enabled the au…User_2025-03-07-21-11-01-091 260 views 9 comments 2 points Most recent by Vasu Ramarathinam Reporting and Analytics for ERP
-
How to calculate in OTBI the receivable balance for any transaction on any dateHi all I created a report that shows the balance of receivables for each transaction using Subject Area "Receivables - Transactions Real Time". It shows the current bala…
-
RTF template to enable the checkbox option in generated emailSummary: I have a requirement like need to send mail to Manager asking to wheather contract extension is planned or not with No and Yes checkbox. ? Content (please ensur… -
BIP Bursting output with CSV fileSummary: BIP Bursting output with CSV file Content (please ensure you mask any confidential information): I am trying to burst a CSV file to an FTP server and I am havin…
-
Reporting Strategy/ApproachSummary: We have a client who is moving from a legacy application to Oracle Fusion ERP. What I'd like to get some expert advice if how the reporting was handled in a gre…
-
Getting the data in un-structured formate in excel file while extracting the dataSummary: Hi Team, We are trying to export the data for IBY_SYS_PMT_PROFILES_VL in excel format and we are getting in un-structured formate. Means some rows data are not …
-
Matrix Report with Pre-Defined Excel FormulasSummary: Once the report is downloaded if user modifies any value in a column then the dependent columns should recalculate the values based on the new value and excel f…Ripendra Kumar-Oracle 11 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP
-
OTBI Payables Invoices to Subledger joinContent We have a requirement to display Payables Invoices data (Payables Invoices Transactions Real Time) and their corresponding Subledger entries & other Subledger sp…User_2025-02-11-12-16-05-821 116 views 2 comments 3 points Most recent by Roberto de Santos Reporting and Analytics for ERP -
PO Change Order Amount Changed column detailsSummary PO Change Order Amount Changed column detailsContent Hi Friends, Can you please help me to get Amount Changed column details when PO Change Order action performe… -
Working report stopped and throwing an error ORA-01722: invalid numberSummary: I was able to use a custom BI Report a week ago. But it stopped working and throwing an error "ORA-01722: invalid number" when running. I am not sure what is ca…
-
Is there a function to get the display name from the username?Summary: Content (required): I'm looking for a function where you can pass the username and get the display name returned? I know I can do a query to the per_users table…CraigP 583 views 5 comments 0 points Most recent by Shivendra Kumar-Oracle Reporting and Analytics for ERP
-
I am looking for a database table from oracle fusion for resourc override screen from work executionHi All I am looking for a Oracle fusion table for Resource Override screen from Work Execution. Also, need to know how we can join it with shift exception table 'rcs_pla…
-
How can we accurately pull the unpaid invoice amount in an analysis reportHi All, We have an analysis report that was made to assist with pulling the unpaid invoice amount, however it is pulling 3x the value for some invoices and other invoice…FlatFish534 11 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
How to download pdf report in oracle apex?Summary: There is a provision to upload report layout and report queries in shared components in Oracle Apex application . We need a alternate method to call that report…Ajay Penkey 41 views 4 comments 0 points Most recent by Sylvain Martel Reporting and Analytics for ERP
-
How to monitor who and when ran a BI report that was not scheduled?We need to see who and when people run the BI Reports without scheduling.Kristel Janssens 21 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
How to remove special characters in the output of a e-text templatesSummary: We want to send all the open POs to a third party system in .txt format. The item description have a lot of special characters, how to remove it in the output w…SuniChacko 423 views 5 comments 1 point Most recent by suamanch-Oracle Reporting and Analytics for ERP
-
Are there any fusion tables that store the Daily Amount and Days on ExpensesAs in "Expenses - Expense Transactions Real Time" Subject Area Daily Amount and Days these fields are not present so is there any fusion table where we can get these det…
-
BI Publisher Pivot Table Limit/Configuration of able to add only 5 columnsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…S Javir 12 views 3 comments 0 points Most recent by Thulasipriya K-Oracle Reporting and Analytics for ERP
-
Unable to export the report in text format Windows (CRLF) UTF-8Summary: Hi We have a custom report. When we export the report in text format, should be export in Windows (CRLF) UTF-8 format but it is exported in Unix (LF) format. Ex…
-
Can multiple trees/hierarchies for the same segment be use in a single report?Summary: We are currently converting from PeopleSoft to Oracle ERP/EPM and are trying to understand the reporting and any potential limitations. We have multiple hierarc…Shannon Short 151 views 4 comments 0 points Most recent by Akash Verma Reporting and Analytics for ERP
-
eText BIP Template inserting blank row at top of output fileSummary: eText BIP Template inserting blank row at top of output file Content (please ensure you mask any confidential information): Hello, We have a BIP eText template …
-
I have created one BIP report, Output is .csv file. I am getting String values in Double Quote.Summary: I have created one BIP report, Output is .csv file. I am getting String values in Double Quote. I want to have the values without double quotes. I have tried it…VaibhavChavan20_ 64 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Unable to create a report combing planning and item category information with 2 subject areasSummary: Unable to create a report combing planning and item category information with 2 subject areas Content (please ensure you mask any confidential information): The…Sudhir Behera 11 views 1 comment 0 points Most recent by Yann Consolin-Oracle Supply Chain Planning and Collaboration