Reporting
Discussion List
-
Table details to get Business unit for a tax code definedSummary: We need table or query to fetch business unit name for the given tax rate code. Content (required): Version (include the version you are using, if applicable): …Nishanth B Jain 139 views 4 comments 0 points Most recent by Nishanth B Jain Payables, Payments & Cash Management -
Report to Identify all Team Members who have Coded in APSummary: We are trying to free up licensure in ERP and need to remove people who are not a part of AP or no longer coding invoices for thier departments. Is there a way …THawkins_LGI 1 view 1 comment 0 points Most recent by Kate D.B-Oracle Payables, Payments & Cash Management -
Is there a report I can run in Oracle that can tell me who is submitting invoices/wiresSummary: Is there a report I can run in Oracle that can tell me who is submitting invoices/wires? Content (please ensure you mask any confidential information): Version …Pablo Schenquerman 1 view 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Load and Import Bank Statement Warning messageSummary: Hi Team, We are loading the bank statement using SOAP Services to run the "Load and Import Bank Statement" process. We are using a BI report to fetch the error …Rajeev Nayan 14 views 3 comments 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Is it possible that Accounting date as Last approval date instead of invoice date?Summary: Accounting date will be the last approval date can we achieve this requirement? what is the implications? Content (please ensure you mask any confidential infor…Eswarvoona-Oracle 1 view 2 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
OTBI report - display "in progress" payments process requestsSummary OTBI report - display "in progress" payments process requestsContent Hi, I'm trying to create an OTBI report that shows invoices relating to a payment process re…
-
Unable to track the changes made in BPM rules through audit reports when migrated from SOA composerSummary: We are trying to track the changes made in BPM rules. We are able to get the details in audit report when we are updating the rules manually but when the change…Surendra Rodge 11 views 1 comment 0 points Most recent by Cosmin Nadolu-Oracle Payables, Payments & Cash Management
-
What Disbursement Payment file format can we use for Canadian Payments Association Format - 005?Summary: Which of the available seeded payment file formats in Oracle Cloud can we use if the format required by our client's bank is in CPA-005 format? Content (please …Christian Roxas 6 views 1 comment 1 point Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management -
AP Hold Report that includes Invoice information plus PO numbers, PO line numbersSummary: We need an AP Hold Report that includes PO numbers, PO line numbers, invoice details, and quantity comparisons to identify invoices on hold due to "Billed quant…SBJ_PPM_1210 14 views 2 comments 0 points Most recent by SBJ_PPM_1210 Payables, Payments & Cash Management -
Client request to provide report/job information on recent releases for financialsSummary: Client request to provide report/job information on recent releases for financials, is there way to check Content (please ensure you mask any confidential infor…
-
How to include attribute defined in Manage Legal Entity in Separate Remittance Advice Report.Summary: We are creating a custom template for Separate Remittance Advice Report. I want to include attribute defined in Manage Legal Entity in Separate Remittance Advic…Binod Kumar 61 views 2 comments 1 point Most recent by User_L4A7A Payables, Payments & Cash Management
-
Intercompany invoice between two entities in same ledgerSummary: We've a specific scenario related to India GST. Two entities - 323 /801 falls under same India Ledger. Supplier Invoice created with 323 with GST calculation. T…
-
For a particular Business Unit we want 2 different sets of email body on AR Invoice Print ReportSummary: We have a requirement where for a particular Business Unit , we want to have two different sets of email body for Invoice Print Report. Invoices which will be s…
-
PO -AP - Payment ReportAre there any reports similar to the PO Life Cycle that provide a comprehensive view of PR, PO, and RR details along with invoices in a single report?Anne Nicole 1 view 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Advanced Duplicate check for Invoices - InSupplier Source Invoice QueryAre InSupplier Invoices considered as UI created invoices or Invoices imported? Mainly Im trying to figure out if the system displays a warning message to Supplier if th…Kiel DSilva 24 views 4 comments 0 points Most recent by Sandeep Nayak-Oracle Payables, Payments & Cash Management
-
IDR : Privilege to run # Invoice Documents Recognition Rate & Invoice Documents Recognition TrackingSummary: Which privilege controls these two, Invoice Documents Recognition Rate & Invoice Documents Recognition Tracking reports access in Scheduled Job Content (require…Soumya Prakash Parhi 340 views 14 comments 0 points Most recent by surya236 Payables, Payments & Cash Management -
Manage Value SetSummary: Manage Value Set Content (please ensure you mask any confidential information): Hello Folks, We have created an DFF and we have requirement to show values in 03…Muhammad_Saad 21 views 1 comment 0 points Most recent by Daniela Petria-Oracle Payables, Payments & Cash Management
-
Can we create custom reports for IDR recognition report?Summary: The seeded report contains merged fields which prevents us from sorting and gathering data which would allow us to target suppliers that have a lower recognitio…Lisa Poore 55 views 2 comments 0 points Most recent by Adam Fine Payables, Payments & Cash Management -
How to fill in the XML for Spanish VAT SII reporting when non-deductible taxes?Summary: We are trying to declare both using the same process as usual, but the system processes everything as recoverable. We have looked at the table JE_ZZ_VAT_REP_TRX… -
How to enable the CFO dashboardSummary: Can someone please let us know how to enable the CFO dashboard which is available in the demo / vision instance? Could not find any material on the same. Conten…vlKrishna 22 views 2 comments 0 points Most recent by vlKrishna Payables, Payments & Cash Management -
How to setup Pay Through Days and Payment Date in Payment Process Request Template exclude holidaySummary How to setup Pay Through Days and Payment Date in Payment Process Request Template exclude holidayContent When we schedule PPR template, the system does not skip…Kumar 57 1.3K views 5 comments 3 points Most recent by Roger Rinco Payables, Payments & Cash Management -
Is there a way to default Intra - EU Declared Key at Invoice Header Level ?We want to avoid having to input these 2 fields at invoice header level every time we book an invoice.
-
How to extract payable invoice report based on invoice attachment languageSummary: We need to analyze the invoice count based on supplier PDF/attachment language. (Text in invoice and supporting documents) Checked FND_DOCUMENTS_TL table but th…PavaniR 11 views 3 comments 0 points Most recent by Priyanka Gunasekaran-Oracle Payables, Payments & Cash Management
-
How to unhide the columns on the audit screen selectionSummary: We are running the audit report and would like to display / unhide the hidden columns. Content (please ensure you mask any confidential information): We are run…Ileana 42 views 3 comments 0 points Most recent by Balram Katre-Oracle Payables, Payments & Cash Management
-
Clarity around using stop initiated and impacts to positive pay filesSummary: How does initiating a Stop on a payment impact positive pay file? Content (please ensure you mask any confidential information): We are scheduling a Create Posi…AllenN 1 view 1 comment 0 points Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management
-
Reporting Options - Multiperiod AccountingSummary report that shows invoices that are being processed through multiperiod accounting and their remaining balances?Content We are trying to figure out what invoices…Wendy Ware 473 views 14 comments 1 point Most recent by Omar Hamdy Payables, Payments & Cash Management -
Is there a way to download the list of features/Tasks Enabled in payables for a specific customerSummary: Below is the requirement from the customer, is it possible to download into the Excel sheet. Could you provide me with a list of features available in the Accou…Baskara Sateesh-Oracle 21 views 1 comment 0 points Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management
-
add a description or note,to line level detail,while editing distribution from approval notificationSummary: Hi Team, we have a requirement from client that they want line level description to be added when editing distributions from approval notification, but currentl…Srishti Vasdani 21 views 1 comment 0 points Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management
-
How to handle loans Tracking in FusionSummary: Hi Experts Can any one advise how to handle Loans & Tracking Loans in Fusion Please advise Solution or Work around solution Scenario:- Company has taken Loan fr…Satya Mothe 253 views 5 comments 1 point Most recent by Nitesh Gupta. Payables, Payments & Cash Management
-
Why are there no journal lines appearing in the cash report?Summary: When I review the manual reconciliation there are two pending lines, made in a manual journal, but they are not in the cash reconciliation report. I use the sam…Patricia Vargas 1 view 2 comments 0 points Most recent by Patricia Vargas Payables, Payments & Cash Management