BI Publisher
Discussion List
-
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 26 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 9 views 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 18 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 184 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 15 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 28 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 26 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 15 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 26 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 15 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 37 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 16 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 28 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 6 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
how to default invoice template on collection dashboard preview screenIn collection dashboard when you select customer delinquency there is option of preview, when i click on preview it;s picking INFUSION default template . How to default …charanjeet 7 views 1 comment 0 points Most recent by Vitalie Rusanovschi-Oracle Receivables & Collections
-
Condition to display active customer accounts/sites in Customers extract OTBI ReportSummary: Hi, We used subject area named "Receivables- Customer real time" to create an OTBI to extract customer master. however, we couldn't find a column in any folder …
-
Please let us know how we can add the Attachment column in an OTBI report for ReceivablesSummary: Please let us know how we can add the Attachment column in an OTBI report for Receivables subject area, prefarably Receivables- Real Time Transaction subject ar…