BI Publisher
Discussion List
-
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 89 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 13 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 36 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
-
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…
-
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 741 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 23 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 6 views 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 146 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 270 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 13 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 57 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 235 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 27 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 40 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. 36 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 6 views 1 comment 0 points Most recent by CA Nirmal Choudhary Receivables & Collections -
how to populate rejection reason for expense auto rejected by WorkflowSummary: Whenever an expense report is auto rejected due to workflow the user wants to see a descriptive reason for teh rejection but currently in expense report only th…User_PZTF9 14 views 4 comments 0 points Most recent by Yahya Khan Payables, Payments & Cash Management
-
Mapping Payment Format - Replace decimal with commaSummary: Mapping Payment Format - Replace decimal point with comma Content (please ensure you mask any confidential information): EText RTF Template - Fixed position tem…Amit Patnaik 13 views 1 comment 0 points Most recent by Amit Patnaik Payables, Payments & Cash Management
-
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 96 views 9 comments 0 points Most recent by Sudan Rajashekar-Oracle Payables, Payments & Cash Management
-
what is the relevant table for ap_batches_all table in oracle fusionwe have AP_BATCHES_ALL table in oracle fusion, but we don't see any data in table . Is there any relevant table for ap batchesHarshitha S Motagi 13 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
what is the XML Field for file modifier in payment file ACH formatwhat is the XML Field for file ID modifier in payment file ACH format for Bank of America. Attached is the bank specifications.Harshitha S Motagi 17 views 0 comments 0 points Started by Harshitha S Motagi Payables, Payments & Cash Management
-
Suggestion Needed: Removal of special characters at the XSL template level for Payment OutboundsHi Oracle Cloud Community, I hope this message finds you well. We are working on a project where our client requires payment outbound files generated in oracle cloud whi…Subhranil Maitra 27 views 0 comments 0 points Started by Subhranil Maitra Payables, Payments & Cash Management