Reporting
Discussion List
-
How to best account for 1099 transactions for prior year entered in current year?Summary: We have a number of partners for Accounts Payable that will send us transactions that need to be accounted for in 1099 processing. In our previous ERP we could …Schneider.Mark 1 view 0 comments 2 points Started by Schneider.Mark Payables, Payments & Cash Management -
Is there a way to apply holds on Withholding Tax type invoices via a automated processSummary: I have a requirement to place the 'Withholding tax' invoices with Custome hold via REST API integration. I tried to perform via standard REST API but seems Orac…DharaniR 26 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
1099 reporting for year 2023Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Jagan Ramadugu 21 views 1 comment 0 points Most recent by Jagan Ramadugu Payables, Payments & Cash Management
-
IDR: Report to pull Invoice Account Coding HistorySummary: We would like to track account coding history as part of the invoice for reference and audit purposes. What is the best way to accomplish that? Content (require…Judy Hamner 122 views 1 comment 3 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Does Positive Pay report support ISO format (XSL template)Summary:Does Positive Pay report support ISO format (XSL template)? Content (required): Version (include the version you are using, if applicable): Code Snippet (add any…anupriverma 52 views 1 comment 0 points Most recent by Michelle Finocchio - Oracle-Oracle Payables, Payments & Cash Management
-
Payables Audit ReportSummary: I am trying to understand the different options available in the Payables Audit Report. I created an Oracle SR but Oracle Support was not familiar with this pro… -
How to disabling the approve button in the notification for certain set of usersSummary: How to disabling the approve button in the notification for certain set of users Content (required): How to disabling the approve button in the notification for…
-
Invoice installment DFF not visible in OTBISummary: We have created Invoice Installment DFF and make that BI enabled but that is not coming in OTBI Installments real time subject area Content (required): We have …arpit_paliwl 53 views 3 comments 0 points Most recent by Selva Sub-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 …Umer.Farooq 31 views 4 comments 0 points Most recent by Prabal_Agrawal Payables, Payments & Cash Management -
Payables OTBI Subject Area - Account Coding Intiated DateHi All, We are developing an AP KPI dashboard using OTBI . Wanted to check if the following field available in Payables OTBI subject area? 1. Invoice Account Coding Init…Devashish Saun 32 views 0 comments 0 points Started by Devashish Saun Payables, Payments & Cash Management -
SQL for Current approver of AP InvoiceSummary: We have requirement to find the current approver of AP Invoice if the invoice is under approval . We are using below query to find the current approver select A…Oracletechnofunctional 1.4K views 1 comment 0 points Most recent by SankarBalu Payables, Payments & Cash Management
-
OTBI - View employee hierarchy vs manager hierarchySummary: I am trying to write an analysis in OTBI which would provide a managers Level 2,3,4,5 Department vs an employee's Level 2,3,4,5 Department. I want to ensure tha…Scott_Turner_ 44 views 0 comments 0 points Started by Scott_Turner_ Payables, Payments & Cash Management -
how to purge data files from ucm server for Import Payables programSummary: We have around 2000 datafiles appearing in datafiles Lov while submitting Load Interface File for Import program. Attaching the screenshot where the datafiles c…Sachin Kr Singh 21 views 2 comments 0 points Most recent by Sachin Kr Singh Payables, Payments & Cash Management -
Table to extract taxpayer id details for suppliers of individual typeSummary: Table to extract taxpayer id details for suppliers of individual type Content (required): Table to extract taxpayer id details for suppliers of individual type.…Vinothini 752 views 1 comment 0 points Most recent by SankarBalu Payables, Payments & Cash Management
-
Rehire can't run OTBI report, but net new user account with same access canSummary: We have a rehire who can't run an OTBI report we built, but the same net new user account with the exact same roles and data access can. Content (required): Has… -
Do we have any report what are the employee expense invoices applied against the Employee advancesSummary: Do we have any report what are the employee expense invoices applied against the Employee advances Content (required): Business wanted to see which are the expe…Sangireddy-Oracle 1 view 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
Adding page break to etext templateSummary: We have an etext template that we need to have a page break to. It appears that we can do this with xml, but we currently don't have any XML in our template. Is… -
Netting Settlement Letter doesn't show Payables transactionsSummary: When executing a Netting settlement and downloading the Netting Settlement Letter, the payables transactions section is not showing the information of the invoi…FiorellaLamas 12 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
How to setup an AP Payment term 95% inmmediate 5% on hold ?Summary: How to setup an AP Payment term 95% inmmediate 5% on hold ? Content (required): Hello I have a business requirement for one supplier 95% is due inmmediate and 5…Cesar Saveedra 22 views 2 comments 0 points Most recent by Cesar Saveedra Payables, Payments & Cash Management
-
Do we have any tax related report which shows data in functional currencies in Fusion?Summary: Our expectation is all the AP, AR or Other Tax related Transaction in Functional Currencies Report. Content (required): We have financial tax register report bu…VijayDXC 12 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
How to track changes in Approval limits in BPMSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Table that holds US 1099 payment related info.Summary: Content (required): Hi All, We are building a custom report on top of "US 1099 Report", that report the payments made to a vendor who is covered under federal r…Srikanth_K 11 views 1 comment 0 points Most recent by Sandeep Nayak-Oracle Payables, Payments & Cash Management
-
Include project details AP Payment CheckSummary: In 'Disbursement Payment File Formats' oracle Seeded XML file I did not see AP invoice project details, if invoice is mapped to any project details. How to map …Narendra Prasad Golla 23 views 1 comment 0 points Most recent by Narendra Prasad Golla Payables, Payments & Cash Management
-
Logic behind the comparison filter for invoice numbers, AR and APFor an integration and extension we are designing, we need to have a clear understanding of the logic used by the same system when the user uses the following filters fo…
-
Table details for Setup: Payment process ProfileSummary: Table details for Setup: Payment process Profile Content (required): We need table details, which stores Default Payment Document for Payment Process Profile Cr…Nishanth B Jain 75 views 5 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management -
Configuration Required to Generate SEPA Payment File on ScheduleSummary: Configuration Required to Generate SEPA Payment File on Schedule Content (required): Hello All, We have a requirement to generate and export SEPA payment file e…Bernard T 24 views 2 comments 0 points Most recent by Bernard T Payables, Payments & Cash Management
-
How To Successfully Customize the "Disbursement Payment Process Request Status Report Formats"Summary: We are turning on payment approvals but the approvers do not like the seeded layout of the Disbursement Payment Process Request Status Report. I was attempting …Brian Burns 415 views 4 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
How to Generate XML and Modify the Payment Process Request Status ReportSummary: I am trying to customize the payment process request status report but am unable to generate an xml of the report in order to either make a new layout or edit t…Brian Burns 312 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management