BI Publisher
Discussion List
-
REST API for Receivable Invoices (CM/DM/ONACC)Summary: Hi Team I am looking for API to get the details of Credit Memo, Debit Memo and On Account Invoices. I am not able to get those data when using /resources/latest…sailesh_cloudare 81 views 3 comments 0 points Most recent by Daniel S.-Oracle Receivables & Collections -
From what basis data's are populating to AR_STATEMENT_DELIVERY TableSummary: From what basis data's are populating to AR_STATEMENT_DELIVERY Table Content (required): Version (include the version you are using, if applicable): Code Snippe…CJPandian 61 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
What are the standard reports available for Brazil localization?Summary: We wanted to know if Brazil tax is implemented through a tax partner in Oracle, then what are the monthly tax compliance reports readily available to use? Conte…
-
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 271 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 51 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 483 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 101 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 62 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 234 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 121 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 42 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 41 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 357 views 3 comments 0 points Most recent by Deshin Pillay-Oracle Receivables & Collections