Reporting
Discussion List
-
AP Hold Report that includes Invoice information plus PO numbers, PO line numbersSummary: We need an AP Hold Report that includes PO numbers, PO line numbers, invoice details, and quantity comparisons to identify invoices on hold due to "Billed quant…SBJ_PPM_1210 20 views 3 comments 0 points Most recent by EmmaAndersonTX Payables, Payments & Cash Management -
Is it Possible to e-mail Selected Installments Report When User Initiates Payment Process Request?Summary: Is it possible to automatically e-mail the Payables Selected Installments Report when a user initiates a Payment Process Request? The report generates automatic… -
Income Tax Region population at Invoice Distribution levelhi Folks, I have income Tax region column populated at Invoice distribution level. Which is causing multiple records for a supplier in 1099 EMF report. When I tried to r…BalabhadruniBharat 2 views 0 comments 0 points Started by BalabhadruniBharat Payables, Payments & Cash Management -
1099B reportingSummary: As there is a requirement for suppliers to generate the 1099-B form, is it possible to handle 1099-B reporting within Oracle Fusion? If so, how can this be achi…
-
Check print using Dot Matrix printer on Oracle FusionSummary: Unable to print a check on a Dot Matrix printer. Content (please ensure you mask any confidential information): We are attempting to print a preprinted bank che…Dinesh_Mani 52 views 2 comments 3 points Most recent by Shwetha Shankar Payables, Payments & Cash Management
-
subledger period close Exception Report in terms of Ledger ViewHi Team, we have a Primary Ledger (A) and many associated Secondary ledgers like B, C, D etc. When we create any Transactions in subledger modules like AP, AR, leases et…Santosh Kolisetty 6 views 0 comments 0 points Started by Santosh Kolisetty Payables, Payments & Cash Management
-
Can we create custom reports for IDR recognition report?Summary: The seeded report contains merged fields which prevents us from sorting and gathering data which would allow us to target suppliers that have a lower recognitio…Lisa Poore 100 views 3 comments 0 points Most recent by User_SYJOG Payables, Payments & Cash Management -
Payment template informationSummary: Looking for a SQL query that will give me all the information selected on our payment templates rather than returning 'Specify' or 'All' ie indicating which pay…Clare Farris 28 views 4 comments 0 points Most recent by Clare Farris Payables, Payments & Cash Management
-
Can we rerun the BIP report automatically from Reports and Analytics when its is failedSummary: Some of our BIP reports that are scheduled from Reports and analytics (No ESS jobs created) fails during SFTP connections while transferring the report output t…MaheshT 7 views 1 comment 0 points Most recent by Yemi Onigbode Payables, Payments & Cash Management
-
List of Import Payables Invoices Report Rejection MessagesSummary: Is there a document or a listing that provides the list of rejection messages when interfacing invoices? Content (please ensure you mask any confidential inform…Christian Roxas - PWC 16 views 1 comment 0 points Most recent by Kate D.B-Oracle 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 828 views 2 comments 0 points Most recent by User_FXECS Payables, Payments & Cash Management
-
Query to fetch Approvals Groups Across Workflow ModulesSummary: We need to update a workflow approval group. I’d like a query that shows, by module, every workflow rule that will be affected by this change. Exemple: Approval…usr_a.nv 44 views 6 comments 0 points Most recent by Kate D.B-Oracle Payables, Payments & Cash Management
-
Could you please share any OTBI AP Dashboard ?Summary: Could you please share any OTBI AP Dashboard ? Content (please ensure you mask any confidential information): Hello Could you please share with me any seeded OT…martingabriel Kinovisques 12 views 1 comment 0 points Most recent by RVohra Payables, Payments & Cash Management
-
How to join CE_STATEMENT_LINES, CE_RECON_HISTORY, CE_RECON_HISTORY_ITEMS, AP_CHECK_ALLWe are building a BI publisher report to list Bank Statement Number, Bank Statement Line, Statement Line Amount, AP Payment Number Using the tables CE_STATEMENT_HEADERS …Pradeep Kumar Reddy V 68 views 3 comments 0 points Most recent by luke.syv8 Payables, Payments & Cash Management
-
ACTION REQUIRED notification still appears on the bell icon of the approver for weeksThe approver has approved the approval notification and the invoice is now pending with other approver in the workflow. The Action required notification still appears on…KanikaGupta 283 views 7 comments 0 points Most recent by Mehak Soni Payables, Payments & Cash Management
-
1099k reportingSummary: As there is a requirement for suppliers to generate the 1099-K form, is it possible to handle 1099-K reporting within Oracle Fusion? If so, how can this be achi…Dhruba 47 views 3 comments 0 points Most recent by SherameAnderson Payables, Payments & Cash Management
-
FOS Source Intercompany AP invoice is not same as the converted AR invoice number due to Doc sequThe FOS source transaction when sent In Receivables to create invoices, the FOS Intercompany AR invoice number is getting converted to a new Txn number based on the docu…Sudhanshu Rai 33 views 1 comment 2 points Most recent by Abhinav Garud Payables, Payments & Cash Management
-
Is there a way to exclude certain conversion transactions from showing up CashtoGLRecon report?There are Conversion invoices from April 2022, that are automatically getting reconciled with current period transactions, and when unreconciled they show up in the Cash…Ameen Shoaib 11 views 0 comments 0 points Started by Ameen Shoaib Payables, Payments & Cash Management
-
Create Tree nodes using global DFFSummary: I am planning to use global DFF field manage values as Tree node values on a custom Tree hierarchy. I have downloaded DFF Flex field archive to get the business…
-
Is there any report for Remittance Advice Delivery Email ID by supplier siteSummary: Report for remittance advice delivery email ID by BU Content (please ensure you mask any confidential information): Hi Team We required to update and add more e…JL-JL 104 views 5 comments 0 points Most recent by Emily Downum Payables, Payments & Cash Management
-
Validate Payables Invoices process to exclude manual invoicesHi Team, One of our customers requesting to exclude manual and IDR invoices from validation through Validate Payables Invoices process. Could you please confirm whether …Chanikya Neelam-Oracle 24 views 2 comments 0 points Most recent by Chanikya Neelam-Oracle Payables, Payments & Cash Management
-
Generate Audit ReportSummary: We have this pre defined report in Scheduled ESS jobs. What is the role required to access this report and which team can access this report or who can access t…A Harshith 24 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
OTBI Report for Current Invoice ApproverSummary: I am trying to build an OTBI report that shows invoices that are pending approval along with the name of the current approver. For the most part, I have been ab…Neal Foley 609 views 11 comments 0 points Most recent by Manisha Sujal Puria Payables, Payments & Cash Management
-
How to identify the logic of the fields GC_BANK_TYPE and GC_CONVERSION_TYPE?Summary: Which is the logic of the fields GC_BANK_TYPE and GC_CONVERSION_TYPE on for the Cash to GL Reconciliation Report? Content (please ensure you mask any confidenti…Maricela Diaconita 18 views 3 comments 0 points Most recent by Antony N123 Payables, Payments & Cash Management
-
Custom Payables Invoice Aging Report did not copy the parameterSummary: copy of the Payables Invoice Aging Report did not copy the parameter Content (please ensure you mask any confidential information): Version (include the version…ERP User 11 views 1 comment 0 points Most recent by HD - Oracle Fusion ERP-Oracle Payables, Payments & Cash Management
-
Can we add "PO Number" column to the manage invoices search result?Summary: Search Invoices in Manage Invoice After searching for the invoice number, can we also see/add the PO number column? Content (please ensure you mask any confiden… -
In supplier bank account ...how to bulk upload bank detailsSummary: 1.How can we find the fields values in front end from where the data is capturing from for the the table iby_ext_bank_accounts_v,ce_bank_branches_v,/How to map …soubhagya 26 views 4 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management
-
how to get historical all changes to invoice payablesI would like to ask whether all minor changes made to an Accounts Payable invoice can be tracked specifically, who made the change and what was modified. Is there a way …Andika Kurniawan 23 views 1 comment 0 points Most recent by JimCC Payables, Payments & Cash Management
-
Supplier Balance Aging ReportSummary: Needs to understand the current logic of this "Supplier Balance Aging Report Content (required): Needs your help to understand the standard report level - 1. Wh…Thangavel Senthil 151 views 2 comments 1 point Most recent by Shashidhar AM 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. 515 views 17 comments 0 points Most recent by Thriveni Gudipati Payables, Payments & Cash Management