BI Publisher
Discussion List
-
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 111 views 11 comments 0 points Most recent by Sudip Dutta Payables, Payments & Cash Management -
I want joins for ap_terms_tl and FND_SETID_SETS tabSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Sushmita Nagaraj Doddamani 6 views 2 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to Unmask Bank Account Details when Masking and Encryption is EnabledSummary: Hello Everyone, In Oracle Fusion Applications, we have enabled "Bank Account Encryption" and also "Bank Account Number Masking (last 4 digits)" through System S…Bharath2712Automus 16 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
A Functional Guide for customizing Disbursement Payment File Format in Oracle Cloud ERPHi All, Please find below detailed steps on how an Oracle Finance Functional Consultant should approach the customization of any payment file (Disbursement Payment File)…CA Nirmal Choudhary 145 views 4 comments 4 points Most recent by Elcaro Payables, Payments & Cash Management -
How does Group Notification Configuration works-Send One email containing all email addressesSummary: We are trying to update the Notification Settings for the Invoice Approval Workflow (Approval Group) to Send One Email with all user emails instead of separate …Baskara Sateesh-Oracle 6 views 0 comments 0 points Started by Baskara Sateesh-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 59 views 3 comments 0 points Most recent by Basavaraj Navalagi Payables, Payments & Cash Management -
Positive Pay File in ISO20022 XML formatHi All, We have a requirement from BMO bank to generate Positive Pay file in XML format and should be compliant with ISO20022 format. I have downloaded ISO20022 xsl temp…Alekhya_N 11 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Table and column name in oracle fusion payables to derive the "Allow tax applicability" flagSummary: Hi Team, I need the table and column name to derive the allow tax applicability flag. The "Allow Tax Applicability" flag Appears Checked in the UI but Remains N…SunilPradhan 11 views 5 comments 0 points Most recent by Purvi -Oracle 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 96 views 6 comments 0 points Most recent by Mark Stonerock Payables, Payments & Cash Management
-
AP_TRIAL_BAL_REPORT_PKGSummary:AP_TRIAL_BAL_REPORT_PKG body code is required Content (please ensure you mask any confidential information): Version (include the version you are using, if appli…
-
Need attachment url from AP invoicesSummary: Need invoice attachment url for approval notification Content (please ensure you mask any confidential information): Trying to add the invoice attachment url to…
-
AP Check print squares instead of MICR Numbers at bottom of the CheckSummary: AP Check print squares instead of MICR Numbers at bottom of the Check BIP Report = Downloaded the Disbursement Payment File Formats Shared Folders > Financials …Vincent T 11 views 1 comment 0 points Most recent by Basavaraj Navalagi Payables, Payments & Cash Management
-
Supplier Spend Analysis report fails with error ORA-06503: PL/SQL: Function returned without valueWe are trying to run standard report Supplier Spend Analysis report, but as soon as we open the report, it tries to load and fails before we submit the report with error…Shailender Ahuja-Oracle 12 views 2 comments 0 points Most recent by Shailender Ahuja-Oracle Payables, Payments & Cash Management
-
Bank is eliminating weak Ciphers and requiring Oracle to allow specific Ciphers for them though whenSummary: Bank is eliminating weak Ciphers and requiring Oracle to allow specific Ciphers for them though when our Payment process automatically transmits from Oracle Clo…Danny P Smith 31 views 2 comments 0 points Most recent by Katy T Payables, Payments & Cash Management
-
Assistance Required: Locating PVOs for ar_batch_sources_all and ar_credit_memo_amounts Table in BICCSummary: I am currently working on extracting BIP tables from BICC to UCM, but I am unable to locate the tables ar_batch_sources_all and ar_credit_memo_amounts within th…
-
Query to find the approver name for AP invoicesWhat is the query or table name where we can find the approver name and approval date(action date) for an AP invoice. The table ap_inv_aprvl_hist_all gives the approver …KanikaGupta 6K views 4 comments 2 points Most recent by User_QTQ8P Payables, Payments & Cash Management
-
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 752 views 8 comments 2 points Most recent by Ankit.K Payables, Payments & Cash Management
-
CAMT053 Bank Statement Import is failing with ERROR [LINE_NUM_MISSING]Summary: All Bank Statements imported with CAMT053 format is failing to import with the error message below for each of the lines: [2025-07-15 14:19:59.048] ERROR [LINE_…PwC Team Member 21 views 2 comments 0 points Most recent by User_DO3DP Payables, Payments & Cash Management
-
How to get delivery status of each bursting file of BIP report using Sql QueryHow to get delivery status of each bursting file of BIP report using Sql QueryPrafulla_Chaskar 1 view 0 comments 0 points Started by Prafulla_Chaskar Payables, Payments & Cash Management
-
why are the CST_%_DAILY tables on our instances emptyThese tables are purportedly available for use in BI Publisher reports, but all are empty in our instance. Why?
-
Custom Remittance Advice Template not appearing in Manage formatsSeparate Remittance advice do not have a data model. I have created a custom template that in BI publisher in custom folder custom>financials>payments, but my custom tem…KanikaGupta 143 views 2 comments 0 points Most recent by GIRIJA BODLA Payables, Payments & Cash Management
-
Restrict Quick Payment and Allow only Manual PaymentIssue: There ate no apporvals for Payments created via create payments tab. So, Business wants to restrict the users only to make manual payments from Create Payments Ta…Jagjit Singh Arora 275 views 4 comments 0 points Most recent by GIRIJA BODLA Payables, Payments & Cash Management
-
Using Multiple SSL Certificates for Different PrintersDear All, I have multiple printers and multiple SSL certificates. I need to use a different SSL certificate for each printer. However, when I enter the Delivery configur…George Mattar 11 views 0 comments 0 points Started by George Mattar Payables, Payments & Cash Management
-
Query Supplier Account Bank Information TableSummary: I Want to export all information about supplier account bank via BI Report Content (please ensure you mask any confidential information): Supplier on Procuremen…Muhammad Fahmi 59 views 3 comments 0 points Most recent by User_U58AH Payables, Payments & Cash Management
-
Trial Balance Report data model errorHi, I'm trying to customize 'Trial Balance Report'. When I run TrialBalanceDm with relevant parameters, its throwing below error. ORA-20101: ORA-06512: at "FUSION.GL_TRI…Manavalan 232 views 4 comments 0 points Most recent by RAPHAEL PETIT Payables, Payments & Cash Management
-
We need show Invoice Distribution COA Account segment values on AP CheckSummary: We need to show Invoice Distribution COA Account segment values on AP Check in Fusion Cloud Accounts Payable. These fields are not available in XML. I cannot ad…Ibrahim Konak 21 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
How to Add Custom Email Body Text for Separate Remittance Advice Email (with PDF) in OracleHi All, In Oracle Fusion Payables, I need to send a Separate Remittance Advice by email with a PDF attachment and have a specific message appear in the email body. The m…Mukesh Sirigiri 46 views 3 comments 0 points Most recent by Mukesh Sirigiri Payables, Payments & Cash Management
-
How to use 'Ignore Participant' under the THEN option in the BPM Rules for Invoice Approvals?Summary: We are trying to use 'Ignore Participant' asunder the THEN option for one of the AP Invoice routing rules in the BPM but getting an error ' RUL-05730 : type "LI…AkashAgarwal 1.3K views 4 comments 0 points Most recent by RenganathanVenkatesan Payables, Payments & Cash Management
-
Add an Email Body to Separate Remittance Advice Emails with attached PDF by using BI ?Summary: Since there's still no Email Body feature available when using Separate Remittance Advice Emails with attached PDF -but- is it maybe possible to add an Email Bo…Marcus S. 34 views 3 comments 0 points Most recent by Sankalp Gupta Payables, Payments & Cash Management -
How to get XML extract "Funds Capture Payer Notification" ReportIs there any way or SQL query to get XML extract for Funds Capture Payer Notification There is a sample provided from Oracle but we want actual one. Is Any XML Output Fo…CA Nirmal Choudhary 2 views 1 comment 0 points Most recent by CA Nirmal Choudhary Receivables & Collections