BI Publisher
Discussion List
-
PO Matched Invoices where retainage are not calculatedSQL query to get PO Matched Invoice are created but retainage are not entered or calculated automatically from Purchase OrdersMr.Bilal 6 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management -
AP Invoice Account Coding initiation dateSummary: which fusion table will have information of AP invoice Accounting Code, Initiation Date to write a SQL query Content (required): AP Invoice Account Coding initi…Harish Pati 177 views 2 comments 0 points Most recent by James Canaber Payables, Payments & Cash Management
-
RTF Payment File Output - How Can I add invoice/payment approvals to it?Hi Guys I need to add the list of creation details/approvers for each invoice listed on a payment file output which is built using an RTF file. So for two invoices I mig…
-
province tag is missing in Payee/Address/ level in Payment xml though value exists in setupSummary: In Oracle Cloud, Not able to see Province tag in Payee/Address/ in the Disbursement Payment File Format standard xml output even though value exists in the supp…Chowdari Malapati Monika 31 views 5 comments 0 points Most recent by Chowdari Malapati Monika Payables, Payments & Cash Management
-
Requires to have a Cash Flow Report?Hi, We require to have a cash flow report, appreciate if you can provide any existing reports or subject areas which can be used in creating the report, and any inputs y…Janitha Perera 17 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
I want to exclude Invoices with source EMP_EXPENSE_REPORT from Supplier Balance Aging ReportSummary: How can i edit this standard report data model and template? Content (please ensure you mask any confidential information): I want to exclude Invoices with sour…Mr.Bilal 77 views 1 comment 0 points Most recent by Neeraj Pandey-Oracle Payables, Payments & Cash Management
-
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 135 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 46 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 44 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 34 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 48 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 66 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 17 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 30 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 261 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 128 views 1 comment 3 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Deleted QuestionDeleted QuestionSurbhiPapreja 27 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 50 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 36 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.5K 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 47 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 32 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 16 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 15 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 34 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 10 views 0 comments 0 points Started by Rajesh Kumar Gunda Payables, Payments & Cash Management