Reporting
Discussion List
- 
             Why smart view report cash forecast report can not drill downSummary: Why smart view report cash forecast report can not drill down? When i click the amount the link will be jumped to correct UI page. But prompt a window to show N…Lynn Du-Oracle 55 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management Why smart view report cash forecast report can not drill downSummary: Why smart view report cash forecast report can not drill down? When i click the amount the link will be jumped to correct UI page. But prompt a window to show N…Lynn Du-Oracle 55 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
- 
             Israel localization 856 report to display VAT and WHT taxSummary: Paying to a service provider which is not define as tax organization but needs to deduct WHT and VAT and to b displayed in WHT report 102 and 856 reports. Conte… Israel localization 856 report to display VAT and WHT taxSummary: Paying to a service provider which is not define as tax organization but needs to deduct WHT and VAT and to b displayed in WHT report 102 and 856 reports. Conte…
- 
             we need a sample payment file for rtgs payment methodwe are implementing payments for customer and they want a payment file which has rtgs payment method so we need a sample payment file for rtgs payment method Thanks, Sai…Sai Divya Kolachana 6 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management we need a sample payment file for rtgs payment methodwe are implementing payments for customer and they want a payment file which has rtgs payment method so we need a sample payment file for rtgs payment method Thanks, Sai…Sai Divya Kolachana 6 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
- 
             AP report which tells who Validated the invoicesSummary: Content (please ensure you mask any confidential information): Hello, user is trying to quantify some activities in AP, is there a report that I can run that wi…Vikram_Patel 12 views 5 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management AP report which tells who Validated the invoicesSummary: Content (please ensure you mask any confidential information): Hello, user is trying to quantify some activities in AP, is there a report that I can run that wi…Vikram_Patel 12 views 5 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
- 
             Please kindly let me know which database table store the data for 'Payment Terms'?Please kindly let me know which database table store the data for 'Payment Terms' under UI Manage Customers (Accounts) ? We need to using SQL to create a report.achia.tseng 1 view 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management Please kindly let me know which database table store the data for 'Payment Terms'?Please kindly let me know which database table store the data for 'Payment Terms' under UI Manage Customers (Accounts) ? We need to using SQL to create a report.achia.tseng 1 view 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
- 
             Supplier Aging as of Date Report LogicSummary: Can I know the exact logic for the report Supplier Aging balance using as-of-date for the following scenario? 1- An invoice created at 01-Jul-24 and its due dat…Alaaeldin Ahmed 31 views 3 comments 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management Supplier Aging as of Date Report LogicSummary: Can I know the exact logic for the report Supplier Aging balance using as-of-date for the following scenario? 1- An invoice created at 01-Jul-24 and its due dat…Alaaeldin Ahmed 31 views 3 comments 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
- 
             How to extract invoice information in the Payment File Format? Invoice date or invoice header attribSummary: How to extract invoice information in the Payment File Format? we need to customize the CBI Xml file format adding information of invoices: invoice_date and som… How to extract invoice information in the Payment File Format? Invoice date or invoice header attribSummary: How to extract invoice information in the Payment File Format? we need to customize the CBI Xml file format adding information of invoices: invoice_date and som…
- 
             How to check the date when we enabled audit trail in Oracle ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… How to check the date when we enabled audit trail in Oracle ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
- 
             Why Cash Management forecast list wrong amount for AP credit memo and debit memo?Summary: Why Cash Management forecast list wrong amount for AP credit memo and debit memo? Content (please ensure you mask any confidential information): 5 day Forecast …Lynn Du-Oracle 12 views 2 comments 0 points Most recent by Lynn Du-Oracle Payables, Payments & Cash Management Why Cash Management forecast list wrong amount for AP credit memo and debit memo?Summary: Why Cash Management forecast list wrong amount for AP credit memo and debit memo? Content (please ensure you mask any confidential information): 5 day Forecast …Lynn Du-Oracle 12 views 2 comments 0 points Most recent by Lynn Du-Oracle Payables, Payments & Cash Management
- 
             How to run 1099 report for one time payment partySummary: We have made some some one time payments to individual party? How to print 1099 report for them? As one time party is not created as a supplier? Any advice? Con…Sam Samaddar 97 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management How to run 1099 report for one time payment partySummary: We have made some some one time payments to individual party? How to print 1099 report for them? As one time party is not created as a supplier? Any advice? Con…Sam Samaddar 97 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
- 
             Payables Aging Report not matching with Trial BalanceSummary: Hi Team, Client owns a custom AP Aging report which is not matching with the Trial balance report but it gives the exact details of all the unpaid invoices with…Sesha Sailini 311 views 1 comment 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management Payables Aging Report not matching with Trial BalanceSummary: Hi Team, Client owns a custom AP Aging report which is not matching with the Trial balance report but it gives the exact details of all the unpaid invoices with…Sesha Sailini 311 views 1 comment 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
- 
             Create Mass Addition ReportSummary: Hi, When AP user submits the Create Mass Addition process, the AP lines are transferred to the FA Module but the Mass Addition Report is not generated. Please a… Create Mass Addition ReportSummary: Hi, When AP user submits the Create Mass Addition process, the AP lines are transferred to the FA Module but the Mass Addition Report is not generated. Please a…
- 
             Is There a Report to Help Reconcile Secondary Ledger Journals with Primary Ledger Journals?Summary: Our Secondary ledger is at the SubLedger conversion level. Is there any standard report that can b used to reconcile the JEs between Primary Ledger and the Seco…Kumar_Tarun 72 views 2 comments 0 points Most recent by Baidehi Nanda–Support-Oracle General Ledger & Intercompany Is There a Report to Help Reconcile Secondary Ledger Journals with Primary Ledger Journals?Summary: Our Secondary ledger is at the SubLedger conversion level. Is there any standard report that can b used to reconcile the JEs between Primary Ledger and the Seco…Kumar_Tarun 72 views 2 comments 0 points Most recent by Baidehi Nanda–Support-Oracle General Ledger & Intercompany
- 
             1—found answer—Laila Kuhn-Oracle 11 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management 1—found answer—Laila Kuhn-Oracle 11 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
- 
             Is Project Number for AP available in General Ledger or Subledger Accounting Subject AreaGood Day Experts, Is project number field for AP available in General Ledger or Subledger Accounting Real Time subject area? Just like the PO Number for AP where I can g…JMLMIII 1 view 1 comment 0 points Most recent by Dustin Grabowski-Oracle Payables, Payments & Cash Management Is Project Number for AP available in General Ledger or Subledger Accounting Subject AreaGood Day Experts, Is project number field for AP available in General Ledger or Subledger Accounting Real Time subject area? Just like the PO Number for AP where I can g…JMLMIII 1 view 1 comment 0 points Most recent by Dustin Grabowski-Oracle Payables, Payments & Cash Management
- 
             1099 - Supplier has 2 sites that need to be reportableSummary: Standard Functionality only allows one 1099 reporting site flagged, however in one case they both need to be. If invoices are entered under the other site that …Anthony Cambria 31 views 2 comments 0 points Most recent by glakshmisha Payables, Payments & Cash Management 1099 - Supplier has 2 sites that need to be reportableSummary: Standard Functionality only allows one 1099 reporting site flagged, however in one case they both need to be. If invoices are entered under the other site that …Anthony Cambria 31 views 2 comments 0 points Most recent by glakshmisha Payables, Payments & Cash Management
- 
             How to burst a standard report attachment run from scheduled process page to a users email?Summary: Our users spend so much time going into the system to download the files they run from the monitor/scheduled process page. We have already customized the Oracle… How to burst a standard report attachment run from scheduled process page to a users email?Summary: Our users spend so much time going into the system to download the files they run from the monitor/scheduled process page. We have already customized the Oracle…
- 
             Oracle Fusion to customize format payment data modelSummary: Hello everyone. For implementation on a client, a new custom check format needs to be created. It is necessary to add some fields that are not shown in the xml.…Juan López 224 views 2 comments 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management Oracle Fusion to customize format payment data modelSummary: Hello everyone. For implementation on a client, a new custom check format needs to be created. It is necessary to add some fields that are not shown in the xml.…Juan López 224 views 2 comments 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
- 
             Reportable flag in supplier exception reportSummary: Business wants to see the suppliers that should have been setup as federal reportable but incorrectly setup in Oracle in US 1099 supplier exception report. We c…Sujatha Kumari 3 views 1 comment 0 points Most recent by James McBride Payables, Payments & Cash Management Reportable flag in supplier exception reportSummary: Business wants to see the suppliers that should have been setup as federal reportable but incorrectly setup in Oracle in US 1099 supplier exception report. We c…Sujatha Kumari 3 views 1 comment 0 points Most recent by James McBride Payables, Payments & Cash Management
