BI Publisher
Discussion List
-
how to change datamodelSummary: Compensation demonstrative datamodel location Content (required): wich folder datamodel for demonstrative change statement is located to be changed with another… -
Need query Last Supplier Payment >2 yearsHello, I would like to run a query in Oracle Fusion SCM but I keep receiving an error code “ORA-00907: missing right parenthesis”. I’m not sure if it’s because of an err… -
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 31 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
-
How to disable "Import Payable Invoices Report" generating for every Import Payables ESS Job run?Our client uses another system to process their AP Invoices. They validate the invoices triggering the web service for Invoice Import (7.5-10k per day). This process is …Camilo Botín-Oracle 32 views 0 comments 0 points Started by Camilo Botín-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 723 views 1 comment 0 points Most recent by SankarBalu Payables, Payments & Cash Management
-
I see only few terminated PPRs in the iby_pay_service_requests tableSummary: When I check in the application, there are around 15 terminated PPRs available. But when I query , I see only 7 in iby_pay_service_requests table Content (requi…Lakshmi Bandlamudi 41 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
User with employee role can access the BIP report.Currently we are observing that user with employee role can access the BIP report from report and analytics. Employee role is providing the privileges to user to access …Anusha Raghav Naik 25 views 1 comment 0 points Most recent by Karun Jain-Oracle Payables, Payments & Cash Management
-
Is there standard report for movement transaction Purchase requisition until invoice and paymentSummary: the standard report for transaction since PR until payment in one report Content (required): Purchase requisition, Purchase order, Receiving, Invoice and Paymen…MihirS 11 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
Is there standard report temporary prepayment and PermanentSummary: Any standard report to list down the temporary prepayment and permanent prepayment Content (required): list temporary prepayment, list permanent prepayment Vers…MihirS 11 views 1 comment 0 points Most recent by Vivek Mandowara-Oracle Payables, Payments & Cash Management
-
How to add Cash Management application under "Map Reports to Work Area" taskSummary: How to add Cash Management application under "Map Reports to Work Area" task Content (required): We have requirement to create new OTBI dashboard for Cash Manag…SuryaRaju 31 views 2 comments 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
Send Separate Remittance Advice RTF CustomizationSummary: We have customized RTF template for sending remittance information to the Supplier. We are pulling PO number from the invoice line level along with payment info…Rajesh Kumar Gunda 2 views 0 comments 0 points Started by Rajesh Kumar Gunda Payables, Payments & Cash Management
-
Which table has data for 'Manage Data Access for Users' where security context is 'Legal Entity'Summary: We have created a BI Publisher report which is restricted to role - 'Cash Manager' via permission option. From task 'Manage Data Access for Users' we can restri…Sudip Kumar Mishra 514 views 0 comments 1 point Started by Sudip Kumar Mishra 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 21 views 1 comment 0 points Most recent by Narendra Prasad Golla Payables, Payments & Cash Management
-
Customize MT940 formatSummary Change the MT940 file formatContent Hi , We have an issue with line 25 in the MT940 format. We are getting sort code + account number with no delimiter and our b…User_2025-02-07-07-19-13-925 133 views 3 comments 0 points Most recent by Pietro Papaioannu Payables, Payments & Cash Management -
How to query return transaction id from AP invoice tables?Summary: How to query return transaction id from AP invoice tables? Content (required): We have the requirement to get return transaction id of debit memo. But the AP in…Lucy.liu 515 views 1 comment 0 points Most recent by Cesar Tepetla Corte Payables, Payments & Cash Management -
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 74 views 5 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management -
Looking to update the Invoice Approval Notification template and need help finding the infoSummary: Looking to update the Invoice Approval Notification template and need help finding the information in Oracle Fusion. Our Finance Dept. wants to add the multi-pe… -
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 403 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 301 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
Consultation on how to configure sandbox conditionsContent (required): We have the following query: check whether the privileges assigned to a user in Role A prevail over the restriction that would be placed in Sandox fo…
-
Need query for notes created on transaction level and customer level at collections dashboardSummary: Need query for notes created on transaction level and customer level at collections dashboard Content (required): following query only return notes at transacti…Nikatfusion 45 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
Payment format file is producing output in Text format instead of PDFSummary: Payment format file is producing output in Text format instead of PDF Content (required): Version (include the version you are using, if applicable): Code Snipp…User_2025-03-10-22-49-33-989 93 views 2 comments 0 points Most recent by Sandeep Nayak-Oracle Payables, Payments & Cash Management
-
Payment Amount Text in eText template for check printingSummary: We have a requirement to print check amount in below format ONE THOUSAND FIVE HUNDRED USD AND 00/100 DOLLARS Currently xml generated from PPR is having format l…
-
Deleted QuestionDeleted questionSurbhiPapreja 41 views 2 comments 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
How to generate UETR value in Swift ISO 20022Summary: We are working on the implementing the new SWIFT ISO 20022. We see in the documentation that the UETR is mandatory. But the sample template provided by Oracle d…Karishma Mungara-Oracle 940 views 3 comments 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
How to prevent payment amount replication on Payment Details Report-multiple invoices incl in pymtSummary: Payment Details Report is duplicating Payment Amount when more than 1 invoice was included in payment. Is there a way to prevent this from happening? Or add a c…
-
Need source information - Invoice Validation Status Funds RelatedSummary: Need source information (DB Table, View and/or Other) for Invoice Validation Status Funds related. Navigation - Manage Invoices > Query Invoice Number > Click o…Ravi Shinde 43 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management -
How to join AP_INVOICES_ALL with FND_ATTACHED_DOCUMENTSSummary: We need to be able to join AP_INVOICES_ALL with FND_ATTACHED_DOCUMENTS Content (required): Hi team, We currently have a report to extract Paid Invoices where we…Nikash 798 views 1 comment 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
How to sum a variable in XSL template?Summary: I'm unable to a sum a variable data in XSL template. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code…SireeshaJaladi 104 views 0 comments 0 points Started by SireeshaJaladi Reporting and Analytics for ERP