BI Publisher
Discussion List
-
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 41 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 51 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 1 view 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 177 views 4 comments 1 point 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 125 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 2 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 23 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. 215 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 11 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 363 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 3 views 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 23 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 1 view 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 12 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 27 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 332 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 36 views 3 comments 0 points Most recent by ERP.HCM1 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 27 views 2 comments 0 points Most recent by Arjunayan Payables, Payments & Cash Management -
How do you manage consecutive check number using Remittance stub?Summary: When you use Remittance Stub and Void by Overflow in "ExternalCheck.rtf" template for PPR in Account Payables, you have check numbers for void check as well as …Yuko Asanuma 36 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
Query/tables to find payment approved by final approver approved PPRSummary: Query/tables to find payment approved by final approver approved PPR Content (please ensure you mask any confidential information): Hi All, We got a requirement… -
How to customize ISO20022CGI2019.xslSummary:How can I customize ISO20022CGI2019.xsl? Which fields from which records can I use? Content (please ensure you mask any confidential information): Version (inclu…User_VJR36 21 views 2 comments 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management -
Need query/table to get accounting status of external transactionsSummary: Need query/table to get know the accounting status of an External Transaction Content (please ensure you mask any confidential information): Version (include th…Dipak Das 12 views 1 comment 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management