BI Publisher
Discussion List
-
How to send output's for Import AutoInvoice(Execution Report) over email to usersSummary: we have a requirement to send output's for Import AutoInvoice(Execution Report) over email to users. Content (required): we have a requirement to send output's …User_FVJ8C 81 views 5 comments 1 point Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections -
AR Receipt accounting details query in oracle fusionSummary: does anyone have query for AR Receipt accounting details? Wanted query for getting Receipt number, account(gl code combination value), class, Credit amt, Debit …Sanmati Patil-Oracle 1.2K views 2 comments 0 points Most recent by Deepak Singal Receivables & Collections
-
How to record more than 350 Character in DFF fusion AR Cloud ?Summary How to record more than 350 Character in DFF fusion AR Cloud ?Content Hello This is the business requirement , we need to store QR code string in DFF which is gr…gabriel kinovisques-163562 53 views 4 comments 2 points Most recent by User_F7IX4 Receivables & Collections
-
Hi , how do we seperate the invoice and the supporting attachments in Print Receivables TransactionsSummary: Client would like the email sent out to the customer to have seperate files for the invoice and the supporting attachments in Oracle Fusion. The client is curre…GHT 11 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Collections Aging by Collector 7 Bucket ReportSummary: I am having to customize the "Collections Aging by Collector 7 Bucket Report" to add a DFF (Attribute) from the Invoices table (ra_csutomer_trx_all). The DFF va…Arun MK 22 views 2 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
Customize ESS Print Receivables Transactions to restrict Transactions to be pickedSummary: We have a requirement to restrict the ESS Print Receivables Transactions job to not to pick a Transaction if a DFF(Header level) is having 'Pending' value. Plea…Kalyani-Oracle 1 view 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Getting corrupt XLS output for more than 100KB output.Summary: Report Name : AR Debtor Aging Report - MIRA Real estate.xdo Report Path : /shared/Custom/Transactional Reporting/Receivables/BI Publisher/Debtor Aging Template …Soare Oldrich Alexandru-Oracle 11 views 0 comments 1 point Started by Soare Oldrich Alexandru-Oracle Reporting and Analytics for ERP
-
Logic for Supplier Balance Aging ReportI want to know the logic behind the calculations of the columns - unpaid amount, buckets, aging amounts and unallocated amounts in the seeded Program - Supplier Balance …Priyal Pareek 121 views 4 comments 0 points Most recent by Daniel_Spritzer Payables, Payments & Cash Management
-
Electronic Invoice for Spanish Public AdministrationsHello, The customer must issue invoice to the Spanish Public Administration. The Spanish Public Administrations only receive invoice of a specific xml format, with an el…Saber El hadigui 11 views 1 comment 2 points Most recent by Marx Rivera-Oracle Payables, Payments & Cash Management
-
Can we extract the milisecond from sysdate in ETEXT TemplateSummary: Hi All I have a requirement to extract the milisecond value from sysdate in ETEXT Template Content (please ensure you mask any confidential information): Versio…
-
Any Customer Hierarchy Balance ReportsSummary: We have a requirement for Customer Hierarchy Balance report which shows balances based on the customer Hierarchy definition in manage Hierarchies. We have 3 lev…Mohan Terli 31 views 1 comment 1 point Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
Ability to run “Print Receivables Transactions” program based on “real” from/to print dateSummary: Usecase: We usually re-printed some transactions when our customers request a copy of the initial printed transactions with a label saying that it is the exact …
-
Run BIP report callbackSummary: Decouple OIC integrations retrieving data via BIP report with callback Content (please ensure you mask any confidential information): We would like to increase …
-
Customize the output of Export Golden Tax Transactions for China ESS JobSummary: We are implementing Golden Tax for China. As part of that requirement we would like to customize the output of the ESS Job "Export Golden Tax Transactions for C… -
SQL Select Query to Oracle SaaS TablesSummary Aside from OTBI, BIP or BI Analysis - is there another way to query-select SaaS Tables? Like an Oracle-provided Tool or 3rd Party ApplicationContent Hello, Aside… -
Need Underline Table Information for "Review Customer Account Details" Data from Fusion.Summary: Need the table details (or any code snippet if available) to get amount/transaction due for a particular customer. Path: Fusion --> Receivables --> Billing --> …Abhijit Sahu-Oracle 143 views 7 comments 0 points Most recent by User_K1U5X Receivables & Collections -
Print Receivable Transactions custom template is not showing for Credit MemosSummary: Print Receivable Transactions custom template is not showing for Credit Memos Content (please ensure you mask any confidential information): Hi All, We customiz…
-
Error while running Receivables Aging by General Ledger Account Report; permission: 16578Summary: We created a custom role for users to view Receivables transactions and run various AR reports. When the user attempts to run the Receivables Aging by General L…hannah_barry 95 views 3 comments 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Customised Create Customer Statements for multiple templatesSummary: Customised AR Customer Statements for multiple templates Content (required): The requirement is for the Customer Statement to print the correct logo based upon …
-
Working of CreditCheckingService SOAP WebserviceSummary: Working of CreditCheckingService SOAP Webservice Content (please ensure you mask any confidential information): Hello Team, We would like to know how the Availa…Atul_Ghd 11 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Invoice Print Template can be edit or not and how it is mapped with applicationHi All, We would like to know how the Invoice Print Template is mapped with the application Can we edit the Invoice Print Template ( Add or Remove the fields) Can we cre…
-
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 43 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 94 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 86 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 31 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 93 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 61 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections