Reporting
Discussion List
-
Payment template informationSummary: Looking for a SQL query that will give me all the information selected on our payment templates rather than returning 'Specify' or 'All' ie indicating which pay…Clare Farris 21 views 3 comments 0 points Most recent by Louis_Fayard Payables, Payments & Cash Management -
Query to fetch Approvals Groups Across Workflow ModulesSummary: We need to update a workflow approval group. I’d like a query that shows, by module, every workflow rule that will be affected by this change. Exemple: Approval…usr_a.nv 38 views 6 comments 0 points Most recent by Kate D.B-Oracle Payables, Payments & Cash Management
-
Could you please share any OTBI AP Dashboard ?Summary: Could you please share any OTBI AP Dashboard ? Content (please ensure you mask any confidential information): Hello Could you please share with me any seeded OT…martingabriel Kinovisques 12 views 1 comment 0 points Most recent by RVohra Payables, Payments & Cash Management
-
How to join CE_STATEMENT_LINES, CE_RECON_HISTORY, CE_RECON_HISTORY_ITEMS, AP_CHECK_ALLWe are building a BI publisher report to list Bank Statement Number, Bank Statement Line, Statement Line Amount, AP Payment Number Using the tables CE_STATEMENT_HEADERS …Pradeep Kumar Reddy V 54 views 3 comments 0 points Most recent by luke.syv8 Payables, Payments & Cash Management
-
ACTION REQUIRED notification still appears on the bell icon of the approver for weeksThe approver has approved the approval notification and the invoice is now pending with other approver in the workflow. The Action required notification still appears on…KanikaGupta 273 views 7 comments 0 points Most recent by Mehak Soni Payables, Payments & Cash Management
-
1099k reportingSummary: As there is a requirement for suppliers to generate the 1099-K form, is it possible to handle 1099-K reporting within Oracle Fusion? If so, how can this be achi…Dhruba 40 views 3 comments 0 points Most recent by SherameAnderson Payables, Payments & Cash Management
-
FOS Source Intercompany AP invoice is not same as the converted AR invoice number due to Doc sequThe FOS source transaction when sent In Receivables to create invoices, the FOS Intercompany AR invoice number is getting converted to a new Txn number based on the docu…Sudhanshu Rai 32 views 1 comment 2 points Most recent by Abhinav Garud Payables, Payments & Cash Management
-
Is there a way to exclude certain conversion transactions from showing up CashtoGLRecon report?There are Conversion invoices from April 2022, that are automatically getting reconciled with current period transactions, and when unreconciled they show up in the Cash…Ameen Shoaib 11 views 0 comments 0 points Started by Ameen Shoaib Payables, Payments & Cash Management
-
Create Tree nodes using global DFFSummary: I am planning to use global DFF field manage values as Tree node values on a custom Tree hierarchy. I have downloaded DFF Flex field archive to get the business…
-
Is there any report for Remittance Advice Delivery Email ID by supplier siteSummary: Report for remittance advice delivery email ID by BU Content (please ensure you mask any confidential information): Hi Team We required to update and add more e…JL-JL 100 views 5 comments 0 points Most recent by Emily Downum Payables, Payments & Cash Management
-
Validate Payables Invoices process to exclude manual invoicesHi Team, One of our customers requesting to exclude manual and IDR invoices from validation through Validate Payables Invoices process. Could you please confirm whether …Chanikya Neelam-Oracle 24 views 2 comments 0 points Most recent by Chanikya Neelam-Oracle Payables, Payments & Cash Management
-
Generate Audit ReportSummary: We have this pre defined report in Scheduled ESS jobs. What is the role required to access this report and which team can access this report or who can access t…A Harshith 21 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
OTBI Report for Current Invoice ApproverSummary: I am trying to build an OTBI report that shows invoices that are pending approval along with the name of the current approver. For the most part, I have been ab…Neal Foley 604 views 11 comments 0 points Most recent by Manisha Sujal Puria Payables, Payments & Cash Management
-
How to identify the logic of the fields GC_BANK_TYPE and GC_CONVERSION_TYPE?Summary: Which is the logic of the fields GC_BANK_TYPE and GC_CONVERSION_TYPE on for the Cash to GL Reconciliation Report? Content (please ensure you mask any confidenti…Maricela Diaconita 17 views 3 comments 0 points Most recent by Antony N123 Payables, Payments & Cash Management
-
Custom Payables Invoice Aging Report did not copy the parameterSummary: copy of the Payables Invoice Aging Report did not copy the parameter Content (please ensure you mask any confidential information): Version (include the version…ERP User 11 views 1 comment 0 points Most recent by HD - Oracle Fusion ERP-Oracle Payables, Payments & Cash Management
-
Can we add "PO Number" column to the manage invoices search result?Summary: Search Invoices in Manage Invoice After searching for the invoice number, can we also see/add the PO number column? Content (please ensure you mask any confiden… -
In supplier bank account ...how to bulk upload bank detailsSummary: 1.How can we find the fields values in front end from where the data is capturing from for the the table iby_ext_bank_accounts_v,ce_bank_branches_v,/How to map …soubhagya 24 views 4 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management
-
how to get historical all changes to invoice payablesI would like to ask whether all minor changes made to an Accounts Payable invoice can be tracked specifically, who made the change and what was modified. Is there a way …Andika Kurniawan 21 views 1 comment 0 points Most recent by JimCC Payables, Payments & Cash Management
-
List of Import Payables Invoices Report Rejection MessagesSummary: Is there a document or a listing that provides the list of rejection messages when interfacing invoices? Content (please ensure you mask any confidential inform…Christian Roxas - PWC 6 views 0 comments 0 points Started by Christian Roxas - PWC Payables, Payments & Cash Management
-
Supplier Balance Aging ReportSummary: Needs to understand the current logic of this "Supplier Balance Aging Report Content (required): Needs your help to understand the standard report level - 1. Wh…Thangavel Senthil 147 views 2 comments 1 point Most recent by Shashidhar AM Payables, Payments & Cash Management
-
Suppliers are not receiving Remittance AdvisesSummary: For some reason, none of our suppliers are receiving any Remittance Advises. The configuration on disbursements options, Payment process profiles, and supplier …Murali M. 509 views 17 comments 0 points Most recent by Thriveni Gudipati Payables, Payments & Cash Management
-
Check print using Dot Matrix printer on Oracle FusionSummary: Unable to print a check on a Dot Matrix printer. Content (please ensure you mask any confidential information): We are attempting to print a preprinted bank che…Dinesh_Mani 36 views 1 comment 1 point Most recent by SankarBalu Payables, Payments & Cash Management
-
Is there a report where AP Payment approver can drilldown to InvoicesAP PPR approver cannot drilldown to AP invoice from notification. This seems standard functionality Has anyone found a report where drilldown functionality exists to acc…SarahL 14 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management -
Does Audit Trail ability available in Cash Management for transactional activities.Hi Audit Trail Feature capability required in Cash Management for all kinds of Business Transactions that user will perform in Cash Management. Do we have this feature, …Baskara Sateesh-Oracle 26 views 3 comments 0 points Most recent by Amey Payables, Payments & Cash Management
-
Conversion Rate, Rate Type, and Rate Date to NULL when converting from a currency to itselfSummary: Is it Oracle's expected behavior to set the Conversion Rate, Rate Type, and Rate Date to NULL when converting from a currency to itself (e.g., CAD to CAD) with …mario.santiago 12 views 1 comment 0 points Most recent by Madhavi.Godbole Payables, Payments & Cash Management
-
How is the Legal Entity (LE) field determined and populated in the AP interface table for IDR.Summary:Hi Team , How is the Legal Entity (LE) field determined and populated in the AP interface table/AP_INVOICES_INTERFACE specifically for invoices with the source '…Najeeb_ACN 287 views 5 comments 0 points Most recent by Avinash Singh Payables, Payments & Cash Management
-
how to enable bursting at ESS job level for Invoice Document recognition Tracking Report in payablesWe have added the bursting definition in Data Model. And, enabled bursting at report level, But not able to edit at ESS job level to enable the bursting.Rama Krishna T 26 views 0 comments 0 points Started by Rama Krishna T Payables, Payments & Cash Management
-
Method of valuation of the outflow of own funds from foreign currency accounts–FIFO Basis in PolandHi All , We need to know at the available revaluation methods and how the foreign currency outflows work in Oracle fusion using FIFO basis foreign currency transactions …Satya Prasad Chamana 57 views 1 comment 1 point Most recent by Global Customer Support | ASE-Oracle Subledger Accounting & Accounting Hub
-
Prepare Payable to general ledger reconcilation subprocss errorSummary: I scheduled the "Prepare Payables to General Ledger Reconciliation" ESS job to run for one month. However, the "Payables to General Ledger Reconciliation" repor…NarasimhaPalla 55 views 5 comments 0 points Most recent by Sukii Payables, Payments & Cash Management
-
Cannot drilldown to Invoice UI from Payment approval notificationThere is no hyperlink to drilldown to Payables invoice from PPR notification for the approver. Is there a way to enable this? Or is there a report that can be run that h…SarahL 15 views 1 comment 0 points Most recent by HD - Oracle Fusion ERP-Oracle Payables, Payments & Cash Management