- 
             Sql Query to find the approver name for AP invoicesSummary: I am looking to get approver name for AP invoices Content (please ensure you mask any confidential information): Version (include the version you are using, if …Rahul K-Oracle 203 views 1 comment 0 points Most recent by Saurav Sunny Payables, Payments & Cash Management Sql Query to find the approver name for AP invoicesSummary: I am looking to get approver name for AP invoices Content (please ensure you mask any confidential information): Version (include the version you are using, if …Rahul K-Oracle 203 views 1 comment 0 points Most recent by Saurav Sunny Payables, Payments & Cash Management
- 
             PVO for tax line distributions of an invoice to load data to FAWSummary: we have a requirement to showcase tax line distributions if an invoice in a FAW report. These data is not coming to FAW from ERP through delivered pipelines. Wa…Balachandra reddy 21 views 1 comment 0 points Most recent by Daniela Petria-Oracle Reporting and Analytics for ERP PVO for tax line distributions of an invoice to load data to FAWSummary: we have a requirement to showcase tax line distributions if an invoice in a FAW report. These data is not coming to FAW from ERP through delivered pipelines. Wa…Balachandra reddy 21 views 1 comment 0 points Most recent by Daniela Petria-Oracle Reporting and Analytics for ERP
- 
             Employee addresses are showing in Escheatment report addressHi Team , we are not using Oracle fusion Expense module , so we are creating employee as supplier we got a new feature "Escheatment of Checks" , if we escheat checks in …Subhash M V 11 views 4 comments 0 points Most recent by Subhash M V Payables, Payments & Cash Management Employee addresses are showing in Escheatment report addressHi Team , we are not using Oracle fusion Expense module , so we are creating employee as supplier we got a new feature "Escheatment of Checks" , if we escheat checks in …Subhash M V 11 views 4 comments 0 points Most recent by Subhash M V Payables, Payments & Cash Management
- 
             ISO 2022 Payment formatsSummary ISO 2022 Payment formatsContent Hello everyone, I am trying to understand how ISO 2022 payments work. How do we create those payment formats. If anybody has any …Lucky Sharma 58 views 6 comments 0 points Most recent by Lucky Sharma Payables, Payments & Cash Management ISO 2022 Payment formatsSummary ISO 2022 Payment formatsContent Hello everyone, I am trying to understand how ISO 2022 payments work. How do we create those payment formats. If anybody has any …Lucky Sharma 58 views 6 comments 0 points Most recent by Lucky Sharma Payables, Payments & Cash Management
- 
             Where do we enter State reportable ID for 1099 in Oracle cloud Supplier setupSummary: Create Supplier ---Income Tax---Enter Taxpayer Country: US Taxpayer ID: Federal reportable Federal Income Tax Type Enable State reportable and where do Enter St… Where do we enter State reportable ID for 1099 in Oracle cloud Supplier setupSummary: Create Supplier ---Income Tax---Enter Taxpayer Country: US Taxpayer ID: Federal reportable Federal Income Tax Type Enable State reportable and where do Enter St…
- 
             How to set as of date in past for Audit Receipt Accrual Clearing Balance reportSummary: Need to run the report with as of date in run historically so user can see balances on dates in the past. Content (please ensure you mask any confidential infor… How to set as of date in past for Audit Receipt Accrual Clearing Balance reportSummary: Need to run the report with as of date in run historically so user can see balances on dates in the past. Content (please ensure you mask any confidential infor…
- 
             how to enter supplier number manuallySummary: i have a question from customer to create the supplier number manually and it has numbers and characters is that applicable ????????? Content (please ensure you… how to enter supplier number manuallySummary: i have a question from customer to create the supplier number manually and it has numbers and characters is that applicable ????????? Content (please ensure you…
- 
             Bursting Report QuerySummary: I want to build report something like below: payment advise to supplier - Subject : Invoice ----- is paid mail body : Dear (supplier name)-->Got it , your invoi…Amit Saraf 11 views 2 comments 0 points Most recent by Mona Mantry Payables, Payments & Cash Management Bursting Report QuerySummary: I want to build report something like below: payment advise to supplier - Subject : Invoice ----- is paid mail body : Dear (supplier name)-->Got it , your invoi…Amit Saraf 11 views 2 comments 0 points Most recent by Mona Mantry Payables, Payments & Cash Management
- 
             Not receiving email notifications for Invoice approvalsSummary Not receiving email notifications for Invoice approvalsContent Hi All, Not receiving email notifications for Invoice approvals Thanks, Dev Thota. Version 20CDevendra Thota 49 views 3 comments 3 points Most recent by Unnati Mandhare Payables, Payments & Cash Management Not receiving email notifications for Invoice approvalsSummary Not receiving email notifications for Invoice approvalsContent Hi All, Not receiving email notifications for Invoice approvals Thanks, Dev Thota. Version 20CDevendra Thota 49 views 3 comments 3 points Most recent by Unnati Mandhare Payables, Payments & Cash Management
- 
             Suggestions for tracking AP productivitySummary: What does everyone do to track productivity for AP? Are there any reports? Best practices? Content (please ensure you mask any confidential information): For ex… Suggestions for tracking AP productivitySummary: What does everyone do to track productivity for AP? Are there any reports? Best practices? Content (please ensure you mask any confidential information): For ex…