BI Publisher
Discussion List
-
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…
-
Table with error messages and warnings of Supplier Bank Accounts FBDI ImportContent Does anyone know if the error messages and warnings of the Supplier Bank Accounts FBDI Import are stored in a base table of which we can report through BI Publis…User_CR41D 685 views 7 comments 2 points Most recent by Mahaveer Nagar Payables, Payments & Cash Management
-
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. 142 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 340 views 21 comments 0 points Most recent by Beat Nuolf-Oracle 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 91 views 3 comments 0 points Most recent by User_BAVH3 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 4 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 9 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 6 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 24 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…
-
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 1 view 0 comments 0 points Started by Jepson Erattuparmbil Payables, Payments & Cash Management
-
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 262 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 31 views 3 comments 0 points Most recent by ERP.HCM1 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…
-
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…
-
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
-
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 34 views 4 comments 0 points Most recent by George Mattar 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 21 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…
-
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 201 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
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 2 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 18 views 1 comment 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management
-
Oracle Analytics Publisher Desktop Silent Install FailSummary: I have a requirement to install Oracle Analytics Publisher Desktop to client's machines via a silent install. When trying to perform this install with the synta…Johnny'sDaddy 33 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
SUPPLIER BALANCE AGING REPORT Showing invoices in Unallocated AmountSummary: Needs to understand the current logic of this "Supplier Balance Aging Report Content (please ensure you mask any confidential information): The accounting event…
-
How to get Trial balance detailed ReportSummary: Please let me know how to drill down from the Payables Trial Balance Report to view invoices? Content (please ensure you mask any confidential information): Ver…sailesh_cloudare 12 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management