BI Publisher
Discussion List
-
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 61 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 4 views 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 22 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 33 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 350 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…
-
How to schedule ESS job report with period parameterI have a report that runs on period parameter requirement is this report is to be scheduled and while getting scheduled it should consider the date of schedule as period…
-
Run report REST API for Oracle BI PublisherSummary: I'm trying to run a BI report and get the output via this REST API: /services/rest/v1/reports/{reportPath}/run I tried running it but is getting 404 not found e…JEngalan 143 views 1 comment 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
How to remove extra line before the contents for column note_txt.Summary: Hi Team, I am working on AR aging report in which we have developed query to extract collector notes. We are referring note_txt column from zmm_notes table. But…
-
Has anyone ever had a problem with if@inline in rtf?Has anyone ever had a problem with if@inline in rtf which perhaps solves the problem of no longer going to line but no longer reading the :string-length> 0?
-
Receivable Invoice Report returns nullHi, When I ran the query it returns no rows -
Philippines Statutory Report - Cash Disbursement JournalSummary: Philippines Statutory Report - Cash Disbursement Journal Content (please ensure you mask any confidential information): Hi, We are trying to get the details on …D Mandal 51 views 4 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Tax & Global
-
How to send output's for Import AutoInvoice(Execution Report) over email to usersSummary: we have a requirement to send output's for Import AutoInvoice(Execution Report) over email to users. Content (required): we have a requirement to send output's …User_FVJ8C 81 views 5 comments 1 point Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
AR Receipt accounting details query in oracle fusionSummary: does anyone have query for AR Receipt accounting details? Wanted query for getting Receipt number, account(gl code combination value), class, Credit amt, Debit …Sanmati Patil-Oracle 1.1K views 2 comments 0 points Most recent by Deepak Singal Receivables & Collections
-
How to record more than 350 Character in DFF fusion AR Cloud ?Summary How to record more than 350 Character in DFF fusion AR Cloud ?Content Hello This is the business requirement , we need to store QR code string in DFF which is gr…gabriel kinovisques-163562 49 views 4 comments 2 points Most recent by User_F7IX4 Receivables & Collections
-
Hi , how do we seperate the invoice and the supporting attachments in Print Receivables TransactionsSummary: Client would like the email sent out to the customer to have seperate files for the invoice and the supporting attachments in Oracle Fusion. The client is curre…GHT 11 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Collections Aging by Collector 7 Bucket ReportSummary: I am having to customize the "Collections Aging by Collector 7 Bucket Report" to add a DFF (Attribute) from the Invoices table (ra_csutomer_trx_all). The DFF va…Arun MK 21 views 2 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
Customize ESS Print Receivables Transactions to restrict Transactions to be pickedSummary: We have a requirement to restrict the ESS Print Receivables Transactions job to not to pick a Transaction if a DFF(Header level) is having 'Pending' value. Plea…Kalyani-Oracle 1 view 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Getting corrupt XLS output for more than 100KB output.Summary: Report Name : AR Debtor Aging Report - MIRA Real estate.xdo Report Path : /shared/Custom/Transactional Reporting/Receivables/BI Publisher/Debtor Aging Template …Soare Oldrich Alexandru-Oracle 11 views 0 comments 1 point Started by Soare Oldrich Alexandru-Oracle Reporting and Analytics for ERP
-
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 121 views 4 comments 0 points Most recent by Daniel_Spritzer Payables, Payments & Cash Management
-
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 1 comment 2 points Most recent by Marx Rivera-Oracle Payables, Payments & Cash Management
-
Can we extract the milisecond from sysdate in ETEXT TemplateSummary: Hi All I have a requirement to extract the milisecond value from sysdate in ETEXT Template Content (please ensure you mask any confidential information): Versio…