Reports
Discussion List
-
Table to get the field of Condiion under Manage Chart of Accounts MappingsSummary: We need a table and column where the Condition field information stored for the setup "Manage Chart of Accounts Mappings". Attached the screenshot with highlite… -
what is the previlege for Workflow Transactions ListingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PUGALESWARAN PALANIVEL 10 views 2 comments 0 points Most recent by PUGALESWARAN PALANIVEL Reporting and Analytics for ERP
-
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…
-
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…
-
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 22 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 173 views 3 comments 5 points Most recent by John Ban Reporting and Analytics for ERP -
Need a report with employee's default expense account and position informationSummary: I need a report with the employee's default expense account and position information so I can verify the account is correct. Is there a trick to connecting the …Cindi Jacobsen 5 views 2 comments 0 points Most recent by Cindi Jacobsen Reporting and Analytics for ERP
-
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… -
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 164 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
-
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.5K views 35 comments 8 points Most recent by alexey.shtrakhov 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…
-
Percentage formula doesn't work for expandable columns.In the "Financial Reporting Center" section by opening the "Workspace for Financial Reports" several reports have been configured. I have an issue... In column A (as an …Michele Ferro-Oracle 1 view 0 comments 0 points Started by Michele Ferro-Oracle Reporting and Analytics for ERP -
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 52 views 10 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
FLA_ON_DEMAND_SCHEDULES_PKG not generating future period schedules after 25aHi, We had developed 5 Custom lease reports (Lease schedule details report same as the one attached in Lease Accounting schedule tab once lease is finalized) by using FL…
-
Employee Expense AttachmentI need to get the attachment from the header in the Expense Report. I am only getting the attachments from the Expense Items. Am I missing a table or join on this? here'…
-
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…
-
How can we use multiple account hierarchies for a single segment in a FRS report?Hi Team, Our client is looking to create another hierarchy for Primary balancing segment which would be date effective from 1st of Jan 2025. They want to keep using the … -
How to see the list of ESS Jobs scheduledHello All, we had a requirement to get the list of ess jobs scheduled and what frequency they have been and what is the current status of that ESS Job. for BIP Report we…Koteswararao Yenikepalli 638 views 8 comments 1 point Most recent by Ranju kumari Reporting and Analytics for ERP -
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 23 views 3 comments 1 point Most recent by Maricel Ortega Receivables & Collections
-
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…SireeshaJaladi 854 views 16 comments 1 point Most recent by Sai Divya Kolachana Reporting and Analytics for ERP
-
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