BI Publisher
Discussion List
-
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 11 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 36 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…
-
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 251 views 5 comments 1 point Most recent by Warren M. Receivables & Collections
-
How to build EDI format and enable for AR Transaction Invoices deliverySummary: Hi Team, What are the standard EDI formats available for AR Transaction Invoice Delivery ? How to enable EDI delivery option for AR Transaction? Content (please…Aru Chauhan 1 view 1 comment 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
What data applies to these receipt batch statuses?Specifically, what state are the following three receipt batch statuses in table "FND_LOOKUP_VALUES"? ・PENDING_APPROVAL ・PENDING_CONFIRMATION ・READY_TO_POST Thanks,REI TSUKAHAR-Oracle 12 views 2 comments 0 points Most recent by REI TSUKAHAR-Oracle Receivables & Collections
-
Configuration of Entity in Saudi ArabiaSummary: We have a requirement to prepare for configuration of a new entity in Oracle Cloud/FCCS/EPBCS in Saudi Arabia. We will have GL,CM AR, AP, FA, etc. One of the re…Tina Valtchev 21 views 1 comment 0 points Most recent by Tina Valtchev Payables, Payments & Cash Management -
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.…
-
standard lockbox sample file supported in oracle fusionSummary: Content (please ensure you mask any confidential information): Hi Team, Could you please share the sample lockbox formats that are supported like BAI , EDI823 a…Aru Chauhan 206 views 3 comments 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
How to attach different digital signature for Accounts Receivable Invoice printSummary: Require to attached digital signature in AR Invoices Content (required): Different digital signature for different Invoices. How can we attach digital signature…
-
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…
-
Is there a system variable to display running environment like DEV/UAT/PROD in BI report?Without customizing the data model is there a way to identify the running environment in the rtf template.
-
All AR transactions excluding vat and remaining balanceSummary: We need a report showing all AR transactions excluding vat and remaining balance including vat as at a date. If there is no remaining balance no need to be in t…
-
How to write SQL query to fetch the Tax value present in TransactionSummary: Needed to write SQL query to get total tax amount for a particular transaction shown in UI(please check below screenshot ) Version (include the version you are …Anoop Pillai 64 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Where can I find the create customer statements RTF to change to Logo?Summary: Good day, I am in the process of activating the create customer statements report because the Finance Team hasn't used it; However, I realize that the logo is n…
-
We need backend tables where the information stored for "Manage Collections Preferences"Summary: Hi Team, We need a backend tables where the Global preference information stored under the task "Manage Collections Preferences". Attached screenshot for your r…Opkey PA 12 views 4 comments 0 points Most recent by Kalpesh Salunke-Oracle Receivables & Collections
-
Sync process for Account Profile Start Date to Account Established Date is not workingSummary: I am trying to sync Account Profile Start Date to Account Established Date by following the below doc but it is not working: How To Sync Customer Profile Start …Rahul Kumar Gupta.-Oracle 1 view 1 comment 0 points Most recent by Rahul Kumar Gupta.-Oracle Receivables & Collections -
is there an possibility to add additional parameters to the customized seeded ESS jobSummary: Hi Team, We have requirement to customize the print receivable invoice seeded program, where we need to add additional parameters to the customized Seeded ESS j…Manoj Kumar Kande 29 views 3 comments 0 points Most recent by Manoj Kumar Kande Receivables & Collections
-
Automating Print Receivables TransactionsSummary: I am trying to automate the running of "Print Receivables Transactions" by using the "submitRequest" action of the ESS Web Service. The job is kicked off in ESS…Lee Eslick-Huff 31 views 4 comments 0 points Most recent by Lee Eslick-Huff Receivables & Collections -
The job "print bills receivables report" doesn't show any OutputThe job ends in "succeded" but the report doesn't show anything. Someone can help me?
-
Fusion: Requirement to have Invoices for UAE print in the Local Invoice amount in local languageProblem Summary --------------------------------------------------- Oracle Fusion: Requirement to have Invoices for UAE print in local language and Currency Problem Desc…
-
Customization of AR Invoices XML Outbound message not working when launching job for several invoiceSummary: Customization of AR Invoices XML Outbound message not working when launching job for several invoices Content (required): We are using UBL2.1 PEPPOL standard me…
-
How to pass current ESS Process ID as a Parameter in custom BIP reportSummary: How to pass current ESS Process ID as a Parameter in custom BIP report Content (please ensure you mask any confidential information): Hi Everyone, We have a cus…Gurujothi D 390 views 4 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
How to include attachments from the main transaction page into a custom reportHello team, greetings for the day!! I was asked to develop 'AR Payment Plan' bursting report which triggers an email consists of 3 PDF pages. out of those pages one is t…Gurupreet S 21 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
how to pass date in OICSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Data access issue with HZ_LOCATIONS tableSummary: I am trying to troubleshoot an issue with a custom BI Publisher query. The report works just fine for some users, but for other users it never finishes and time…Chris Mansfield 41 views 2 comments 0 points Most recent by Chris Mansfield Reporting & Analytics for Sales
-
Locking the Receivable Invoice Form based on DFF ValueSummary: There is a requirement where I want to lock the receivable Invoice based on the DFF value. The scenario is, If the DFF value shows the In-process status of bein…