Reporting
Discussion List
-
Cash and General Ledger report shows lines that are actually reconciledSummary: Lines that are actually reconciled are shown in the report and this causes imbalance in the reconciliation report. Content (please ensure you mask any confident…Patricia Vargas 12 views 3 comments 0 points Most recent by Patricia Vargas Payables, Payments & Cash Management -
Is there a job to detect IC bills that have been transferred to payables but not yet posted?There is an intercompany raise in Sep’23 but AP team overlooked and didn’t post to ledger within the same month. The invoice was validated but not initiated, therefore, …ivy.danao17 1 view 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management -
Can anyone suggest some tips to optimize SQL queries for slow running BI reportsSummary: Can anyone suggest some tips to optimize SQL queries for slow running BI reports. Please share your knowledge or experience here. Content (please ensure you mas… -
US 1099 Report displaying reissued paymentsSummary: Oracle Standard US 1099 Report displaying the reissued payments which are already been reported in previous years. This is causing duplication of reporting for …Azar Kadivella 11 views 3 comments 0 points Most recent by Azar Kadivella Payables, Payments & Cash Management
-
Journal Line Rule Item Expense Merge Option Set to 'No'Summary: Hi all, Business wants to see the detailed posting of Item Expense in GL, by default SLA for Item expense is merge 'Debits or Credits' for Invoices and Merge 'A…VinayakK 12 views 1 comment 0 points Most recent by Daniela Petria-Oracle Payables, Payments & Cash Management
-
Can the audit policy feature be turned on for specific payables business unit?Summary: For statutory reasons, some of my business units, representing non-US regions, need to have the audit policy turned on for most of all payables and payments act…Antonio LH 1 view 3 comments 0 points Most recent by Veronica Racoviteanu-Oracle Payables, Payments & Cash Management
-
Audit policies for manage banks/branchSummary: We would like to have audit on banks/branch setup, but it is not available in Manage Audit Policies. I hope that anyone can help? Content (required): Version (i…Anja Daugaard 11 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Cash Revaluation ReportSummary: Revaluation Report needed in Cash Management. Content (please ensure you mask any confidential information): In the Fusion Applications, there are 2 reports: Pa…S Ramanathan-Oracle 1 view 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
In case of 3 way matching, missing linkage between PO, Receipt and Invoice at line levelSummary: PO has receipt but when searching in the invoice workbench to match invoice with PO and Receipt then the search results with no data. We need to match the invoi…Chetana More 11 views 1 comment 0 points Most recent by Simran Kohli Payables, Payments & Cash Management
-
Merge mail envelope for Finance check in fusionSummary: Hi Team, Do we have any standard functionality to have merge mail envelopes to Financial checks? Auditors have suggested not to mail check in windows envelopes.…Nidhi Chhajed 2 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to improve the AP Match with more than 100 lines ?Summary: How to improve the AP Match with more than 100 lines ? Content (please ensure you mask any confidential information): Hello We have a PO with more than 100 line…Cesar Saveedra 22 views 2 comments 0 points Most recent by Prashanth Govindarajan Payables, Payments & Cash Management
-
France Localization- DAS2 Reporting - List of Federal income tax type valuesWe are implementing DAS2 reporting for France, and as a pre-requisite for the report it is expected to store the SIRET number at the taxpayer id on the supplier profile …Shankhajit Ghosh 33 views 1 comment 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Tax & Global
-
Unable to import China Golden Tax Invoices to FusionSummary: What is the process to Import Golden Tax Invoices into Oracle Fusion ( No Golden Tax transaction was found for the VAT invoice.) Content (please ensure you mask…Krupa.B 52 views 1 comment 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Tax & Global
-
How to show in the audit report the values changed in BPM Worklist's FinApInvoiceApproval RulesSummary: What report can we use to capture the changes made to parameters of FinApInvoiceApprovalRules in BPM Worklist. Audit Report doesn't show the old/new parameter v…Ileana 23 views 1 comment 1 point Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
Will Escheated payments be included in the Positive Pay Voids file?As part of the 24b release, there is a new feature to Escheat unclaimed checks. After escheating a check payment and running the Positive Pay job for Voided Payments onl…Evelyn Libatter 31 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
How to stop receipt accounting accruals for Finally Closed POs.Summary: We have multiple PO's in a 'Finally Closed' status and all of them shows accruals entries in the receipt accounting . Please tell us a way to stop these accrual…
-
Invoice Failed Funds CheckSummary: Invoice Failed Funds Check Content (please ensure you mask any confidential information): Invoice Failed Funds Check Version (include the version you are using,…
-
how to customize Invoice approval mail notificationSummary: how to customize Invoice approval mail notification add Accounting date of invoice Header in Notification mail Content (please ensure you mask any confidential …Kumar 57 2 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management -
Access to Payable Invoice Attachment in UCMSummary Access to Payable Invoice Attachment in UCMContent Hi Community, We are trying to access the manually uploaded attachments to payables invoices in UCM however we…Kunal Daya-175386 109 views 3 comments 0 points Most recent by User_12INY Payables, Payments & Cash Management
-
Can I generate a PDF copy of a single Payment Remittance Advice?Summary: Can I generate a PDF copy of a single Payment Remittance Advice? Content (required): A user has asked me if they can generate a PDF copy of a remittance advice …u20240321 629 views 16 comments 0 points Most recent by Zakir-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…
-
Need a query for AP Invoice validated by and validate date two column store in which tableSummary: Need a query for AP Invoice validated by and validate date two column store in which table Content (please ensure you mask any confidential information): Versio…Banerjee Subham 1 view 3 comments 0 points Most recent by Meghana Gaddam-Oracle Payables, Payments & Cash Management
-
Remittance Advise output is blankHi We customized the remittance advise report, and we can see the custom remittance advise format is getting picked up once the PPR process completes. we can see the log…Wira Sanjaya 1 view 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Bank account Reconcile OTBI reportSummary: Content (required): when I make a cash transfer from bank to bank .there are two numbers one of these is a transaction number on the manage transaction page and…salma_essam 84 views 2 comments 0 points Most recent by Truptesh Solanki Payables, Payments & Cash Management
-
Is there ability to view taxpayer ID in manage invoice columnWe have need to add Taxpayer ID to search results in Manage Invoice view. Right now you can add Taxpayer ID To the search criteria but its not possible to add it as a co…Margaret OConnor 1 view 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
AP Invoice Account Coding Status for BI ReportingSummary Need the AP Invoice Account Coding Status field and table for BI ReportingContent Hi Community, We need to build a report to show all invoice with a specific acc…Kunal Daya-175386 385 views 7 comments 2 points Most recent by User_TGDWL Payables, Payments & Cash Management
-
Which table Stores the AP Invoice Mail Received Date by the IDR and Process Date by the IDR?Summary: I'm creating a custom report and I need to add the Dates when Mail Received by the IDR and Process by the IDR. I refer from the OOTB report (IDRImageTraceabilit…James Canaber 31 views 2 comments 1 point Most recent by Brian Burns Payables, Payments & Cash Management
-
Join Validated Date to Invoice Details in OTBI Data ModelSummary: We are trying to write a query in OTBI to create a data model that joins Validated Date and Validated By to Invoice Details. In running the query below, we noti…hannah_barry 12 views 3 comments 0 points Most recent by hannah_barry Payables, Payments & Cash Management
-
How to Display Only the Last 4 Digits of the Social Security Number on 1099 FormsHello, Does anyone know how we can display only the last 4 digits of an Individual's SSN on the 1099 Forms? Thank you, Julia -
Scheduling month end jobs - how to future date parameter for following periods will affect?Hi Team, Business is scheduling the period close activity related programs like EX: Create accounting, Period close exception reports, Trail Balance reports, how to futu…Tegalapalli Sreenivasa Reddy 11 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management