BI Publisher
Discussion List
-
Add regular page number and section(journal) page number in the same report outputSummary: Hi Team, We are printing a journal report. we have a requirement to print 2 sets of page numbers Regular page number and Section(Journal) Page number expected o…Praveen3015-Oracle 23 views 1 comment 1 point Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Unable to generate a new PGP key in BI publisherSummary: Our current cloud BI Publisher PGP key is expiring on 26 Jan 2024. Bank want us to send our new PGP public key. When I download the new key from the PGP key are…Nallas 41 views 4 comments 0 points Most recent by PG_of_NSG-Oracle Payables, Payments & Cash Management
-
Is there a way to auto-increment date parameter while running "Multiperiod accounting"process/reportSummary: We need "Create Accounting" and "Multiperiod Accounting" jobs to run daily. While the "Create Accounting" job’s date parameter is Incrementing automatically eve…Srikanth Dodla 73 views 1 comment 0 points Most recent by Priyaranjan Shetty-Oracle Payables, Payments & Cash Management
-
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 51 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…KatieW_IUH 157 views 3 comments 1 point Most recent by Gerardo Carrillo 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 279 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 2.9K 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 21 views 0 comments 1 point 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 32 views 2 comments 0 points Most recent by KetanChavan 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 24 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 146 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 248 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 75 views 3 comments 0 points Most recent by Shouryadeep12-Oracle 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 2 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 91 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 55 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 32 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 33 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 428 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 32 views 1 comment 0 points Most recent by MiaM-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. 21 views 1 comment 0 points Most recent by Daniela Petria-Oracle Payables, Payments & Cash Management