Reporting
Discussion List
-
Payment to Escheatment AuthoritySummary: Is there any way to flag an Escheated payment once it has been paid to the Escheatment Authority? We will need to report on the amount to pay the Escheatment Au…Neal Foley 50 views 6 comments 0 points Most recent by Neal Foley Payables, Payments & Cash Management -
Is there a way to hide a specific hierarchy from being available to users when they run FRS reports?Summary: Is there a way to hide a specific hierarchy from being available to users when they run FRS reports without negatively affecting things? Content (please ensure …Tripti Khare 6 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
AP Invoice Approval layout missing from approval email notificationSummary: Created customised AP Invoice Approval notification layout and was appearing in the notification email. After removing all layouts, including delivered, from th…Kevin Lau 27 views 2 comments 0 points Most recent by Kevin Lau Payables, Payments & Cash Management -
Is there a holiday calendar setup in Fusion?Summary: We have an Accounts Payables custom report where one of the columns is required to show the number of days/ calculation of the time it takes to process an invoi… -
Payables Localization Reporting related fields not getting populated on IC invoices from AGISSummary: We are not able to see localization reporting related fields like "Transaction Business Category", "Document fiscal classification" etc getting populated in the…Aakash Banka 15 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Ensure All Payable invoices having Asset Clearing Acc moved to Fixed Assets through Mass Addition.Summary: We need to Ensure that all the Payable invoices having Asset Clearing Account Combination moved to Fixed Assets under Create Mass Additions. If Some Invoices Fa…Muhammad Zarlash 15 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
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 18 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 6 views 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 16 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 15 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 6 views 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 13 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 11 views 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 34 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 8 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 24 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 133 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 63 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 113 views 1 comment 1 point 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 38 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 205 views 3 comments 0 points Most recent by Mangesh M 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 …JimCC 1.4K views 16 comments 0 points Most recent by Zakir-Oracle Payables, Payments & Cash Management -
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 12 views 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 6 views 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 114 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 8 views 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 518 views 7 comments 2 points Most recent by User_TGDWL Payables, Payments & Cash Management