BI Publisher
Discussion List
-
Unable to get the Ar receipt statusSummary: We are developing the OTBI Report, unable to fetch the Receipt status. Instead we are getting the application status. Content (required): Version (include the v… -
Need query for notes created on transaction level and customer level at collections dashboardSummary: Need query for notes created on transaction level and customer level at collections dashboard Content (required): following query only return notes at transacti…
-
What is logic to derive Recommended City and County for given Postal code creating Customer LocationSummary: What is logic to derive Recommended City and County for given Postal code creating Customer Location when there multiple combination of city-County for particul…Vinuth1 31 views 1 comment 0 points Most recent by Kalai Palanisamy-Oracle Payroll and Global Payroll Interface (GPI) -
Customization of Collections Aging by Collector 7 Bucket ReportSummary:- I am customizing Oracle fusion seeded report "Collections Aging by Collector 7 Bucket Report" In which I Need to add Invoice_date in this report as one column.…Shraddhha Namde 265 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Need the 8 seeded Receivables Bill Presentment Templates in Reports and AnalyticsSummary: How can I get the seeded Receivables Bill Presentment Templates? They were overwritten with customized versions in our environment so I cannot get them from Rep…Carol Fergusson 52 views 4 comments 0 points Most recent by Carol Fergusson Receivables & Collections
-
Query for unearned revenue in oracle fusion from RA_CUST_TRX_LINE_GL_DIST_ALL tableSummary: we have Oracle fusion cloud services and we need to develop a report for unearned revenue how Can I identify the unearned revenue from RA_CUST_TRX_LINE_GL_DIST_…Shameer Muhammed P M 488 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
How to Customize Dispute Approval Workflow NotificationSummary: Need to display more data / attributes on dispute approval workflow notification. Content (required): Need to know the data model and template that is being use…
-
AR - Is it possible to print the invoices with Portal upload invoicing Delivery method?Summary: We need to print the invoices when we setup the invoicing delivery method as Portal Upload Content (required): The Print Receivables Transactions process exclud…SathyaKannan 107 views 1 comment 0 points Most recent by Vitalie Rusanovschi-Oracle Receivables & Collections
-
Access BU in BIP based on UI RolesSummary: I have a client who has requested a specific functionality for displaying Business Unit (BU) names in the Business Intelligence Publisher (BIP) List of Values (…
-
How to create the seeded AR Receivable Template ?Summary: How to create the seeded AR Receivable Template ? Content (required): Hello We have customize the AR seeded template , but it seems is not working when the user…Cesar Saveedra 63 views 3 comments 0 points Most recent by Andreea Laura Panait-Oracle 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 209 views 9 comments 2 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
Disable online Output view for BIP reportsSummary: Disable online view for BIP reports Content (required): We are trying to restrict the online view of outputs in BIP. We don't find any suitable report option fo…SayanDutta 123 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
REST - API for AR InvoiceSummary: We have a requirement to populate BILLING_PERIOD_START_DATE and BILLING_PERIOD_END_DATE in the AR lines level while creating AR invoice with REST API. Is there …Sam Samaddar 48 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
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…
-
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?KanikaGupta 42 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 5.7K views 4 comments 0 points Most recent by Marcos G Soares 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 2.4K 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…
-
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…KanikaGupta 21 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
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…
-
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 355 views 3 comments 0 points Most recent by Deshin Pillay-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… -
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 …martingabriel Kinovisques 71 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…User_2025-02-11-12-30-38-982 44 views 2 comments 0 points Most recent by User_2025-02-05-00-10-05-674 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… -
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 2.3K views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Receivables & Collections