BI Publisher
Discussion List
-
How increase limit of rows in otbi analysisSummary: How increase limit of rows in otbi analysis Content (required): Customer have some Analysis created and he want to know if there are some possibility to export …Adriana Martins 1.3K views 8 comments 1 point Most recent by SureshRamanujam Receivables & Collections -
Hitting the standard template in the 'View Image' of AR Invoice transactions.Hi Team, The custom template for the Print Receivables Transactions job is defined, but when clicking View Image in Receivables, the report defaults to the standard temp…Nirosha Yelicherla 41 views 2 comments 0 points Most recent by Nirosha Yelicherla Receivables & Collections
-
how can i get last date when customer was printed in final mode for a customer in oracle fusionHow can I get the last date when statement was printed in final mode for a customer in oracle fusion. Is that value stored in any table or is there any API that can be u…
-
Print Receivables process for 'Paper' batch when there are no eligible transactions ends in ErrorSummary: As far as I know there isn't a way to change this but we are wondering if there is a way to update how Print Receivables works when the 'Paper' batch for Print …
-
Ability to store Email ID on Order and then use it for sending invoices to customerSummary: Content (please ensure you mask any confidential information): Need an ability to capture ordering email id for credit card customers and use that to send an em…
-
How to default Invoice Template on customer basis?Summary: Content (please ensure you mask any confidential information): We have a requirement where we want to have separate invoice template on the basis of Credit card…
-
Issue while creating AR Customer Profile using we serviceHi, I tried to create Ar customer profile using the ReceivablesCustomerprofileservice webservice It was working perfectly before with me using the same combination of pa…
-
we don't have access to OTBI report subject areaSummary: We don't have access to otbi report subject role with custom role, we unable find the exact privilege was missing. kindly help us on this. Thank you.
-
Request to Exclude Zero-Amount Records from Standard Customer Statement ReportHi Team, We have requirement in the standard customer statement report output and require a solution or workaround to exclude zero-amount records from the report. For re…Raman_Balasubramaniam 34 views 3 comments 0 points Most recent by User_VQFGM Receivables & Collections
-
How to fetch Customer VAT number on Sales invoice reportSummary: Could someone please help which column, table stores Customer VAT number to add in the report. I have checked in the ZX_PARTY_TAX_PROFILE table for column rep_r…
-
Request for Solution & Documentation on Oracle Fusion ERP Integration with ZATCA for AR invoicesSummary: We are currently working on implementing e-Invoicing compliance for Saudi Arabia (KSA) and need to integrate Oracle Fusion ERP with the ZATCA portal in accordan… -
New Parameter to Oracle Data modelSummary: Hi, I have a requirement to add the parameter to Receivables-Statement Generation data model, its giving me error saying Parameter is not declared in the packag…
-
How to Enable EFF on AR Invoice not DFFSummary: How to Enable EFF on AR Invoices not DFF Content (please ensure you mask any confidential information): Due to limitation of DFF attributes list on AR Invoice, …
-
Rejection reason message need to be printed in the Reversal Status ReportHi Oracle community, I hope this message finds you well. We have encountered a scenario where different levels of rejection reason message need to be printed in the Reve…
-
To update the "Send statement" box, we use the REST API for Customer profile.Summary: to update the "Send Statement" checkbox for a customer in Oracle Fusion do we have the rest api and If yes what it is Content (please ensure you mask any confid…
-
How to get XML extract "Funds Capture Payer Notification" ReportHow to get XML extract "Funds Capture Payer Notification" Report https://docs.oracle.com/en/cloud/saas/financials/24d/faofc/funds-capture-payer-notification-reports.html…CA Nirmal Choudhary 27 views 1 comment 0 points Most recent by CA Nirmal Choudhary Receivables & Collections -
How do we split the invoice and supporting attachments into separate files in Print ReceivablesCurrent State : Invoice and supporting attachments are sent as one file to the customer from the client when they run the Print Receivables Job in Oracle Fusion Requirem…
-
Add parameter to Seeded report- Statement Generation data modelSummary: Hi, I have a requirement to add the parameter to Receivables-Statement Generation data model, its giving me error saying Parameter is not declared in the packag…
-
Receivables Billing History Extract - Unable to add custom parameter in BIP Data modelHello Experts, We have a requirement to add an extra parameter (Customer class) to the seeded report - Billing History Report. Data Model Path - /Shared Folders/Financia…Yugesh Keluskar 32 views 2 comments 0 points Most recent by Yugesh Keluskar Receivables & Collections
-
Third party Balances Summary Report Differ when we run period range Group by No/YesSummary: We noticed an issue with "Third party Balances Summary Report" for source as Receivables. The issue is, the output/balances differ when we run the report for a …
-
How to get AR billing transaction note plain text without html tag ?Hi All, I'd like to build a customer report about AR billing which contains note. While I found the note in backend table contains html tags. Note in the UI: SQL result…
-
Write a BI Publisher SQL query to list all customers where 'Send Statement' is not checked,Summary: i Found out we cannot write this query in the BI Publisher and it can be done in the OTBI only if yes what is the reason and if possible please help us to fix t…
-
Retrieve all positive and negative balance associated with a customer.Hi Team, We have a requirement to generate a list of all customers whose accounts have either a positive or negative balance. Could you please provide a detailed explana…
-
How can we find Customer Details from VAT ID in Oracle ERPSummary: How can we find Customer Details from VAT ID in Oracle ERP Content (please ensure you mask any confidential information): Version (include the version you are u…
-
Print Receivables Transactions – Historical Delivery Details Retrieval (Older than 1 Year)Hi All, Need to check if there’s any way to retrieve delivery details (email, timestamp, etc.) for invoices sent via the Print Receivables Transactions job, specifically…
-
AgingbyGeneralLedgerAccount_Understanding the Receivables Aging by GL Account ReportAgingbyGeneralLedgerAccount_The following three questions are asked about the Receivables Aging by GL Account report: ・There are 546 items when outputting CSV, but I wo…Yuma Suzuki-Oracle 2 views 0 comments 0 points Started by Yuma Suzuki-Oracle Receivables & Collections
-
ESS job is takeing more time to run the reportSummary: while scheduling report from analytics schedule report it is takeing less time to run, but while trying to run from schedule process it is takeing more time Con…Charan Kumar Reddy Lingala 34 views 8 comments 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Applications Administration
-
Add a document outside fusion which can be sent to customers using Print Receivables Transactions.Summary: We have a requirement where an additional document is required to be sent to customers along with the AR Invoice. This document is outside Oracle Fusion. Need t…Shefali Lakhani 12 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
Can we Print incomplete AR Transactions in Print Receivables Transactions ESS JobCan we Print incomplete AR Transactions in Print Receivables Transactions ESS JobSidh 3 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Is it possible to run the Create Customer Statements job for a date rangeOur Business Users want to be able to run the AR 'Create Customer Statements' job for a specific date range so as to filter out old transaction history. They also want t…