BI Publisher
Discussion List
-
Payment File > French International EFT > RTF Template > Payee/LegalEntityRegistrationNumberSummary: Payment File > French International EFT > RTF Template > Payee/LegalEntityRegistrationNumber Content (please ensure you mask any confidential information): Hell…
-
Negative Vendor_Id values in AP_INVOICE_ALL TableSummary: We can see -ve vendor id's in AP_INVOICES_ALL table which are not available in POZ_SUPPLIERS table at all. We understand that this is expected behavior in scena…PradeepKrSingh 37 views 1 comment 0 points Most recent by SankarBalu Payables, Payments & Cash Management
-
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 35 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 41 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
query to get page customization data through sandboxSummary: Required SQL table name where page customization information stored throgh Sandbox Content (please ensure you mask any confidential information): Hi Team, Can a…
-
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 41 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 11 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 11 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 94 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 94 views 1 comment 3 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 41 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Process Payment Files > ISO 20022 SEPA > Credit Transfer Messages > Predefined BI Publisher TemplateSummary: Process Payment Files > ISO 20022 SEPA > Credit Transfer Messages > Predefined BI Publisher Templates Content (required): Hello All, Regarding the ISO 20022 SEP…
-
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 682 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 31 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 129 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 21 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
-
Query to get tax registration from supplier address levelSummary Tax Registration from Supplier AddressContent Hello I was wondering if you can share with me any SQL to get the Tax Registration at the address Level. I have the…gabriel kinovisques-163562 2.8K views 4 comments 1 point Most recent by Mohamed Faramawy dev.-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 1 view 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 170 views 0 comments 0 points Started by Sudip Kumar Mishra Payables, Payments & Cash Management
-
How to use round and sum in ctrlsum tag in oracle payment fileSummary: We need to show total in ctrl sum below. ex. payment1 : $100.1 ,payment2 : 100.4 the payment amount to show 100 and 100 as we doing round off. ctrl sum should s…