BI Publisher
Discussion List
-
Custom Disbursement Payment File Format Not Appearing in 'Manage Format' SetupDear All, I have successfully customized the Disbursement Payment File Format report: I also added two custom templates: However, nothing appears in the 'Manage Format' …George Mattar 79 views 5 comments 0 points Most recent by SachinJain14 Payables, Payments & Cash Management -
Connect to PaaS db from BIP to create report from custom tables created in PaaSSummary: Connect to PaaS db from BIP JDBC / JNDI connection to create report from custom tables created in PaaS Content (please ensure you mask any confidential informat…Jepson Erattuparmbil 2 views 1 comment 1 point Most recent by Suresh Mohan Gulrajani BI Publisher Learning Center
-
Accrual Month end Report Query based on CMR_PO_ACCRUAL_AMTS tableHi All, Business Background: Our business requires an automated PO Receipt Accrual Period End Process to support end-of-month activities related to purchasing. The curre…
-
Invoices incomplete status with yellow exclamation markSummary: Invoices imported by IDR are in an incomplete status. The lines on the invoices have a yellow exclamation mark, with type Item. We have a requirement to report …Narinder Sian 42 views 3 comments 0 points Most recent by Kanika Matta Payables, Payments & Cash Management
-
How to Include Supplier Site-Level Details in Payment XML generated by Oracle FusionWe are working with Oracle Fusion Payments and have a requirement to include supplier site-level information in the payment XML (Seeded XML generated by Fusion) and the …mauryapradhyumn420 25 views 2 comments 0 points Most recent by mauryapradhyumn420 Payables, Payments & Cash Management
-
Addition of columns to U.S 1099 Payment reportHi, We had requirement to add below columns to U.S 1099 Payment Report. Vendor Type of TIN ( E/S) Vendor Recipient Address 1 Vendor Recipient Address 2 Vendor Recipient …Ismail Sherief 2 views 0 comments 0 points Started by Ismail Sherief Payables, Payments & Cash Management
-
Customizing Separate Remittance Advice Subject with dynamic valueSummary: Customizing Separate Remittance Advice Subject Content (please ensure you mask any confidential information): Hi Team we should customize the subject with PAYEE…Luca Nobili PWC 135 views 4 comments 0 points Most recent by CristinaV1-Oracle Payables, Payments & Cash Management
-
AP_INVOICES_UTILITY_PKG.GET_APPROVAL_STATUS p[erformanceSummary: Performance issue in AP_INVOICES_UTILITY_PKG.GET_APPROVAL_STATUS pkg Content (please ensure you mask any confidential information): Hi, I am using SELECT distin…azodpe 68 views 1 comment 0 points Most recent by Gabriela Patrascu-Oracle Payables, Payments & Cash Management
-
How to incorporate count of payment numbers in rtf template Positive pay file in fusionHow to incorporate count of payment numbers in rtf template Positive pay file in fusionKavitha Nanjundaiah-Oracle 3 views 1 comment 0 points Most recent by Kavitha Nanjundaiah-Oracle Payables, Payments & Cash Management -
Why does the logo for our Separate Remittance Advice ends up as attachment via emailSummary: Our Separate Remittance Advice is customized and our client wants to have a logo on the SRA. When the delivery method is via Email with .pdf as attachment, the …Christian Roxas 13 views 2 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Report to view unprocessed IDR InvoicesSummary: I have a requirement to create a report to show all unprocessed IDR invoices. Is there a table that provides this information? Content (please ensure you mask a… -
in Payment Files using SWIFT MT103 file format, how do I get 2 zeroes for the Decimal?I have an issue with regards to the decimal of the PaymentAmount/Value field. Below are the details of the field. Length - 2 Format - Number, Decimal Data - PaymentAmoun…
-
query to get page customization data through sandboxSummary: Required SQL table name where page customization information stored throgh Sandbox Content (please ensure you mask any confidential information): Hi Team, Can a…
-
How to hide custom Report from BIP page and ESS job from Scheduled Process ?Hi Team, I have a requirement to hide Custom Report and Respective ESS job (BI catalog page and Scheduled process) From User's view. Tool → Scheduled Process →ESS job. T…
-
Format Payment File -ORA-64451: Conversion of special character to escaped character failed error?Summary: Hello, has anyone received the error above when attempting to run Format Payment Files? If so, have you developed approaches to either proactively prevent the i…
-
facing error in OIC with reference to argument9 parameter from supplier balance aging report.Summary: We are facing error/exception in OIC with reference to argument9 parameter from supplier balance aging report. There is no option to check the attribute name fo…
-
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. 183 views 12 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
Flexibility of Separate Remittance Advice Email BodyContent (please ensure you mask any confidential information): Currently, our client would like to have an email body to an SRA if the delivery method is 'Email with .pd…Christian Roxas 15 views 3 comments 0 points Most recent by Christian Roxas Payables, Payments & Cash Management
-
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 352 views 21 comments 0 points Most recent by Beat Nuolf-Oracle Payables, Payments & Cash Management
-
Check Print Page countHi Team, We have a requirement of developing a report which gives the count of pages that was used for a particular check in Oracle Fusion. Questions: 1. Are there any b…Sandipan Pal 1 view 1 comment 0 points Most recent by Nani Prasanth Doredla-Oracle Payables, Payments & Cash Management
-
I m getting below error on job run####[2025-06-04T06:47:38.908+00:00] [INFO] dummy file is deleted ================ BIPJobExecutable Execution Started ============ OutputFile : /u01/APPLTOP/instance/ess/…Tejashwini K H 17 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Payment File formatSummary: Payment File format Content (required): Hi All, We got a requirement from the bank to modify the Payment file format . Currently the format is, R|DEBIT_ACCOUNT_…Venkatesan 32 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Custom Data Model Not Reflecting in Payment File – Fix?Summary: Context: We have set up a transmission configuration to transmit files to an SFTP server. Additionally, we have: Created a Data Model to extract the required fi…Sandeep cheerla 3 views 2 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMSSummary: Hi TTeam, Could you please help us on this below SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMS in Specify Cash Positioning and Forecasting …Opkey PA 11 views 3 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Unable to find validation status in AP_INVOICES_ALLWe are creating a custom report and we need to give invoice validation status as a parameter. I am not able to find anything with validation status. Need some help on it…KabirB 26 views 4 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
SQL query to get Manage Withholding Tax Classifications setup dataSummary: Hi Team, We need a table where the information of Manage Withholding Tax Classifications setup data. The table ZX_ID_TCC_MAPPING_ALL have the classification cod…
-
How to process 1099 DIV, 1099 INT, 1099 K and 1099 S from Oracle FusionSummary: How can we process 1099 DIV, 1099 INT, 1099 K and 1099 S forms from oracle fusion? Content (please ensure you mask any confidential information): Version (inclu…Pranav7607 299 views 9 comments 1 point Most recent by S Akhtar Payables, Payments & Cash Management
-
Need to check the default parameter logic for the Supplier Balance Aging Report.Summary: Hi Oracle Community , I need to check the default parameter logic for the Supplier Balance Aging Report, When I submit the report with ledger, business unit and…User_J7ULB 32 views 3 comments 0 points Most recent by ERP.HCM1 Payables, Payments & Cash Management
-
how DOCUMENT_CLOB gets populated in IBY_TRXN_DOCUMENTS table?We have requirements to create custom payment documents. We are reusing ISO20022CGI.xsl file from Disbursement Payment File Formats. The data model has SELECT DOCUMENT_C…KabirB 145 views 5 comments 0 points Most recent by Nallari Archana Payables, Payments & Cash Management
-
Provide the supplier balance aging report logic from backend.Summary: Hi Team, Could you please help us to provide the supplier balance aging report logic from backend. We were not able to see the logic of supplier balance aging r…Arjunayan 23 views 2 comments 0 points Most recent by Arjunayan Payables, Payments & Cash Management