Reporting
Discussion List
-
"Withholding Tax File to Tax Authority for Israel" report does not captured all paymentsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Escheatment Cash in Transit ReportSummary: When a payment is put in Escheatment Initiated status, the payment is removed from Cash Management and no longer eligible for reconciling with bank transactions…Neal Foley 52 views 8 comments 0 points Most recent by Meghana Gaddam-Oracle Payables, Payments & Cash Management
-
Need SQL Query/ Table names for getting Database Resource object-ActionSummary: Need to understand the details of Actions/ Privilages selected on Data Access Security Policy for Database Resource "Business Unit" and how to define own set of…rahul.gupta.scm 41 views 3 comments 0 points Most recent by Jun Ye-Support-Oracle Applications Security -
How can we generate a 1099-DIV out of Oracle AP?Summary: The client manages dividend payments from their current AP system. The dividend payments are based on setting up stockholders as suppliers and the dividends are… -
FRS/FRC report formula not working for the sum/total of cost and revenueSummary: We are trying to sum the Total Transportation Costs, Total Agent Fees & Commissions, Total Depreciation & Amortization, Total General & Admin to TOTAL COST & EX…Ayush Baiswara 21 views 1 comment 0 points Most recent by Ayush Baiswara General Ledger & Intercompany -
Default Invoice Accounting Date Today (Date processed)Hello, We have a business requirement in which all invoices should be posted to the GL with an 'Accounting Date' of when it was processed (Today's date). There doesn't s…BH_10211993 111 views 3 comments 0 points Most recent by User_L567Q Subledger Accounting & Accounting Hub
-
Error on Payables Payment Register Data ModelSummary: Error on Payables Payment Register Data Model Content (please ensure you mask any confidential information): We have customized the seeded report/data model for…
-
Need to create a Job set with Send Separate Remittance as one of the stepSummary: We are creating a job set with Retrieve Disbursement Acknowledgment and Send Separate Remittance as 2 stages serially. We cannot see Send Separate remittance Jo…Nitesh Gupta. 21 views 3 comments 0 points Most recent by Nitesh Gupta. Payables, Payments & Cash Management
-
Payment Process Request Status Report: Supplier Bank Account not populatedSummary: Hi, In the Seeded Payment Process Request Status Report , Supplier Bank Account is not populated although the supplier bank account is present on the invoice in…Shashank Shekhar 1 view 3 comments 0 points Most recent by AvinashRN Payables, Payments & Cash Management
-
Send separate Remittance Advice Job Schedule in Oracle fusionDear Team, Our business requirement is for example I have create the Payment today but Automatically send separate remittance advice to go supplier after 4 days mail . N…manoj.kumar4 92 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Linking ce_statement_lines and ap_checks_allSummary: Hi all, I can't find a way to link the tables: ce_statement_lines and ap_checks_all. Is there any intermediate table to link these? Or any way to link bank stat…Sheik Shameem 61 views 4 comments 0 points Most recent by Sheik Shameem Payables, Payments & Cash Management -
TDS Invoice IssueSummary: TDS Invoice While TDS invoices are automatically validated by the scheduled Validated Payables Invoice Job, the invoice group is not being updated automatically…Prasanna002 11 views 4 comments 0 points Most recent by Prasanna002 Payables, Payments & Cash Management
-
Cash Forecast: Smartview not showing AP Invoices & Overdue AP InvoicesSummary Different information between UI and SmartviewContent Hi, I'm investigating the use of Cash Forecasting within Cash Management. I found the 5 day forecast which … -
How we can hide the track and resource level information from check funds result?While creating the Project based Requisition. Business requirement to hide Track level and Resource level funds check lines from the Funds check result if we will switch…
-
SQL query to retrieve the canceled invoices amount as per the date for AP aging report.((select sum(aia1.CANCELLED_AMOUNT) from ap_invoices_all aia1 where 1=1 and aia1.APPROVAL_STATUS = 'CANCELLED' and aia1.invoice_id = aia.invoice_id AND :as_of_date < aia…Vikas V. Kamat 492 views 4 comments 0 points Most recent by Vikas V. Kamat Payables, Payments & Cash Management
-
What is subject area and column that store AP Invoice Account Coding approval historySummary: Hi Team, We have built OTBI Report to get AP invoice details, but unable to find subject area and column which stores AP Invoice Account Coding approval history… -
Download all attach bills from review transaction pageSummary: Standard report or job to download all attach bills by customer by period of time Content (please ensure you mask any confidential information): Hi fellows, Is …Yunery N 1 view 1 comment 0 points Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management
-
Discrepancy Between Supplier Balance Aging Report and Payables Invoice Aging ReportWe have run two seeded AP reports – the Supplier Balance Aging Report and the Payables Invoice Aging Report, but the data in these reports is inconsistent. Could anyone …Akhil Chawan 31 views 1 comment 0 points Most recent by Vivek Mandowara-Oracle Payables, Payments & Cash Management
-
Party name/ Vendor name not updated in Account analysis report incase of multi period invoicesSummary: Party name/ Vendor name is not updating in Account analysis report incase of multi period invoices where expenses are booked only monthly basis when "create mul…Edgar Nieto-Oracle 11 views 0 comments 0 points Started by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
How to identify all processes/process IDs involved in completion of scheduled PPR using templateSummary How can operations identify all of the various steps involved for a particular scheduled PPR using a templateContent We are looking to have over 100 PPR Template…
-
How will Oracle support ISO20022 - Nov 2025 for storing addresses for Payments?Summary: ISO20022 will become effective Nov 2025 and will impact payments - we will need the city and country for every payment we make. Because we do not currently have…Antonio LH 21 views 5 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Validation of count of records in Payables Trial Balance Report for audit purposeSummary: After downloading the seeded Payables Trial Balance Report for a specific Ledger and Business Unit, the internal auditors (as part of Completeness Testing) have…Arindam_Sarkar 11 views 2 comments 0 points Most recent by Arindam_Sarkar Payables, Payments & Cash Management
-
Supplier Legal name change after few months in production and with existing open transactionsSummary Supplier Legal name change after few months in production and with existing open transactionsContent What is the best practice to handle the situation in Cloud i…Sam Samaddar 62 views 8 comments 0 points Most recent by Adman1234 Payables, Payments & Cash Management
-
Report to find invoices not yet picked by Create Mass AdditionsSummary: Is there any seeded report available that can be used to pull all AP invoices which are supposed to synch to Fixed Asset module but not yet picked up by Create …
-
We need the username, who has validated the invoice and when its got validated the AP Invoice.Summary: We need the username, who has validated the invoice and when its got validated the AP Invoice. Please share the table details, where validation details stored. …Banerjee Subham 31 views 4 comments 0 points Most recent by Ed Okamoto Payables, Payments & Cash Management
-
Invoice Lines DFFSummary: Invoice Lines DFF Content (please ensure you mask any confidential information): Can invoice lines DFF that are displayed under "Details" be shown on the invoic…
-
Unreconciled cash management at a point in timeSummary: I have a client that wants to be able to report on their unreconciled items at a point in time. I've tried using the cash to GL reconciliation report at a point…Maria Smith- de Novo Solutions 12 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Which Table holds Accounting Conversion Date for External Transactions in Cash ManagementSummary: Hello, I am building a report, and I need to extract this Accounting "Conversion Date" column highlighted in yellow below. These are for External Transactions w…Alexander Wan 31 views 2 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to connect Oracle Payables to Oracle Smart view?Is there a guide on how to connect Oracle Payables reports to Oracle Smart View for Office? We have conducted some tests, but we were unable to connect the Payables repo…elenildo 11 views 1 comment 0 points Most recent by Daniela Petria-Oracle Payables, Payments & Cash Management