BI Publisher
Discussion List
-
Receivables Aging by General Ledger Account ReportSummary: We are trying to develop a new custom aging report as to ease the reconciliation and make some custom column but we are not able to match the report with the st…Shadaab Ahmed 21 views 1 comment 0 points Most recent by Veronica Stefan-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 21 views 1 comment 0 points Most recent by Veronica Stefan-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 28 views 2 comments 0 points Most recent by Abba Ravindrababu Receivables & Collections
-
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 13 views 2 comments 0 points Most recent by Neeraj Pandey-Oracle Payables, Payments & Cash Management
-
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…
-
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 0 comments 0 points Started by Saber El hadigui Payables, Payments & Cash Management
-
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…
-
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 23 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…Kapil_Bohra_2023 75 views 8 comments 0 points Most recent by Rupa Rane-Oracle Receivables & Collections
-
Swiss QR-Bill on customer invoicesSummary: Oracle EBS R12.1.3 We need to print Swiss QR code on invoices sending to customer as Swiss QR Bill requirements. I did not find any solution in Oracle for this.…
-
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 34 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
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…
-
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 to implement digital signatureSummary: Hi Content (required): We need to implement digital signature on Invoice print pdf generating through BI Report. According to Oracle Docs, This will be only pos…Heena 43 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Receivables Aging by General Ledger Account Report - Group by Natural Account segmentRequirement is to group Receivables transactions in "Receivables Aging by General Ledger Account Report" by Natural Account segment only, not by alll Chart of Account di…
-
How do you add a parameter to a seeded data modelSummary: How do you add a new parameter to a seeded data model? Content (please ensure you mask any confidential information): Version (include the version you are using…CarmenR. 13 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
What Table is the Miscellaneous Receipt Distribution Comment located in?Summary: I am trying to get the comments entered on our Misc Receipt Distributions to come through in an Analysis or Report. Content (please ensure you mask any confiden…
-
Is the IEX_DELINQUENCIES table deprecated?Summary: Hi, I have noticed that the IEX_DELINQUENCIES table is always empty when running the "SELECT * FROM IEX_DELINQUENCIES" query from a BI publisher report, somethi…
-
Deeplink for RA Transaction Attachment directlySummary: Per one integration flow, we uploaded an attachment with a specific naming convention to RA CUSTOMER TRX. I am looking for a deep link or any URL that can downl…sailesh_cloudare 23 views 5 comments 0 points Most recent by Andreea Laura Panait-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 …
-
Transmit invoices with portal upload as preferred delivery methodSummary: I have setup customer site profile preferred delivery method to "portal upload". We have some client invoices that need to be uploaded into a client portal in a…Raj Mohanraju FRNT 23 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Edit Print Receivables Transactions ESS Job parameterSummary: Edit Print Receivables Transactions ESS Job parameter Content (required): I would like to be able to edit the Default 'Invoice Template Name' in the 'Print Rece…
-
Dunning PDF emailed to external address from P2T CloneSummary: Dunning PDF emailed to external address from P2T Clone Content (required): As part of Post Clone steps on a new P2T clone, the following areas are updated, we t…
-
how to create custom dependent parameters for ESS jobwe have requirement to create dependent parameters for ESS jobs. we are creating custom LOV's using SQL query. need to use custom LOV's for parameters.chandrakanth makam-Oracle 13 views 2 comments 1 point Most recent by chandrakanth makam-Oracle Receivables & Collections
-
How to add Cust Account and Cust Site Info to 'Receivables Aging by General Ledger Account Report.Summary: How to add Cust Account and Cust Site Info to 'Receivables Aging by General Ledger Account Report. Content (required): Problem Description ---------------------…Angshuman Mitra 23 views 2 comments 0 points Most recent by Angshuman Mitra Receivables & Collections
-
Is it possible to FTP the Create customer statement report output?Hi, We have client requirement to send the Create customer statement report output to FTP location when delivery flag for a customer is PRINT. I have modified the bursti…Babasaheb Bhujbal 41 views 3 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
How to get the bank account assigned to a party siteSummary: We need to list all bank accounts being used by sa party site. Bank accounts that we can see when we navigate to Manage Suppliers page Content (required): We ar…
-
Security feature for AR invoice print options available in view image button of transactionsWe have enabled password protection on AR invoice. When we using download button to save the AR invoice security feature is working as expected, But some of user using s…Siva Gollapalle 43 views 7 comments 0 points Most recent by Daniel S.-Oracle Receivables & Collections