BI Publisher
Discussion List
-
Why is barcodes not getting scanned in RF-Smart handheld scanner ?We have modified the standard Print Pick Slip report to add a custom template, type RTF and output PDF, and added barcodes to it with IDAutomationC128S as the font style…Prathyusha pari 85 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
How to find the BI reports that are using Excel TemplateHi, Referring to Doc ID 2990643.1, the BI reports that are using Excel Template are getting the corrupted output while scheduling it. Could anyone please let me know is …Vigneshvaran KJ 41 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
how to fetch current schedule process start time of any Oracle Fusion scheduled reportSummary: I have a requirement to fetch incremental data. I am using below query. but due to frequent transaction. Few transactions are getting picked by 2 consecutive sc…Grab.saurabh 65 views 2 comments 0 points Most recent by Grab.saurabh Reporting and Analytics for ERP
-
REST/SOAP API to get job Definition and Parameter List Oracle Fusion Cloud?Summary: We are trying to automate some job request in Oracle fusion using RPA, we got to know that there is no table as such which stored the job definition as well as …Vivek Pant 14 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
How to join 2 different tables using query builderHi Oracle Community, I m new SQL and took help of query builder to select few columns from payroll tables and would like to join with HR tables. The next few columns I, …
-
Excel Bursting issues with Payables Payment Register reportSummary: Strange behavior in custom Payables Payment Register report Content (please ensure you mask any confidential information): I have customized the seeded 'Payable…
-
Arabic text not displaying properly when generating pdf outputSummary: Arabic text not displaying properly when generating pdf output Content (please ensure you mask any confidential information): Hi Experts, In Invoice Print Templ…Venkatesan 55 views 3 comments 1 point Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP
-
Executing dynamic queryHi, We have a requirement to execute dynamic query using BIP in oracle ERP Saas and was going through this (Doc ID 2636492.1) which says passing dynamic query as paramet…JayK 21 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
General Ledger Detail Dashboard is showing 0(Zero) AmountsSummary: We have developed a Dashboard named CHRS General Ledger Detail Dashboard. In which we were using "General Ledger - Journals Real Time" and "Subledger Accounting…Narasimha Rao Kondapalli 12 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
How can I join General ledger and ExpensesHow can I join General ledger and Expenses I am precisely looking to join below tables gl_je_lines gl_ledgers exm_expense_types Much appreciate your help on this
-
How to implement FTP Bursting for Print Receivables TransactionsSummary: How to implement FTP Bursting for Print Receivables Transactions Content (please ensure you mask any confidential information): How to implement FTP Bursting fo…shrikardixit 14 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
22C PORTAL UPLOAD AS A DELIVERY METHOD FOR CUSTOMER TRANSACTIONSOracle has introduced this feature in 22C - I wanted to check if anyone has used this - I do see that delivery method LOV has a new value but I do not see where we need …Dhruvjoshi23 215 views 4 comments 0 points Most recent by Frank Meoli Reporting and Analytics for ERP -
repeate notes for each purchase orderSummary: i created a purchase order report , i have the same notes for each purchase order , when i created a template i can't adjust notes for each po. i uploaded xml f…
-
How to display the German Umlaute like, ä, ö, ß in invoice templateSummary: Unable to display the German Umlaute like, ä, ö, ß in invoice template Content (please ensure you mask any confidential information): We have a requirement for …
-
Query to fetch approver details for all pending requisitionsSummary: Query to fetch approver details for all pending requisitions Content (please ensure you mask any confidential information): We are creating a report which will …Nidhi Chhajed 305 views 13 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Oracle BIP or OTBI reports output in Non-English languages in Oracle Fusion Financials (SaaS)Summary: Oracle BIP or OTBI reports output in Non-English languages Content (required): Hi Team , We are looking for the Oracle BIP or OTBI reports output should be in H…
-
Can we do Dynamic Custom File Name in BI Publisher???Summary: We have a requirement to save XML file on the BI report custom name on output files before send the file to SFTP location. File name must have the tag sent by …Sarinee.p 414 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
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…
-
Need to create Dependent Value Sets in a Data model in oracle cloud (SAAS)Content Problem Description --------------------------------------------------- Hi Team, Is there any possibility to create a dependent value set in a Data model in orac…User_1B10X 46 views 8 comments 1 point Most recent by Britika Kumari Reporting and Analytics for ERP
-
Prepayment BalancesSummary Query for Prepayment BalancesContent Hello, We are looking to build a report that lists all current prepayments and balances, there was a Prepayments Status Repo…Elliot Hall-Walker 58 views 3 comments 0 points Most recent by Risandu olitha Reporting and Analytics for ERP
-
Etext negative number paddingSummary Etext negative number paddingContent Hi All. We have a requirement to dispay a number like -123 as -00012300. Please suggest how this is possible in Etext templa…Aditya Lanka 72 views 2 comments 2 points Most recent by YehanWithanarachchi Reporting and Analytics for ERP
-
Make every report output display date in PST timezone instead of UTC in Oracle FusionSummary: Hi Team , is there a way that you are aware of in oracle cloud that we can make the report to run in California timezone instead of default UTC timezone of clou…Abhilash K - Deloitte USI 258 views 2 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
how to use listagg function in rtf template?Summary: Requirement to display a value (output of for loop) in a single row in RTF template, as of now its displaying each value in each row. Needs to be handled in RTF…Thanigainathan R 406 views 4 comments 0 points Most recent by Thanigainathan R Reporting and Analytics for ERP
-
User Role Memberships Report - possible location in OTBI?Apart from the scheduled process, the report can be seen. Is it also possible to locate this in OTBI?
-
In Maternity Leave - Absence Type Balance is not Showing for the EmployeeSummary: Created a Maternity leave with Qualification Plan. But Absence Type Balance i am not able to see the number of balance days. -
Deliver BIP report to sharepointSummary: Ability to deliver BIP report to sharepoint seems possible, but documentation is from 2007 and doesn't seem to line up with current sharepoint screens. Content …Alex Glose 82 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Define a global function in BI reportsDear All, Is there a way to define a global function in BI reports to use it across all reports? For instance, NLS_NUMERIC_CHARACTERS?George Mattar 31 views 2 comments 0 points Most recent by Alex Kaleas Reporting and Analytics for ERP
-
List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fSummary List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fusionContent Hi, Is there any way to get the list of all the …Aman Vasishtha-Oracle 515 views 2 comments 0 points Most recent by Bill McLarty55-Oracle Reporting and Analytics for ERP
-
BIP report output with 0 KB.Summary: We have a custom BIP report with a datamodel. The data could be seen when viewed in the data tab of the DM. When the report was ran in the BIP (using the schedu…Chetan Konda 87 views 14 comments 1 point Most recent by Chetan Konda Reporting and Analytics for ERP -
ISO Format for the positive pay templateSummary ISO Format for the positive pay templateContent Hello All, We got a requirement for the positive pay in the ISO format but as of now we have only an etext seeded…Koteswararao Yenikepalli 186 views 6 comments 1 point Most recent by Ruthwij Reporting and Analytics for ERP