BI Publisher
Discussion List
-
What are the control reports to be run on the fresh instanceSummary: We are going to start testing and want to run the control reports in the fresh instance. Could you let me know what are the control reports to be run. The modul…Lal11 32 views 3 comments 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management -
Not able to include file type attachments in Invoice Account Coding Email NotificationSummary: Trying to customize Invoice Account Coding Email Notification to include all invoice attachments hyperlinks in the notification, but we are not able to get hype…Chowdari Malapati Monika 42 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
I need to setup a printer for AP check printing, Which server need to use either CUPS or WINDOWS.Summary: I need to setup a printer for AP check printing, Which server need to use either CUPS or WINDOWS Content (required): I need to setup a printer for AP check prin…Lakshmana 61 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
ERROR MESSAGESummary: Error message related to invoice on Hold report Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…Eleti Mahender 12 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
How to find assignee value for an invoice in a query?Summary: I'm unable the table and field to get this specific assignee for an invoice Content (please ensure you mask any confidential information): Version (include the …Naushad Khodabocus 21 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Does anyone use JP Morgan Chase Check Printing services?We are exploring having JP Morgan print our checks and so need to setup a payment file that will be sent to JPMC. We envision utilizing the POSPAY file generation proces…Richard Nagle 246 views 4 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
IDR: Report to pull Invoice Account Coding HistorySummary: We would like to track account coding history as part of the invoice for reference and audit purposes. What is the best way to accomplish that? Content (require…Judy Hamner 122 views 1 comment 3 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Deleted QuestionDeleted QuestionSurbhiPapreja 21 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to update subject line for mail notification in Invoice ApprovalSummary: We have a requirement to include cost center details in the subject line of invoice approval mail notification. Is it possible? do we have a document for that? …Surya08 44 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
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 32 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 752 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 42 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 22 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 535 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 23 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 134 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 514 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 75 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 415 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 312 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…