BI Publisher
Discussion List
-
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 1K views 4 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
How to unhide the hidden Infolets or where we can view the hidden InfoletsHi Team, Can you please help us with the below information in oracle fusion. 1.How to unhide the hidden Infolets or where we can view the hidden Infolets. 2.We couldn't …Nirosha Yelicherla 22 views 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 21 views 3 comments 0 points Most recent by chang.liu 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 31 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 24 views 3 comments 0 points Most recent by JimCC 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 12 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 37 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
-
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 164 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 17 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 37 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 43 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 6 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 65 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 44 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 33 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 34 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 261 views 4 comments 0 points Most recent by Vikas V. Kamat 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…
-
In standard - Disbursement Payment File Formats report need xml /data model.Summary: User wants to see approval History details in Standard Disbursement Payment File Formats report. There is no data model available . Kindly provide the xml / dat…Naggrajan 34 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Requirement to customize the Payables Selected Installments Selection data model to add new columnSummary: We have a requirement to customize the Payables Selected Installments Selection report data model to add new column, but the customize option is not available f…Shailender Ahuja-Oracle 33 views 3 comments 0 points Most recent by Shailender Ahuja-Oracle Payables, Payments & Cash Management
-
How do we encrypt the Payables Payment Connection Credentials in the ERP database?Summary: How do we encrypt the Payables Payment Connection Credentials in the ERP database? They are encrypted on the screen but not in the ERP database tables which pos…CarmenR. 23 views 1 comment 0 points Most recent by Daniela Petria-Oracle Payables, Payments & Cash Management
-
Derive Logo on Payment File Format by Legal EntitySummary: Content (please ensure you mask any confidential information): Does anyone know the logic to derive a logo on a rtf payment file format by legal entity? For exa…Rory Mullin 14 views 2 comments 0 points Most recent by Rory Mullin Payables, Payments & Cash Management
-
Edit Bank Account Transfer XML PAIN 001 formatSummary: We are in the process of implementing bank account transfers and our bank is requesting the details in PAIN 001 XML format. Need help to get the XML format to e…Wilson Chelakadan 12 views 1 comment 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
Supplier Legal name change after few months in production and with existing open transactionsSummary Supplier Legal name change after few months in production and with existing open transactionsContent What is the best practice to handle the situation in Cloud i…Sam Samaddar 45 views 8 comments 0 points Most recent by Adman1234 Payables, Payments & Cash Management
-
Oracle AI Apps: Intelligent Account Combination DefaultingSummary: Hi Oracle Team, When i going to enable this feature 'Oracle AI Apps: Intelligent Account Combination Defaulting' , I can't find the mentioned job role AIAPPS_BI…Mina Sabry 81 views 8 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Can we download AP invoice attchement for BU / period of timeSummary: Can we download AP invoice attchement for BU / period of time Content (please ensure you mask any confidential information): Can we download AP invoice attcheme…