BI Publisher
Discussion List
-
Query for recepit method in AR transactionI want to display trx_number and the receipt method used in this transaction. Someone knows the query?ACNROMA2023 21 views 3 comments 0 points Most recent by Raghuram Saradka-Oracle Receivables & Collections -
We need a query to retrieve the AR remittance batch approver's name and approval dateHi, We have arequirement to retrieve the approver name and approval date for a remittancebatch. Could you please confirm if there’s an existing table, column, or queryth…
-
During the Merge process, where the impacted Transactions are getting stored?Hi, We have an option to merge one customer (ABC) with another (XYZ). After the Customer Merge Process, the Merged customer (XYZ) is reflected in the already created tra…
-
Send Dunning Letters log says contact information is missing for customer, we require SQL queries.Summary: Send Dunning Letters log says contact information is missing for customer; we require SQL queries to create custom report to add these error detail of the custo…
-
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…
-
Receivables Aging by General Ledger Account Report - seeded Datamodel not workingSummary: I have been able to customize the Receivables Aging by General Ledger Account Report to be more usefull, by using the seeded datamodel and creating a new report…Anders W. Langholm 21 views 7 comments 0 points Most recent by Tyrion Lannister Receivables & Collections -
Support Incremental is not enabling for BICC extractSummary: Hi Team, we are using application composer custom objects and looks like supports incremental is not getting enabled to this like it happen for seeded ones. Can…PrasadN 41 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to use if statement for comparing dates in BIP templateSummary: How to use if statement for comparing dates in BIP template Content (please ensure you mask any confidential information): I have customised the Customer Statem…Chez 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Is there any predefined report showing customer wise trial balance ReportSummary: user requires Customer wise trial balance as well as Receivable balances customer wise. Do we have any predefined report? Content (please ensure you mask any co…Jeetesh Singh 21 views 1 comment 0 points Most recent by Sairam Surampalli-Support-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…
-
How INTERFACE_HEADER_ATTRIBUTE2 to INTERFACE_HEADER_ATTRIBUTE6 RA_CUSTOMER_TRX_ALL from SubscriptionSummary: Need help in understanding how DFF Fields INTERFACE_HEADER_ATTRIBUTE2 to INTERFACE_HEADER_ATTRIBUTE6 in RA_CUSTOMER_TRX_ALL Table populated for transactions hav…
-
How can we get attachment to a BI report to be send through e-mail?Summary: Send attachment which is on invoice as part of email with the BI report over email through schedule Report Content (please ensure you mask any confidential info…
-
Program "Print Receivables Transactions" is completing with errorWe have a requirement to deliver the consolidated output to customer if he has multiple invoices which are eligible to print. We have changed the bursting key to achieve…ramesh.daniyala.mcd 92 views 2 comments 0 points Most recent by ramesh.daniyala.mcd Receivables & Collections
-
Print receivables program does not pick specific credit memo template?Summary: We have multiple Credit memo templates specific to each BU, the Print receivables program does not pick specific credit memo template. eg. Germany has a custom …
-
Does it mandatory to configure the mail server for dunning letter?Hi All, Does it mandatory to configure the mail server for dunning letter? Can we not use the oracle.com server, It works for invoice print and customers statement. Than…Gotham 1 view 1 comment 0 points Most recent by Sairam Surampalli-Support-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 ---------------------…
-
Table to see RA_INTERFACE_LINES attributesI popoluted the DFF in RA_INTERFACE_LINES, and I need to view them in a query, in join with ra_customer_trx_all. Which tables stored information about interface_line_att…ACNROMA2023 11 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
BIP internal bank account table?Hi Guys When I search online I get told to use view CE_INTERNAL_BANK_ACCOUNTS_V to lookup field INTERNAL_BANK_ACCOUNT_ID out of table iby_pay_service_requests. However w…
-
CCC IMPL BICC Not Showing all FieldsSummary: Hi Team, We have application composer object created and it included number fields like ( Account Number, Site Number) looks like only id's are showing up in th…
-
How to integrate the SCANOVA QR api to generate the QR code in AR Invoice BI Template?Summary: Dear All, We are using SCANOVA api to generate the SWISS specific QR code with all the necessary information and it is working well in the POC. When we are addi…Pushpal 11 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
jg_zz_vat_rep_status join with transactions tableI need to join the tables jg_zz_vat_rep_status or jg_zz_vat_rep_entities with AR transactions tables. the query is: select CASE when count(DEFAULT_SET_CODE) > 0 then 'NO…ACNROMA2023 11 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Customer invoice to get attached to invoice page after e-invoicingSummary: Invoice Print should be attached on invoice work area. There should be some schedule process which we can run and invoice print gets saved on the billing work a…Jeetesh Singh 2 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Ho do i add PO number to the 'Receivables Aging by General Ledger Account Report'Summary: Need to Add PO Number detail in 'Receivables Aging by General Ledger Account Report'. For that we are trying to customize the same for that but as the main quer…Kasi Eswari 21 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
How to extract ship to customer and ship to site name?Hi, How to extract ship to customer and ship to site in a receivables table? We only found id. Thanks, Regards
-
Unapplied receipts dashboardSummary: We have a customer who is experiencing a challenge with the AR unapplied receipts dashboard, it displays unapplied credits but does not display credits that are…Maria Smith- de Novo Solutions 14 views 2 comments 0 points Most recent by Maria Smith- de Novo Solutions Receivables & Collections
-
Query to get Rejected Expense Details in which need exact columns where Comments will be storeHi Team, We have built a Integration to perform the Expense operations like Approve, Reject, Request_Info. Need table where I can see the data for Rejected Expenses Comm…
-
In which table is stored the info that a vat register is finalized?we need the oracle cloud name of the table in Receivables, that store the infoACNROMA2023 21 views 4 comments 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Is it possible to use FBDI for adding some sites to an exiting customer?We created a customer but we need to add many sites to him, so we are thinking about using FBDI, but is it possibile for an existing customer to use FBDI just for create…
-
Need changes in Print Receivable Job to print invoice without customer bill to email contactSummary: currently Print receivable invoices job is not picking the invoice where bill to customer email contact is not present. we are getting below error. PRINT_INVOIC…Raj Jain-Oracle 31 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
How to create consolidated AR invoices based on Order Types or Invoice rules in oracle fusionSummary: Do we have details available on what are the options available to consolidate Oracle AR Invoice in Fusion ? Business doesn't want use Bills Forward billing feat…