BI Publisher
Discussion List
-
Send dunning letter ESS jobHi, We have a business requirement to customize the Send Dunning Letter ESS job, we have customized the 'Send Dunning Letter' ESS job, but when I try to submit it, an er… -
How does Print Receivables Transactions divides the transactions into batches for processingSummary: Hi, We have queries on the functionality of following Standard process: Parent Job-Print Receivable Transaction Child Job- Print Receivables Transactions: Invoi…Pooja K 4 views 1 comment 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
Delivery of balance forward bills stops in Retry In Progress statusSummary: Delivery of balance forward bills stops in Retry In Progress status Content (please ensure you mask any confidential information): You're about to run create a …Yuma Suzuki-Oracle 25 views 4 comments 0 points Most recent by CA Neha Jain Receivables & Collections
-
I can't see report of import autoinvoceI can't click on republish and download the pdf of the import. Maybe I need a privilege, I don't know.
-
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 15 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 28 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 2 views 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 26 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 1 view 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…
-
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…
-
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 136 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 11 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 93 views 3 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to join ra_customer_trx_all (AR Header Table) with projects tables to get the project NumberSummary: We are Trying to get the 'Project number' field in the 'Manage Transactions' Header Screen inside 'Billable' in Receivables. We are unable to find direct join t…PrerakKhandelwal 45 views 1 comment 0 points Most recent by Jithendra-Fusion Receivables-Oracle Receivables & Collections
-
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 15 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 21 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 …