Fusion Financial reporting
Discussion List
-
Link between XLA, FA and supplier detailsSummary: Link between XLA, FA and supplier details Content (please ensure you mask any confidential information): We have a requirement to fetch the XLA accounted DR, CR…
-
Sql to reconcile Receivable Invoices' balances with their applied receiptsSo, I have constructed a sql query to look at Receivables balances using ra_customer_trx_all and ar_payment_schedules_all. I have another query which I tried to summaris…Robert of STAU 1K views 4 comments 0 points Most recent by Robert of STAU Reporting and Analytics for ERP
-
Need Help on Source Table for Manage Common Options for Payables and Procurement:Summary: need to find table for Manage Common Options for Payables and Procurement. want value for default distributions -liability, prepayment Content (please ensure yo…Mayur Gangar 11 views 1 comment 0 points Most recent by Mayur Gangar Reporting and Analytics for ERP
-
Recommended properties/parameters for an image to be used in RTF template of BI PublisherHello Oracle Experts, We are working on with updating the template for PO print to add logo/images. As such, may we know if there are any recommended properties for the …marc.joed.de.guzman 15 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
System Accounts from per_usersSummary How to identify system accounts like FUSION_APPS_SEARCH_APPID from per_usersContent Hi Is there a way to query and get a list of system accounts like FUSION_APPS…Manish Mohan-96908 54 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
How to schedule a custom weekly GL report, which includes date parameter of "PostedDate-7"Summary: Custom GL Report which needs to run at 12:05 AM weekly on Tues night and include data only from the previous week. If PostedDate = Aug 6, the report should incl…
-
Recommended approach for data warehouse extract from Fusion FinancialsSummary: We have implemented Oracle Cloud/Fusion Payables and Procurement modules. We have built custom data models and reports to extract data from Fusion and deliver t…
-
Why does tax_amt_funcl_curr field table zx_lines not match the amount FIELD in INVOICESSummary: Shouldn't tax_amt_funcl_curr field from table zx_lines match the amount in invoice- View accounting match. we are noticing few cents off for philippines tax_amt…
-
Does the purpose of Cloud Collections related columns in AR Payment Schedule align with EBS R12Summary: We have a custom report running in EBS R12 that we are looking to port to erpCloud. The R12 report references columns: AR_PAYMENT_SCHEDULES_ALL.STAGED_DUNNING_L…
-
Missing Republish Button @ ESS Jobs to open outputSummary Missing Republish Button @ ESS Jobs to open outputContent * Should be able to view the output of Jobs run from SOA user as jobs are scheduled from SOA User.For a…Senthilrajan V 117 views 8 comments 1 point Most recent by Grant Abbondanza Reporting and Analytics for ERP
-
Reporting subledger modules to GL with transaction detailSummary: We're looking for a report that provides information from subledgers into the GL in an Excel like format. For example, we need the project number, expenditure t…Kristen Shimkus 41 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Is there a Workforce Management - Position Event Real Time Subject Area?Summary: There is currently a Subject Area for Workforce Management - Position Real Time selectable when creating an Analysis in OTBI. This Subject Area shows the max ef…Gloria Brewster 33 views 4 comments 2 points Most recent by Gloria Brewster Reporting and Analytics for ERP
-
Account Profile Conversion Rate Type field is showing Id instead of Name in OTBI AR reportSummary: Account Profile Conversion Rate Type field is showing Id instead of Name in OTBI AR report, it is showing name only for the seeded value i.e Corporate. P.N - We…Rahul Kumar Gupta.-Oracle 11 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to join fnd_bpm_task_comment to fnd_bpm_task_history_b table?Summary: I am trying to get data from fnd_bpm_task_comment table and joining with fnd_bpm_task_history_b table with Task_id but i am dropping the data which doesn't have…
-
Unable to copy shortcut to MyFolders due to Path not found - Check the input path entered errorSummary: Hi, Got this error when trying to copy/paste shortcut of a folder to MyFolders : I have full ownership of the folder that i'm trying to copy the shortcut : Plea…Shashidhar Goud 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
ORA-00920: invalid relational operator when using Menu parameter with multiple selection enabledSummary: Hi Team, I'm unable to use Menu type parameter in where clause in SQL query in a DataModel when 'Multiple Selection' enabled. Below is the screenshot of the whe…Shashidhar Goud 184 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Account Analysis for Contra Account Standard Report - CustomizationHi , I have copy this standad report to my custom location . Now i want to add two more columns in this report. 1- Transaction Number ( Which is comming from subledger i…Jasir133341 128 views 2 comments 0 points Most recent by Nasir Iqbal Reporting and Analytics for ERP
-
Table to get Task Details from Strategy assigned to customerSummary Table to get Task Details from Strategy assigned to customerContent Hello, We are unable to find the table to get Task Details from Strategy assigned to customer…Vinay Gharge 194 views 2 comments 0 points Most recent by Praveen Gollu-Oracle Reporting and Analytics for ERP
-
'Create Accounting for Assets' Custom ESS Job for Draft Accounting Mode only.Summary: How to create custom 'Create Accounting for Assets' ESS job where Accounting mode parameter must be - Draft only..? Content (please ensure you mask any confiden…Annpurna Swami 138 views 6 comments 0 points Most recent by Hasan Hasan Reporting and Analytics for ERP
-
Unable to generate consolidated output for Create Customer Statement Report.Summary: We have a requirement to customize and enable consolidated output for Create Customer Statement Report. Although we have activated the feature to display consol…
-
Rows repeating with different values though it's not available in the Front end under Customer SiteSummary: Hi, We have developed an OTBI report using Receivables - Customer Real Time and Receivables - Customer Account Site Tax Profile Real Time and it is repeating a …Rahul Kumar Gupta.-Oracle 22 views 2 comments 1 point Most recent by Daniel S.-Oracle Receivables & Collections
-
General Ledger Balances Real Time OTBI not fetching Cost center values from COASummary: I am using General Ledger Balances Real Time Subject Area to extract all COA value set values and i am able to derive all COA values except for Cost center, Onc…TCG 12 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
how to enable incremental value schedule standard report in oracle fusionSummary: how to enable incremental value option while scheduling standard report Report : Payable trial Balance reportMohammed Masoodhu Hashir 26 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Period Name parameterSummary: Hi , I am currently working on report which is filters using period_name. when i select single month(period_name), the data looks promising. when multiple perio…Praveen_Chouhan 88 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Deeplink for AR_TRANSACTION in REVIEW modeSummary: Need to view a transaction detail in Review mode Content (please ensure you mask any confidential information): Hi everyone, I noticed that when I open a comple…
-
Dunning Letter Format in Peppel 3.0 FormatHi, We have new requirement for our client need to send Dunning Letters in Peppel 3.0 Format. Can you please let us know do we have Oracle standard functionality dunning…Koteshwar Tippani 83 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Is there any report to fetch either approved or approved invoices but not bothSummary: I need to know whether report or from front end to fetch the details of invoice status whether approved or not without giving AP inquiry role to all the clients…Sri Pallavi 1 view 1 comment 1 point Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
How can I find AP invoices Approvals by user and approval group details in Fusion cloud?Summary: To identify the Invoice is approved user or approval group and which Rules hitting by the BPM Content (please ensure you mask any confidential information): To …Harish Pati 415 views 2 comments 0 points Most recent by Harshali Shirgannavar-Support-Oracle Payables, Payments & Cash Management
-
BIP Local Solutions reports do not print Natural Account descriptions in selected local languageSummary: Predefined Latin America Local Cloud Solution (LALCS) BIP reports do not print Natural Account Descriptions in translated language - Spanish. Content (please en…NancyR_Bravo 3 views 2 comments 0 points Most recent by NancyR_Bravo Reporting and Analytics for ERP
-
Migration of FRS reports from one server to anotherSummary: Hello, I want to migrate my FRS reports from test to production server. After archieve and unarchieve, I changed my database connection as well but it didn't wo…Ayub 18 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany