Reporting
Discussion List
-
Accrual Rate for Foreign CurrencyActual when we are generating the month end accrual on the system we noted that for the Foreign Currency system is taking the rate at PO Creation Date instead of GRN Cre… -
Query to find the approver name for AP invoicesWhat is the query or table name where we can find the approver name and approval date(action date) for an AP invoice. The table ap_inv_aprvl_hist_all gives the approver …KanikaMahajan 266 views 1 comment 1 point Most recent by User_20PH8 Payables, Payments & Cash Management -
Oracle Payables 1099 process does not support State ReportingSummary: Set up automatic without is showing up in box 4 (Federal income tax withheld). Need the withheld amount to go to box 16 (State tax)1099 - State Tax Withheld (Do…Kritika Narula 15 views 0 comments 0 points Started by Kritika Narula Payables, Payments & Cash Management
-
Customizing the Payables Workflow Transactions Listing seeded reportSummary: Business needed few more column for the seeded report, But we do not have access to Data model.Suggestions needed in order to get this done. Content (required):…NarenInova 1 view 4 comments 0 points Most recent by Raunak Kumar Singh Payables, Payments & Cash Management
-
Payables Trial Balance OTBISummary: Payables Trial Balance OTBI Content (required): How to create Payables Trial Balance from OTBI? How do I get the as at date? How do I get the Original Amount an…CraigX 9 views 1 comment 0 points Most recent by Nagaraju-Oracle Payables, Payments & Cash Management
-
Possible to use one 1099 for multiple Business Units?Summary: I am creating Reporting Entities and want to use 1 reporting entity (create one 1099) for 4 separate invoice BUs. Content (required): Is it possible to create o…
-
Scheduling Create Accounting - accessing the report outputSummary: Business users unable to access the reports from the scheduled the create account jobs Content (required): Out IT department is scheduling the jobs using an adm…Lisa Poore 22 views 2 comments 0 points Most recent by Lisa Poore Payables, Payments & Cash Management -
supplier balance aging report logicSummary: the supplier balance aging report shows the cancelled invoices as unpaid whats the logic of this when we match with the trial balance it will notmatch because t…Umer272 13 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management -
OTBI Payment reportDeal all : I have a payment report when I log in it from the catalog and search for it an open it there's a criteria Payment date that appear But this same report if i s…mickel rmeily 11 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
1099 reporting for year 2022Summary: 1099 reporting seems to be receiving yearly patch from Oracle, is there any place where schedule for this type of patches is published yearly Content (required)…Roman Havrylyak 59 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Which table can I use to know the approval status of the payments?Which table can I use to know the approval status of the payments in oracle fusion? Client has a requirement to build a custom report to view the unapproved wire payment…KanikaMahajan 11 views 2 comments 1 point Most recent by SimonTomey 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. 31 views 11 comments 0 points Most recent by Bhavik Shah Payables, Payments & Cash Management
-
Query Related to Legal Entity on Invoice HeaderSummary: Hi - Just to understand, i have below Qs: 1) what does the LE's significance on invoice header? Does the LE on invoice header has any transactional/Accounting i… -
AP invoice calculating withholding in functional currency. Is there a way we can change it.Summary: Our functional currency is USD. We have lot of invoices that are in another currency, anytime those invoices are created, their withholding and VAT invoices are…David Sakeye 1 view 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Prepayment report by Supplier As of dateSummary: Requirement of Audit for Prepayment report as of supplier wise with as of date no standard report or any way? Content (required): Payables Version (include the …
-
Auto Increment in Transfer Costs to Cost ManagementSummary: Content (required): Hi, I have scheduled "Transfer Costs to Cost Management" ESS job every 10 minutes and have enable the Auto-Increment option. Can someone exp…Sheneli Fernando 1 view 4 comments 0 points Most recent by Sheneli Fernando Payables, Payments & Cash Management
-
understanding the setups and how to generate 1099 reportsSummary: i wanted to generate 1099 report and wanted to know what all configuration is required to generate 1099 Content (required): wanted to generate 1099 Version (inc…Manoj1234 1 view 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Custom Remittance Advice Template not appearing in Manage formatsSeparate Remittance advice do not have a data model. I have created a custom template that in BI publisher in custom folder custom>financials>payments, but my custom tem…KanikaMahajan 1 view 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Ledger Amount Field in the Payment in Case of Foreign PaymentSummary: Needs to know the table and the field holding the payment ledger amount. Content (required): We have a requirement to fetch the information for the Ledger Amoun…Ahmed Maher K. 11 views 3 comments 0 points Most recent by Ahmed Maher K. Payables, Payments & Cash Management -
understanding the setups and how to generate 1099 reportsSummary: i wanted to generate 1099 report and wanted to know what all configuration is required to generate 1099 Content (required): wanted to generate 1099 Version (inc…
-
Does Invoice Imaging support Payable Invoice coming in Chinese Language?Summary Does Invoice Imaging support Payable Invoice coming in Chinese Language?Content Does Invoice Imaging support Payable Invoice coming in Chinese Language? Apprecia…Sam Samaddar 13 views 4 comments 1 point Most recent by Raj Bhakta Payables, Payments & Cash Management
-
invoice attachments downloadingDear All Whenever we are checking an invoice and we want to see the attachment of that invoice once we click on it the system will automatically download it. Is there a …mickel rmeily 1 view 1 comment 0 points Most recent by David Mckenna Payables, Payments & Cash Management
-
Payable invoice from PO requester nameDear All I am trying to create an invoice out of an approved Po but I am facing an issue that the Requester name isn't provided automatically in the Header I have to tak…mickel rmeily 1 view 8 comments 0 points Most recent by mickel rmeily Payables, Payments & Cash Management
-
invoice attachments downloadingDear All Whenever we are checking an invoice and we want to see the attachment of that invoice once we click on it the system will automatically download it. Is there a …mickel rmeily 1 view 4 comments 0 points Most recent by mickel rmeily Payables, Payments & Cash Management
-
Can Last_update_date be taken as the date when invoice hold was released in AP_HOLDS_ALL?Which table and column will give the details of the invoice hold release date and invoice released by name ? Release 22BKanikaMahajan 11 views 1 comment 0 points Most recent by Hari Sanka-Oracle Payables, Payments & Cash Management
-
Payables Invoice Audit by Voucher Number ListingWhich role is required to run "Payables Invoice Audit by voucher number listing report" in oracle cloud in scheduled processes?Kanika Mahajan 1 view 0 comments 1 point Started by Kanika Mahajan Payables, Payments & Cash Management
-
Accounts Payable Trial Balance Report - no detailsSummary: Why do I only see a summarized amount, when running Accounts Payable Trial Balance Report? How do I get details per supplier? Content (required): Version (inclu…Bo Tøpgaard 1 view 2 comments 1 point Most recent by Bo Tøpgaard Payables, Payments & Cash Management
-
Single 1099 in Legal Entity for multiple suppliers with same taxpayer idSummary: Looking for a workaround in 1099 process on how to create a single 1099 for multiple suppliers with same taxpayer id within a legal entity. At one time this was…MaryD-User341433 2 views 2 comments 0 points Most recent by MaryD-User341433 Payables, Payments & Cash Management -
Remittance Advice for Manual PaymentsHey, Separate Remittance Advice ESS process do gets triggered when we run a payment through Submit Payment Process Request and can also be manually triggered by selectin…Kanika Mahajan 11 views 1 comment 0 points Most recent by Kanika Mahajan Payables, Payments & Cash Management
-
Did 22A remove the Republish CSV export option - don't see it for the Supplier Balance report.Summary: Did 22A remove the Republish CSV export option - don't see it for the Supplier Balance report. Content (required): Did 22A remove the Republish CSV export optio…Phil Nibert 1 view 3 comments 0 points Most recent by Phil Nibert Payables, Payments & Cash Management