BI Publisher
Discussion List
-
How does the ar_bpa_print_requests table get populated?Summary: We are getting timeout issue when trying to print an invoice using the Print Receivable Program. However, this issue only happens if the delivery method of an I…marc.joed.de.guzman 54 views 2 comments 0 points Most recent by marc.joed.de.guzman Receivables & Collections -
Where to Get Custmer Data Model and Table RelationshipsSummary: To support our integration designs with other systems we need to get access to the Custmer Data Model and Table Relationships. Is this anywhere avilable? Only d…
-
Ability to extract in bulk printed pdf attached against AR transactionsSummary: We enabled the feature allowing attaching printed pdfs against AR transactions . “Printed Transaction Copy” (Category) are all attached against printed AR trans…Oliver Lemaire 21 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
In the Customer merge How to get Original Party site details?We recently performed a customer merge activity in the non-PROD instance. To track the details of this activity, we developed a BIP report to display both the old and me…
-
How do I customize and run Invoice Print Report from Receivables?Summary: We have requirement to customize Invoice Print Report from Receivables. We want to know if there is any document present which guides us on how to step by step …Amit Dey 1 view 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
How to customize email body and subject and split it by invoice number/customer name?Summary:Hi team, We request some support in modifying the SJG Dunning letter (Reminder emails for unpaid invoices). The email notification to customers/clients only rece…Somnagho_in-Oracle 111 views 0 comments 0 points Started by Somnagho_in-Oracle Receivables & Collections
-
How can i caculate in BI Publisher rtf templete the number of days between report day and Due date?Summary: Hello! Trying to create a report of Open Receivables Transaction. So i have the column of Due Date () and i'm running the report with parameter of As of Date ( …Yftach Paschur-Oracle 11 views 1 comment 0 points Most recent by Mallik Durgumpudi-Oracle Receivables & Collections -
concatenate data elements with line break in BI excel templateSummary: It is concatenating with supp_name,supp_name2,supp_name3 columns separated by ',' . In my case comma "," also displaying for null cases. Hence i am trying to d…
-
Send copy/information of Printed invoices to specific recipient within the organisationContent When printing invoices and sending them through email we have a requirement for also notifying or sending the same invoice to a specific person within the organi…Stefan pettersson 155 views 2 comments 1 point Most recent by Hemal Maniar Receivables & Collections
-
"View image" navigationWe updated the HST & GST number in the system by end dating the existing one's and created newer ones the problem we are facing now is that when we click on "View image"…Sha Ahmed 11 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
Customer Statement Report – Grouping Transactions by Site Name PrefixSummary: Hi Team, We have a requirement in the customer statement where we need to group all transactions based on the site name prefix FIN/PDR. Currently, the report is…Raman_Balasubramaniam 21 views 1 comment 0 points Most recent by Jigyansa-Oracle Receivables & Collections
-
Is it possible to send two attachments PDF & XML Print Receivables Transaction?Summary: We have created an additional XML template for one of our clients and are currently using a UNION in the Bursting query to attach two files (PDF and XML) to the…Yahya Khan 12 views 1 comment 0 points Most recent by Mallik Durgumpudi-Oracle Receivables & Collections -
display hyperlink in messagesHello I am creating a new message from Manage messages and I am retrieving this message from BI query. I would like to have a hyperlink in the message when I am creating…Swapna Rachamalla 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Customer not imported due to incorrect country codeWe tried to import a customer through the integration which got failed but after checking the batch file it is giving error that country code is not correct. How can We …
-
Run a BIP report and get the output via REST APISummary: We are trying to run a BIP Report via REST API, but getting 404 not found error. /services/rest/v1/reports/{reportPath}/run Content (please ensure you mask any …Abhilash G S 186 views 3 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
How to capture line level applied amount of a credit memo amount on a ar invoice lineSummary: We have applied a credit memo 48012 on a line number 2 of AR invoice 48011. From application UI we can view details of credit memo is applied to line 2 of invoi…ShubhamTiwari93 12 views 3 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Unable to convert our customer outstanding balances to USD for Indian EntitiesSummary: Hi Team, We have requirement to convert customer outstanding balances for India entity to show in USD. In OTBI if you provide option convert outstanding balance…Rajasekhar Reddy Adam 11 views 2 comments 0 points Most recent by Rajasekhar Reddy Adam Receivables & Collections
-
Designing a BIP report that calculates the number of receipt notifications issued each dayHi , We Would like to explore if we can build a BIP report which calculates the number of receipt notifications issued per day. Can you please let us know if it is possi…
-
How to add a QR code in AR print PDF report, where the QR code is coming from 3rd party system.How to add a QR code in AR print PDF report, where the QR code is coming from 3rd party system while integration. We don't want add as an attachment in the invoice, we n…Thanigainathan R 24 views 3 comments 0 points Most recent by Thanigainathan R Receivables & Collections
-
what is the deep link for manage customers details?Summary: We need the deep link of manage customers page Content (please ensure you mask any confidential information): we made a dashboard with customers and we want to …
-
Installments Associated with Collection Documents Listing Report for Brazil not worksSummary: There is a Report available in the Scheduled Process: "Installments Associated with Collection Documents Listing Report for Brazil" I tried to run in many diffe…
-
AR print commercial documents burstingSummary: There is a bursting query in print commercial documents process. We have understood that emails can't be send through this process, wanted to check if FTP or an… -
Show original transaction's Remit To address on Credit MemoSummary: We'd like to have the Remit To address shown of the original transaction on all credit memos. We have one single remit-to address for each country set up, but i… -
Unapplying Credit Memo does not update AR_RECEIVABLE_APPLICATIONS_ALL.applied_customer_trx_idSummary: We tried deleting a credit memo through Manage Credit Memo Application so we are expecting that the ar_receivable_application_all. applied_customer_trx_id will …
-
Is it possible to create a customer index on Oracle Cloud ERP seeded tables?Summary: We are currently using a BIP report to extract recently created transactions from ra_customer_trx_lines_all, relying on the last_updated_date field. The report …Pradeep Moganti 11 views 1 comment 0 points Most recent by Daniel S.-Oracle Reporting and Analytics for ERP
-
Running Create Customer Statements (Statement Generation Report) Outside of UISummary: Is it possible to pass the parameters for the scheduled process "Create Customer Statement" to Fusion without doing so via the UI? We currently utilize OIC (Ora…
-
Ship-to ID's Not Populating In RA_CUSTOMER_TRX_ALL TableHi All, I can see RA_CUSTOMER_TRX_ALL table has all SHIP_TO Columns populated with NULL values. Have used SHIP_TO_PARTY_ID's to get SHIP TO information as per the oracle…
-
Transfer Customer Payment on Bill Management Portal to BankSummary: We are looking to transfer Customer Payment (Bank Method) on the Bill Management Portal to the Bank. Does anyone have any such integration experience with Wells…Suprit 11 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Do we have a delivered NACHA Format template for Fund Disbursement in Customer Payment?Summary: I am looking for a NACHA Format template for Fund Capture that can be used as a reference for customization. I am only able to see the NACHA Format available fo…Suprit 1 view 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections