BI Publisher
Discussion List
-
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 2 views 0 comments 0 points Started by Oracletechnofunctional Payables, Payments & Cash Management -
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…C. Stap 7 views 1 comment 0 points Most recent by Ramalingam Muthaian Pillai- Support-Oracle Payables, Payments & Cash Management -
Audit Receipt Accrual Clearing Balances ReportIn receipt accounting you have this report that can be run from the screen. I have not been able to find a way to do this without exporting the data from the screen. Is …
-
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 2 views 0 comments 0 points Started by Camilo Botín-Oracle Payables, Payments & Cash Management
-
create AP Invoice custom Inquiry role without using AP_MANAGE_PAYABLES_INVOICES_ACTIVITIES_PRIVSummary: can we create role for AP invoice Inquiry and view report access without using AP_MANAGE_PAYABLES_INVOICES_ACTIVITIES_PRIV" which Allows access to Oracle Fusion…manoj.kumar4 12 views 1 comment 0 points Most recent by Mohamed Sadik -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.…
-
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 22 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
XML file Required for Positive Pay etext template customizationSummary XML file Required for Positive Pay etext template customizationContent please let me know how to fetch the positive pay xml file required for etext template Vers…Smandanak 176 views 8 comments 0 points Most recent by OraTechAssociate 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 12 views 1 comment 0 points Most recent by Karun_Jain-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…
-
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… -
Why cant I find AI Apps Administrator under Tool (quick link)Summary: We planned to use newly (23B) rolled Intelligent Account Default AI feature in Fusion Payables. The first step is to add role 'Application Implementation Consul…Bikash Khilar 12 views 2 comments 0 points Most recent by Bikash Khilar Payables, Payments & Cash Management -
Is there a way to restrict Invoice Approval Email Notification in Oracle Fusion?Summary: We have several approval rules configured for AP Invoices. The requirement is to restrict oracle to send an approval email notification ONLY when specific appro…nbatra 84 views 9 comments 0 points Most recent by Vipul Sojitra Payables, Payments & Cash Management
-
My goal is to generate hyperlinks within BIP report outcomes, linking them to attachments related toSummary: I intend to create hyperlinks within BIP report results that correspond to attachments for AP Invoices. Clicking on these hyperlinks should lead to the display …bhavana.sudanagunta 2 views 1 comment 0 points Most recent by MariusS-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 13 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 12 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 32 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 579 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 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 3 views 0 comments 0 points Started by Sudip Kumar Mishra Payables, Payments & Cash Management
-
Printing the check number at the bottom of the physical AP Check reportSummary: We have created a custom AP Check RTF template based on the client's requirements. The custom RTF template is used in the Disbursement Payment File Formats repo…shrikardixit 13 views 0 comments 0 points Started by shrikardixit 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…
-
The column "Accounting Status" on Manage Invoice screen is which table information?Summary: From which table can I get the "Partially accounted" in the attached image? Content (required): PATH :: HOME>Invoices>Task:Manage Invoices I want to get the val…REI TSUKAHAR-Oracle 42 views 5 comments 0 points Most recent by Sandeep Nayak-Oracle 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 12 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…Sravanthi Kollapudu 84 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 103 views 1 comment 0 points Most recent by Cesar Tepetla Corte Payables, Payments & Cash Management -
Requesting query to capture CMK Errors for AP Invoice Inbound MessageSummary: As per our client requirement, we need to generate BIP Report to capture CMK Errors for AP Invoice Inbound Message. The Report should have the Error type, error…Priyanka_Choubey 22 views 0 comments 0 points Started by Priyanka_Choubey 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 42 views 5 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management -
How Payables gets the Remittance Email for Customer Refunds?Summary: How Payables gets the Remittance Email for Customer Refunds? Content (required): We are creating CM in AR and issuing refunds in payables. We need to send remit…
-
How to make 'Routing Attribute 2' field a drop down instead of a free text in the invoice header?Summary: We want to make 'Routing Attribute 2' field a drop down instead of a free text in the invoice header since our invoice approvals are based on this field and mos…AkashAgarwal 32 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management