BI Publisher
Discussion List
-
AR Trial Balance ReportCustomer wants a details report for AR Trial balance report. We tried but we are facing issue in opening balances. does any one have the same report. please share in thi… -
Query to get customer profile historySummary: Query to get customer profile history Content (please ensure you mask any confidential information): We have a requirement where we are enabling Credit Limit at…
-
Unable to make fields Mandatory in Customer Bank account pageUnable to make fields Mandatory in Customer Bank account page Navigation: Receivables--> Billing--> Manage Customers--> Account Number-->Payment Details-->Payment Instru…Pooja K-Oracle 47 views 3 comments 0 points Most recent by Renuka Gajavelli-Oracle Receivables & Collections
-
Which schema is recording the salesperson account information?Content (please ensure you mask any confidential information): Can anyone provide the schema or SQL query on how to check the salesperson with Revenue&Receivable&Freight… -
how to convert number in words in erpIn BIP report in cloud , we have to print one amount column in words. We have used the condition as below to convert it , but unfortunately it works upto one limit and l…RupaliGahalot 111 views 3 comments 0 points Most recent by RupaliGahalot Reporting and Analytics for ERP
-
Dunnings - How to exclude the invoices which have not yet passed the due date from the dunning letteContent Hi, In Oracle Fusion - How to exclude the invoices which have not yet passed the due date from the dunning letters for a customer? Thanks, Kanika Version 21CKanika Mahajan 93 views 2 comments 0 points Most recent by Lavanyaa Damodaran Receivables & Collections
-
Requirement to implement digital signature to one of the sub template of AR Invoice print template.Summary: Content (please ensure you mask any confidential information):We have a requirement to implement digital signature to one of the sub template of AR Invoice prin…Koka Venkatesh 41 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Looking for sql script to get Salesperson Account ReferencesWe need sql query Salesperson Account References. Anybody can help to provide the sql or related table?Guocheng-Oracle 119 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Options for logo in email body invoice (other then HTML link)Hi, We are looking for a way to put a logo in the email body of emails for receivables invoices. I started looking for options and often came across the method in which …MennovD 69 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
How to generate SAT compliant XML AR invoices for Mexico?Summary: We are doing Mexico implementation and need to know if there is any seeded way to generate compliant XML for AR invoices Content (please ensure you mask any con…
-
Do we have any Relation between Contract and Ar Invoices in Oracle fusion and primary keysDo we have any Relation between Contract and Ar Invoices in Oracle fusion and Common columns in tablesB.Anil 78 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Oracle Standard ESS Job for 'Collection Aging 4 bucket Report'Summary: We have a Business Requirement is to default few of the report parameter values in 'Custom Collections Aging 4 Bucket Report ' in ESS Job which we had customize…Abba Ravindrababu 25 views 3 comments 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
How to fetch picked_from_subinventory for a receivables invoice?Summary: How to fetch picked_from_subinventory for a receivables invoice? Content (required): We have a requirement to display all invoices shipped to a country for tax … -
SQL Query to Retrieve based on Customer ShipTo Site NumberSummary: Hi, I need SQL Query to Retrieve below data from Ship to Site Number OrigSysShipPartyId OrigSysShipPartySiteId Original System Ship-to Customer Reference Origin…Mahmoud9308 759 views 3 comments 0 points Most recent by Karun Jain-Oracle Receivables & Collections
-
how to migrate the attachment on transactions in oracle fusion from EBSSummary: How to migrate all the attachments on the transactions like (Suppliers, PR, PO, AP Invoices, Payments, AR Transaction & Receipt) from Oracle EBS to Oracle Fusio…Raoof Ahmed 187 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
What is the maximum number of lookup codes that can be defined in a common lookup?Summary: We have a requirement on custom BIP report for AR Receipts, if the report is printed again for the same receipt number then report output should have 'REPRINT' …Mayur_Gidwani 82 views 12 comments 0 points Most recent by Venkat Patlola-Oracle Receivables & Collections
-
Invoice Print Template criteriasSummary: I would like to have 2 different criteria for Invoice Print Template Content (please ensure you mask any confidential information): If I have only criteria like…usr_a.nv 37 views 6 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Customer Statement - Advise of unsuccessful emailed statementsSummary Customer Statement - Emailed - Advise of unsuccessful emailed statements requiredContent This surfaced after a training session with the client where in the ques…
-
How can we retrieve the AR Invoice PDF from UCM?Summary: How can we retrieve the AR Invoice PDF from UCM? Content (please ensure you mask any confidential information): Not Applicable Version (include the version you …Deepthi Suravaram 44 views 1 comment 0 points Most recent by Richa Priya-Oracle Receivables & Collections
-
Batch Number not in Data Extract "Funds Capture Extract"In Reports and Analytics, wE are working with "Funds Capture Authorization And Settlement Formats" standard template that use the standard " TransactionDocumentExtractDm…Pooja K-Oracle 108 views 3 comments 0 points Most recent by Oana Ciuca-Oracle Receivables & Collections
-
BI Report for Invoice in Receivables Manage Transaction PageHi Experts, Kindly if anyone knows from where in BI publisher we are able to see the template and data model used to view the invoice in Manage transaction page in Recei…Yuvraj S-Oracle 35 views 6 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
How to disable/restrict emails generated while registering contacts.Summary: How to disable/restrict the Welcome and Password reset emails generated when a contact is registered for Bill Management Content (please ensure you mask any con…
-
How to customize the data model to include disputed transactions for Strategy based dunning letters?How to customize the data model to include disputed transactions for Strategy based dunning letters? What data fields are required to be added for including the disputed…Kratika Sharma 39 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
How to include disputed transactions in score based dunning letters?I am using the seeded data model for Collections Dunning Letter template. But it does not display the disputed transactions in the list of delinquent transactions. How c…Kratika Sharma 36 views 3 comments 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Receivables Aging by General Ledger Account ReportSummary: We are developing a custom report to show us aging 13 buckets we are not able to reconcile it with the standard we are facing issues with credit memo refund pro…Shadaab Ahmed 27 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
Syntax To Pass Dynamic Parameters in Custom LOVs for ESS Jobs parametersSummary: We have created an ESS job which has 2 parameters : Business Unit, Contract Number For the Business Unit Parameter we are using the standard LOV. But for Contra…KannanM 131 views 3 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
unable to see data in IEX_BANKRUPTCIES table any standard report available?Summary: Unable to see data in IEX_BANKRUPTCIES table , is there any specific job role to view the data in this table or is there any specify bankruptcy report available…
-
Custom data model for Invoice PrintSummary: We want to print invoices for bundle items, means display only the bundle price in the invoice print. Can we have custom data model? Content (required): Version…
-
how to give user access to view invoices image from receivables UISummary: Business users are not able to see invoice image from receivables UI. But IF BI Administrator role is provided, then users are able to view image. We can't assi…
-
Trying to customize Receivables Aging by General Ledger Account ReportSummary: We want customized report output in excel format, where sheet1 should contain the parameters passed, sheet2 with detailed info in tabular format with customer a…Chowdari Malapati Monika 39 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections