BI Publisher
Discussion List
-
ZM Report GermanySummary: ZM Report Germany- we found this content in google- Intra-Community deliveries, spendings and cross-border services, where the tax liability passes to a recipie…Madhavi Latha 23 views 3 comments 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections -
Do we have any Report giving the details of miscellaneous receipts in Oracle Fusion?What is the name of the BIP report giving providing details of the miscellaneous receipts in Oracle Fusion?KanikaMahajan 32 views 2 comments 0 points Most recent by Vivek Mandowara-Oracle Receivables & Collections
-
HELP: SQL Query from Fusion AR Transactions and Tax detailsSummary: Hi gurus! I need a query to extract the detailed data of the Transaction and the details of the Taxes calculated in the respective invoice type FUSION AR transa…Marcos G Soares 76 views 4 comments 0 points Most recent by Marcos G Soares 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…Mark Price 37 views 2 comments 0 points Most recent by Kanishka Bhardwaj-Oracle Receivables & Collections
-
Bulk Print pdf of Receivables Invoices to sftpSummary Bulk Print pdf of Receivables Invoices to sftpContent Looking for bulk extract of AR Customer invoices print version of pdfs by invoice number to sftp. Not seein…Sachin Mistry, CFA, PMP 126 views 13 comments 3 points Most recent by Tom Leeflang Receivables & Collections
-
SQL query statement to get all unaccounted transaction in AR with full GL StringSummary: Require query to extract all unaccounted transaction in AR with full GL String to review all incomplete Invoices (transactions), credit memos, and on-account cr…Rajesh_BR 103 views 1 comment 1 point Most recent by Veronica Stefan-Oracle Receivables & Collections
-
Is there a way to update/control to change file name?Summary: We wanted to know is there a way to update the default file name generated on the PDF output for the Print Receivables Transactions. Content (required): Version… -
Is it possible to restrict the users to create the AR invoice with a particular source ?Summary: Hi Team, Is it possible to restrict the users to create the AR invoice with a particular source which has type as Manual. Content (required): Is it possible to …
-
Account Receivable > Fetch "Payment Term" of a CustomerSummary: Account Receivable > Fetch "Payment Term" of a Customer Content (required): Hello All, Do you have an idea what are the physical tables to fetch the Payment Ter…
-
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… -
ESS Job - "Print Receivables Transaction" enable UCM BurstingSummary ESS Job - "Print Receivables Transaction" enable UCM BurstingContent Hi Team, We have a requirement to send Print Receivable Transaction: Invoice pdf report outp…
-
Print Receivables Transactions program not printing creditsSummary: We have a few credit memos not being picked up by 'Print Receivables Transactions': Transaction type config: Why are these not picked up? Regards, Bo Content (r…
-
Remittance Bank cash accountI have a requirement to build a custom BI report which shall report on all the segments of the cash account used at the remittance bank setup. While creating a receipt t…KanikaMahajan 2 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
AR Aging report - static results for Date Parameter passedSummary: When the report is run for a GL date that is in the past, the report should show what the application status was for the account at that GL date. For example: w…
-
Customer Address fields are not required for country USA, is this standard feature?Summary: Please see the below screen shot, none of the filed for United States address files are required, is this out of the box? do we need to customize the address fo… -
Transactions Print Data Model ParametersSummary: Content (required): I am trying to run the Transactions Print Data Model directly not via the ESS, however regardless what parameters I enter it does not return…Steve Stovell 53 views 1 comment 0 points Most recent by Siddhant Aggarwal-Oracle Receivables & Collections
-
SQL to get application url dynamicallySummary SQL to get application url dynamicallyContent Hi, Please can some one advise how to get application URL of a fusion instance using SQL? Similar to EBS, where we …Muhammad-Rizwan 18 views 3 comments 0 points Most recent by Deshin Pillay-Oracle Receivables & Collections
-
Funds Capture Batch Acknowledgments FormatsSummary Unable to find the Format to customize or to review the structure of the file formatContent Hi, we are not able to find any format listed for "Inbound" formats u…JOTHI RAMALINGAM 70 views 2 comments 1 point Most recent by mkumbhat-Oracle Receivables & Collections
-
Manually attached pdf document not merging with invoice outputOur billing department routinely puts supporting documents for billing on an invoice record as pdf attachments - when print receivable transaction runs - it appended the… -
Bill Management - DashboardsSummary: Hello, my client was wondering if it would be possible to add dashboards with infolets and external links outside the system to the external/customer view of Bi…
-
SQL-Applied ReceiptsSummary: Please share with me any SQL-Applied Receipts Content (required): Hello I was trying to do an SQL for applied receipts , however I always get duplicate records …Gabriel Kinovisques 2 views 1 comment 0 points Most recent by Dhruvjoshi23 Receivables & Collections
-
Default Revenue account for Credit Memo lines not defaulting correctlyContent Hi Would like to kindly seek help as when we are creating a credit memo, the default revenue account combination is not exactly defaulting as some of its segment…JOHANN CHRISTIAN MORDENO 2 views 2 comments 0 points Most recent by Krishna Sharma Receivables & Collections
-
Changes to bursting query in "Transactions Print Data Model" noticed in 21BSummary Changes to bursting query in "Transactions Print Data Model" noticed in 21BContent As we faced some issues with emailing invoices thru customized AR Invoice repo…Umamaheswara Reddy Karri 33 views 7 comments 2 points Most recent by Umamaheswara Reddy Karri Receivables & Collections -
AR Cash Receipt ReportingSummary: AR Cash Receipt Reporting Content (required): I am looking for information on when cash receipts are applied (and the application timestamp). Is there a subject… -
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 21C
-
Query to find amount and accounting date on AR ReceiptContent Hi Team, I thought AR_PAYMENT_SCHEDULES_ALL table holds accounting date , and amounts present on Receipt Page. However I could see few receipts who have values i…Nidhi Chhajed 23 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Receivables & Collections
-
AR Cash ReceiptsSummary Which Role gives us the access to print AR Cash Receipt Print report?Content Which Role gives us the access to print AR Cash Receipt Print report? Version 21BKanika Mahajan 17 views 1 comment 0 points Most recent by Daniel Stanislav-Oracle Receivables & Collections
-
Remove duplicate rows for AR BIP report to improve performanceContent I've created a query that pulls all AR transactions for a parameterized transaction date and matches our IBAN record in the customer with any IBAN found in the b… -
Attachment type Text loaded via REST API on AR Invoice is not visible on ReportSummary Attachment type Text loaded via REST API on AR Inv is not visible on ReportContent Hello,We are unable to see the uploaded attachment type text in the report out… -
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 20 views 2 comments 2 points Most recent by gabriel kinovisques-163562 Receivables & Collections