BI Publisher
Discussion List
-
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 312 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 439 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 261 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 411 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 86 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 511 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 95 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 184 views 6 comments 1 point Most recent by Ruthwij Reporting and Analytics for ERP -
Varalakshmi 31 views 4 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Segment value Security tableSummary: Need a table that stores values stored in Segment Value Security (SVS) Rules. Content (required): Table fnd_object_instance_sets stores the value in FILTER colu…
-
Joining Subledger data with GL dataI need to build a query which joins subledger data table, xla_ae_lines to gl_je_lines. I am attempting this through gl_sl_link_id but the performance is awful, is there …
-
Italian AR E-Invoicing ProgressivoInvio NumberHi, As per Italian reporting requirement we are developing Italian AR E-Invoicing report with XML output. We have a tag called 'ProgressivoInvio', as per the customer re…
-
Performance impact while using standard viewsSummary: Is there any performance impact while using the standard views (in a BIP report) listed by Oracle. For eg. using standard view PJF_PROJECTS_ALL_VL, instead of t…
-
How to get the IP address of OTBI to add to a SFTP whitelistI am trying to get my OTBI environments IP address so I can whitelist it on a SFTP site. I found documentation on all the IP address, but I don't know which server I am …NicolaosDerr 101 views 2 comments 0 points Most recent by NicolaosDerr Reporting and Analytics for ERP
-
BIP Global Level Function Data not getting included in output after bursting.Summary Aggregate functions data show's up at report level which are involved in GLOBAL Level functions, but the same Data attributes wont show up, if we burst the file.…Kishan Dhongadi 194 views 9 comments 1 point Most recent by HarshithDarla Reporting and Analytics for ERP
-
Unable to view the data in data model with lexical parameterSummary: Unable to view the data in data model with lexical parameter Content (please ensure you mask any confidential information): Hi, We are trying to create a BI rep…JithendraKCV 31 views 1 comment 0 points Most recent by JithendraKCV Reporting and Analytics for ERP
-
Generate blank BIP reportHi Team, We have a BIP report in Oracle fusion that has a bursting code. This works fine when there is data for report. However, if no data is returned by the underlying…Prabhjeet Kaur 342 views 5 comments 0 points Most recent by Cm Adil Ch Reporting and Analytics for ERP
-
How to extact segment 2 from code_Combination_description in my xml fileSummary: How to extact segment 2 from code_Combination_description in my xml file Content (please ensure you mask any confidential information): My xml stores the code c…
-
Using OR with IF statement in rtf template is not working as expectedSummary: Using OR with IF statement in rtf template is not working as expected Content (please ensure you mask any confidential information): I have a requirement for my…
-
How to go up from JELINE_ROW to CCID_S in my xml on my rtf templateSummary: Going up a level or two of my xml on my rtf template Content (please ensure you mask any confidential information): I have customised the Account Analysis rtf. …
-
Subject Area to capture Employee detailsSummary: Content (required): Hi, Can someone please let me know the subject area to be used if the requirement is to capture the username, employee first name, employee …Sheneli98 997 views 12 comments 1 point Most recent by Nareshbabu Mallela Reporting and Analytics for ERP