BI Publisher
Discussion List
-
Last modified date of Payables Unaccounted and Sweep Report does not match with 24C/24D upgrade dateHi, 24C patch was applied to our systems in August-24 and 24D in November-24, but the last modified date of Payables Unaccounted and Sweep Report is 10/3/24. The auditor…Pranita S - CEG 45 views 4 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Is the default MICR MT in MS Word a licensed monotype font?I'm trying to figure out if our check templates will need updated for the 24A release and am getting the run-around. Does anyone know if the default MICR MT font that is…KatieD_IUH 109 views 3 comments 1 point Most recent by Gerardo Carrillo Payables, Payments & Cash Management
-
Table details to get Business unit for a tax code definedSummary: We need table or query to fetch business unit name for the given tax rate code. Content (required): Version (include the version you are using, if applicable): …Nishanth B Jain 105 views 3 comments 0 points Most recent by User_HIPON Payables, Payments & Cash Management -
Is there a link between Contact and Bank account?Summary: We want to develop a report which list all the active bank account with their specific contacts. Content (required): I have been able to link the 2 using BI pub…Remi Grégoire-Jacques 35 views 3 comments 0 points Most recent by S.heha.n Payables, Payments & Cash Management
-
Payables Invoice and Supplier Balance Aging reports complete in ErrorSummary: Content (required): Hi, We have created a custom role to run AP related reports. It includes the below privileges and duty roles; Privileges Submit Payables Inv…Sheneli98 200 views 8 comments 0 points Most recent by Udhaya Kumar S Payables, Payments & Cash Management
-
Query to find details of Scheduled Processes ESS jobs?Summary: Hi Team, we have requirement to fetch all ESS jobs from Scheduled Processes UI. while i am checking the backend tables unable to fetch the name of scheduled pro…Vishnu_Jai 45 views 4 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Request for SQL Query to Retrieve Cash Balances with Specific ColumnsSummary: Provide a SQL query for Cash Balances to include columns with Legal Entity Name, Entity ID, Bank Account Number, Bank Account Name, Bank Account Type, Currency,…Guthi Mallikarjun 31 views 0 comments 0 points Started by Guthi Mallikarjun Payables, Payments & Cash Management
-
How to auto increment the date parameters of the seeded report?Summary: I need to schedule the report on a monthly basis and will auto increment the said parameters. Payables Invoice Register: -From Entered Date -To Entered Date -Ac…User_7KNJ1 12 views 2 comments 1 point Most recent by User_7KNJ1 Payables, Payments & Cash Management
-
Hi Team, Can you please help us with the below information in oracle fusion. 1.How to unhide the hiSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nirosha Yelicherla 1 view 0 comments 0 points Started by Nirosha Yelicherla Payables, Payments & Cash Management
-
Employee payroll disbursement through H2HWe need to build integrations with bank for payroll disbursement. Could you to please propose the best practice approach for bank H2H integration with oracle Fusion HCM.User_46OWO 31 views 2 comments 0 points Most recent by Ketan- Payroll and Global Payroll Interface (GPI)
-
how can i get the data security info from tables with sql.Summary: i need to use this security infos to restrict the parameters a user can use when submiting a BIP report Content (please ensure you mask any confidential informa…chang.liu 27 views 3 comments 0 points Most recent by chang.liu Payables, Payments & Cash Management
-
How to send formatted Payment Files from Oracle Cloud to a SFTP-server automaticallySummary: How to send formatted Payment Files from Oracle Cloud to an external SFTP-server automatically? Content (please ensure you mask any confidential information): H…Marcus S. 61 views 6 comments 0 points Most recent by Marcus S. Payables, Payments & Cash Management -
Incorrect Payables Invoice Approval Email TemplateHello, We're encountering a strange issue where (very rarely) a Payables invoice sent for approval triggers an email notification using a template that doesn't exist in …Willson Mach 40 views 4 comments 0 points Most recent by SanjayBasera Payables, Payments & Cash Management
-
How to link AP Invoice directly to GL Module as it is not hitting subledgerSummary: Hi Team, How to link AP Invoice directly to GL Module as it is not hitting subledger Content (please ensure you mask any confidential information): Version (inc…Aditi Agrawal2650 27 views 3 comments 0 points Most recent by nothingname Subledger Accounting & Accounting Hub
-
How to concatonate two values into a single field on Positive Pay XML templateWe have a need to combine payee name and address line 2 into the same field for one of our Positive Pay XML templates. I have tried using the concatonation function disc…Daniel T Roy 11 views 4 comments 0 points Most recent by Daniel T Roy Payables, Payments & Cash Management
-
Payment Approval History ReportHi Team, We are trying to develop a query for Payment Approval History Report. Business requested to pull the below details: Payment_number Submitted_By Submitted_Date P…Badripalli Archana-Oracle 23 views 4 comments 0 points Most recent by James McBride Payables, Payments & Cash Management
-
How can we get the Posted Revaluation amount calulation on Daily basis not period?Summary: Bank customer and daily running the revaluation and wants to see the posted revaluation amounts for each foreign currency and revaluation rate. Content (please …Eswarvoona-Oracle 11 views 1 comment 0 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany
-
SQL Query to get Scanned Invoices as mentioned in UI PageWe would like to get SQL query for Scanned, Hold and Paid Invoices as mentioned in UI Page. Please find the below screenshot for more details. Also, we have SQL queries …Chandana Priya-Oracle 82 views 8 comments 0 points Most recent by abigailkenny Payables, Payments & Cash Management
-
Fetch Payment File Reference into Disbursement Payment FileSummary: Fetch Payment File Reference into Disbursement Payment File Content (please ensure you mask any confidential information): We have a custom Disbursement payment…KDR 81 views 4 comments 0 points Most recent by ChaitratestUser Payables, Payments & Cash Management
-
Supplier number not displaying in AP Invoice Coding workflow notificationSummary: How to display Supplier number in AP Invoice Coding workflow notification? Content (please ensure you mask any confidential information): Upon receiving the inv…manojsharma2407.wa 11 views 2 comments 0 points Most recent by manojsharma2407.wa Payables, Payments & Cash Management
-
Empty fields are not displayed on the report output when exporting csvSummary: Empty fields are not displayed on the report output if it was Scheduled through Report and Analytics Content (please ensure you mask any confidential informatio…
-
How to fetch the payment date field under the payment tab (query required)Summary: Hi, I need to verify some information using Oracle BIP tools. Could you please provide the table or the query that will allow me to display the payables invoice…Emilie06 14 views 3 comments 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management -
How to create a report in OTBI of Manage Payment Process Requests informationSummary: The customer needs to have the information regarding the related invoices in a payment batch. Content (please ensure you mask any confidential information): I a…SERGIO BARRETO 35 views 2 comments 0 points Most recent by SERGIO BARRETO Payables, Payments & Cash Management
-
Error on Payables Payment Register Data ModelSummary: Error on Payables Payment Register Data Model Content (please ensure you mask any confidential information): We have customized the seeded report/data model for…
-
Payment Process Request Status Report: Supplier Bank Account not populatedSummary: Hi, In the Seeded Payment Process Request Status Report , Supplier Bank Account is not populated although the supplier bank account is present on the invoice in…Shashank Shekhar 4 views 3 comments 0 points Most recent by AvinashRN Payables, Payments & Cash Management
-
Fusion Ap Invoice Workflow TablesHello Support, We have a requirement to get and build a report of the data stored in WF_NOTIFICATIONS tables of Oracle EBS system to Oracle Fusion System. In EBS we have…Nalsoft Pvt Ltd 41 views 2 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
Linking ce_statement_lines and ap_checks_allSummary: Hi all, I can't find a way to link the tables: ce_statement_lines and ap_checks_all. Is there any intermediate table to link these? Or any way to link bank stat…Sheik Shameem 41 views 4 comments 0 points Most recent by Sheik Shameem Payables, Payments & Cash Management -
Can we exclude Public Holidays when scheduling processesSummary: Our client has a requirement to exclude weekends and public holidays when scheduling, for some of the finance processes. We are able to see an option to exclude…Snehal H 22 views 5 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
What are the setups/steps needed to enable to print the checks in local language?We have a requirement from the Canada, that has to print the checks in their local language (Canadian French). Could you please provide the steps that need to enable in …Raju Thadakala_1234 26 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
SQL query to retrieve the canceled invoices amount as per the date for AP aging report.((select sum(aia1.CANCELLED_AMOUNT) from ap_invoices_all aia1 where 1=1 and aia1.APPROVAL_STATUS = 'CANCELLED' and aia1.invoice_id = aia.invoice_id AND :as_of_date < aia…Vikas V. Kamat 57 views 4 comments 0 points Most recent by Vikas V. Kamat Payables, Payments & Cash Management