Reports
Discussion List
-
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 1.8K views 43 comments 8 points Most recent by Naomi Reporting and Analytics for ERP -
Can you run a process and have the report/file generated from the process sent to a set folder?Hi Everyone, Is it possible to have a process run adhoc or scheduled and when the process finishes the report output is sent to a file/folder location? For example, if o… -
Browser is getting automatically refreshing when scheduling ESS job set in Oracle cloud ERPSummary: Hi All, I hope everyone is going well!. I need some help in resolving the ESS job set related problem. I have created the ESS job set with 10 Ess jobs inside of…VasanthaFusion90 15 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
error using data mode property: Optimize Query ExecutionSummary: Hello everyone, a few days ago I experienced a new situation. I have a report that extracts a large amount of data (over 100,000). I tried to optimize the execu…Ayala01 13 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Query to Find Privillages under Role and its Inherited RolesSummary: Need query to get privileges assigned under Role and its inherited Roles. Content (please ensure you mask any confidential information): Tried Below query but l…Nishanth B Jain 63 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
I want to restrict last line of any receipt line to be printed in EDI Etext template for the clientWe have 2 new BIP report enhancement requirement To restrict every receipt's last line to be restricted in the query, please see screenshot below for your reference the …Shahid Qureshi 13 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Can i restrict edit access to BI reports to those who creates itSummary: Hi Team, We have a requirement to restrict edit access to BI reports that a certain user has created it. i.e , The one who creates can only be allowed to edit i…
-
Output when using a procedure callHello, I created a procedure call within OTBI. It is a complex PL/SQL that retrieve data from several tables. Each data pushed into a local table of records. All is fine…AA 24 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Need a table for Payment Document Category in Manage Bank account setupSummary: Hi Team, We need a table where the information of "Payment Document Category" meaning stored. There is a column PAYMENT_DOC_CATEGORY in CE_PAYMENT_DOCUMENTS but…
-
Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Summary Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Content Is "EDI Location Code" available for Reporting in Customer Real Time Su… -
Expense Approval Report - how to show stops in between destinationSummary: Content (please ensure you mask any confidential information): Hi all, I have been trying to modify the seeded Expense Approval Report by adding any stops taken… -
[FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: TimeoutSummary: [FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: Timeout waiting for response from server. Content (please ensure yo…
-
How to add Dashboard or OTBI analysis on Navigator or Springboard (Home page)This discussion provides step by step guidance on how to add OTBI analysis or Dashboard or any external webpage to application UI home page or on Navigator as new page e…CA Nirmal Choudhary 1.5K views 2 comments 4 points Most recent by MarkS Reporting and Analytics for ERP -
Need a table or query to get Latest open period column in Manage Intercompany Period StatusSummary: Hi Support, We need a table for the column's "Latest open period" and "Open Transactions" under the setup Manage Intercompany Period Status. We have the table F…
-
how to see when a role was deleted from a user?Summary: how to see when a role was deleted from a user? Content (please ensure you mask any confidential information): how to see when a role was deleted from a user? a…
-
Custom BIP report for Accounts payable trial balanceSummary: I am developing a Custom BIP report for Accounts payable trial balance. Here the paramters are legal entity, as on date and business unit. When I am trying to p…
-
Ad Hoc Smartview ERPWe recently set up a SmartView connection for Oracle Hyperion Financial Reporting, Fusion Edition so our folks can access different FRS reports from smartview. They also…
-
Unable to run any custom FRS report after migrating the report from Test to ProdSummary: We have created almost 20 FRS reports in the TEST environment. After completion of the UAT, we are trying to migrate the report to PROD environment. After migra…
-
Required interface tables for the below tasksSummary: Hiteam, We are unable to find interface tables for the following tasks, we gone through the oracle docs but we could not find the below tasks interface tables. …Opkey PA 21 views 3 comments 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
In Cash Management OTBI, is it possible to get the transactions reconcilied to a statement line?Summary: On the Manual Reconciliation Cash Management page, it is possible to see which system transactions (AP, AR, etc) are reconciled to a given bank statement line. …User_2025-02-11-06-12-35-024 176 views 3 comments 5 points Most recent by John Ban Reporting and Analytics for ERP -
Customizing Receivables Aging by General Ledger Account ReportSummary: We are customizing the receivables aging by general ledger account report to display only the outstanding balances and changing the layout but the code was gene…
-
Download Excel template BIP Report using SOAP Web ServicesSummary: We are currently using the following two web services to schedule and download BIP reports: soapWsdlUrlSchedule: https://{instance-name}.oraclecloud.com/xmlpser… -
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…
-
Excel template with multiple sheets in outputSummary: I require my excel template to push out multiple sheets. One for each business unit with underlying customer transactional data per business unit sheet. Content…Chez 165 views 10 comments 1 point Most recent by Ankur Jain--Oracle Reporting and Analytics for ERP
-
Need the mapping of Job Application Names EarHcmEss and FscmSummary Need the mapping of Job Application Names EarHcmEss and FscmContent We have a requirement to create a custom report of the ESS Job Execution details. We want to …Vinay Gharge 60 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
can BICC join multiple tablesSummary: Hi, Can BICC join multiple tables to populate data. i.e. From XLA table, I would like to link it to RA_CUSTOMER_TRX_ALL? Content (please ensure you mask any con…
-
How to split a single row into multiple rows in oracle fusionDear All, I got an requirement like need to split single row into multiple rows dynamically, but here that single row is having value like 99 so i need to split 99 rows …
-
Intermittent Error with Custom OTBI ReportSummary: We are experiencing issues with one of our custom OTBI reports, which had been functioning perfectly until recently. Users have reported that the report intermi…
-
How can we migrate an EBS Financial Statement Generator (FSG) report in Fusion CloudWe are migrating client system from EBS (R12) to Fusion Cloud. In the EBS environment client has a custom Financial Statement Generator (FSG) report. Client has the requ…
-
how to derive last day of month in OIC mapper to pass as parameterSummary: Hi All, Could someone please help me in deriving Last day of month based on system date? Content (please ensure you mask any confidential information): I have I…VasanthaFusion90 61 views 10 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP