Reporting
Discussion List
-
Can my WHT be calculated from supplier profile instead of site?Summary: There is a client requirement for WHT to be calculated on the basis of rate mentioned in supplier profile and not on supplier site. I tried everything but could…Miti Shah 21 views 2 comments 0 points Most recent by Miti Shah Payables, Payments & Cash Management -
For the Payables Audit Report, is there a way to display invoice number or ID in report?Summary: We have turned on auditing for Payables Invoice Installments to audit the First Discount Due Date field. The Payables Audit Report does show Object Type = Invoi…Dawn Tilson 21 views 2 comments 1 point Most recent by Dawn Tilson Payables, Payments & Cash Management
-
Table details to get Additional Information for Payment MethodsSummary: Which table stores these information for Payment Method Task for Payables. Content (required): Version (include the version you are using, if applicable): Code …Nishanth B Jain 62 views 7 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management -
Can WHT invoice payment get voided automatically, if the parent invoice payment did?Summary: In one of our clients' case, we have configured WHT invoice creation on payment and calculation on invoice. If we want to void the payment to that invoice, we w…Miti Shah 41 views 2 comments 0 points Most recent by Miti Shah Payables, Payments & Cash Management
-
Table details which holds Enable invoice account coding workflow flagSummary: Table details which holds Enable invoice account coding workflow flag in Manage Invoice Option task Content (required): Version (include the version you are usi…Nishanth B Jain 58 views 2 comments 0 points Most recent by Nishanth B Jain Payables, Payments & Cash Management
-
1099 Reporting for BU with multiple supplier sitesSummary: We have multiple suppliers who have 2 or more sites per business unit. Only 1 site requires 1099 reporting. Is there a way to automatically remove the Income Ta…
-
Payables Invoice and Supplier Balance Aging reports complete in ErrorSummary: Content (required): Hi, We have created a custom role to run AP related reports. It includes the below privileges and duty roles; Privileges Submit Payables Inv…Sheneli98 32 views 4 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
Calendar year is not populated in 1099 ReportSummary: Calendar year is not populated in 1099 report output Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code …Surya01 61 views 4 comments 1 point Most recent by Jeff Rich-Terillium Payables, Payments & Cash Management -
Ability to change Period dates and distribution strings after started MPASummary: Ability to change Period dates and distribution strings after started MPA Content (required): We need to know if we can modify or edit the MPA components of an …Cesar Saveedra 41 views 4 comments 0 points Most recent by Nirav Vekaria Payables, Payments & Cash Management
-
Linking of AP Invoices with withholding tax invoicesSummary: Hi Team, What is the joining/linking of AP Invoices with withholding tax invoices? Can we restrict withholding tax invoices generation post approval of standard…raban 21 views 2 comments 0 points Most recent by Nirav Vekaria Payables, Payments & Cash Management
-
Project Number mandatory for CIP code combination via SanboxSummary: Project Number mandatory for CIP code combination via Sanbox ? Content (required): Hello if user enter an account with CIP account then the project number and o…Cesar Saveedra 32 views 2 comments 1 point Most recent by Cesar Saveedra Payables, Payments & Cash Management
-
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 1.5K views 1 comment 2 points 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 11 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 11 views 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 12 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 31 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 31 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 22 views 1 comment 3 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 91 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. 41 views 11 comments 0 points Most recent by Bhavik Shah Payables, Payments & Cash Management
-
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 4 views 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…Sheneli98 12 views 4 comments 0 points Most recent by Sheneli98 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 11 views 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…