BI Publisher
Discussion List
-
How to get text attachment information from customised "Invoice Print Report" using SQL QuerySummary: Extract text attachment on customised "Invoice Print Report" data model when run via ESS job Content (please ensure you mask any confidential information): A si… -
Bill-to-Customer Tax Registration NumberIn transactions, the 'Bill-to Customer Tax Registration Number' is stored in which table and column?Shireesha 1 view 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Duplicate of Print Receivables Transactions Report fails to reach parameter selectionSummary: I have created a duplicate of the Print Receivables Transactions Report to be able to add an additional parameter to the report. Upon duplication the process sh…
-
Third-Party Control Account Balances Report - Include Zero Amount BalancesHello, In the Third-Party Control Account Balances Report there is a parameter with name "Include Zero Amount Balances", you can select either Yes or No in this paramete… -
Customization of Create Customer Statements: Generate Log(unable to edit dataset)Summary: We have a requirement to add the receipt date and receipt number to the standard 'Create Customer Statements: Generate Log' report. We're trying to achieve this…VENKATA SWAMY BATHINA-Oracle 29 views 2 comments 0 points Most recent by VENKATA SWAMY BATHINA-Oracle Receivables & Collections
-
UNABLE TO GET THE EMAIL DELIVERY REPORT WHILE SENDING THE INVOICES TO CUSTOMER BY EMAIL BUSTINGSummary: We are currently facing a challenge with the BIP Email Bursting process used for sending invoices to customers. As part of our custom report setup, the invoices…
-
Transactions Print Data Model Lexical ReferencesSummary: Content (please ensure you mask any confidential information):In the data model Transactions Print, we added a custom line of code to the Header data set and up…Rory Mullin 1 view 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Customer needs to add a customer class parameter to "Send Dunning Letter" ESS JOB.Hi, Customer needs to add a customer class parameter to "Send Dunning Letter" ESS JOB. Can we achieve this requirement by customizing this seeded ESS job? Please suggest…Vinita.V 22 views 5 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
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…Venkateswari 106 views 9 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
Customer is looking for audit reports which they have enabled audit for business objects.Summary: Customer is looking for audit reports which they have enabled audit for business objects related to human resources product. But, the information available is n…Prasad Singamaneni-Oracle 72 views 10 comments 0 points Most recent by Chris_V Receivables & Collections
-
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 13 views 1 comment 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle 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 63 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 23 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 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 14 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 165 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 23 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 18 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 …
-
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 14 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 …