BI Publisher
Discussion List
-
Update Disbursement Corporate Credit Card Remittance FormatSummary: We need to fetch the Control account number [at the position 223 in the template] used to send the remittance advice to the AMEX corporate card company after pa…Nipun_Garg 41 views 1 comment 0 points Most recent by Nipun_Garg Payables, Payments & Cash Management -
Update Separate Remittance Format RTFSummary: We would like to add the bank account account name and bank account alternate name from the supplier banking information in the separate remittance RTF. There i…Clare Paone 41 views 3 comments 0 points Most recent by Nipun_Garg Payables, Payments & Cash Management
-
what is the Relation between Withholding tax (AWT) with income tax (Non Rec)Dear , I have custom bi report in there i can see WHT name for one invoice but now i want to add income tax name also but cant cant find the relation I can see details i… -
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 31 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 253 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 125 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 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 33 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 764 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 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 548 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 135 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 516 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 72 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…