Category 67
Discussion List
-
can we use the regexp_replace function in a xsl bi publisher template?I'm trying to use the regexp_replace function in my xsl template to replace special characters and I receive an error. Is the regexp_replace supported by the xsl templat… -
How to remove decimal value in BAR CHART - RTF Template - BIP Report?Decimal value is displayed in the Bar chart of RTF Template - BI Report. How to remove decimal values in the chart?SARAVANA KUMAR T-Oracle 3 views 0 comments 0 points Started by SARAVANA KUMAR T-Oracle BI Publisher Learning Center
-
Is There an way to Default BI report Text parameter to logged in user person id like in Date typeIs There an way to Default BI report parameter to logged in user person id like we default System data in Date type parameter {$SYSDATE()$}. We have a Text parameter whi…
-
How to find redline change data in the OBI tablesHi Experts/Team, Is there any OBI table that stores if any attribute is redlined on a change order, redline information i'm looking for a specific attribute is redlined …
-
Issue with .xlsx formatWhen scheduling a report and then the report is sent to the manager, manager cannot receive it because report cannot be sent. Could it be that .xlsx option is not suppor… -
How to pivot to display questions horizontally as the heading using answers instead of measureI wish to create a table of questions as the horizontal headings (dynamic from data) and the users as the vertical with the answers in the data section. Pivoting appears… -
How to display a 2nd signature based on Check AmountHi, we have a requirement to print a second signature on a check when the check amount exceeds a threshold e.g., $25,000. We have created our RTF template with one stati…
-
List of Values SQL query with multiple columnsHello - I want to know if it is possible to use a List of Values object (with a Parameter) and select 2 columns in the LOV query, and then display one column for the End…
-
AR Aging Report Issues in BI PublisherHi everyone, I'm hoping to get some help with an AR Aging Report built in BI Publisher. I inherited this report from someone else, and I'm facing two issues: Missing Cus…
-
query to get the due date in payment under invoices to payHi, Could you please advise in which SQL table can I find the Due Date in Payables → Payments → Create Payment under Invoices to Pay. Thank you.Elyse Meouchi 1K views 2 comments 0 points Most recent by Stephen Westerfield-Oracle BI Publisher Learning Center
-
how to Retrieve the GUID of a row (global unique identifier ) using SQL ,not RESTsome apis require the GUID to update a record , not the id or rowid We can retrieve that value using REST api (/fscmRestApi/resources/11.13.18.05/invoices/1/child/invoic…
-
Initial cap/upper case in BIP report RTFSeeded report column value is like 'ANNUAL' .I want to display the value as 'Annual' which is in Init cap format without having to modify the seeded XML. How to do that …
-
fr studio indentation issue after export to excelAfter Patch our Prod Fr studio indentation changed only when export to excel. Html indentation looks great. Other instance have no issues with the export indentation. *R…
-
Query to get the tax name and rate from a draft invoice under contractI need to retrieve the tax name and tax rate applied on the draft invoice (without calculating it manually) under contract management. In the tables pjb_inv_line_dists a…
-
Audit Report BI Publisher does not show folder informationHello! I would need some help with Audit Report from BI Publisher. It is assumed that it is not showing the information of all the operations performed at the folder lev…
-
combine or overlapping to different sub templates in a main templatehow can we achieve combine or overlapping to different sub templates in a main template of rtf and output to be in html -
How to retrieve asset category base rate for previous month & current month using sqlRetrieve asset category base rate for previous month & current month using sql
-
BI Publisher Report- Learning Initiatives including Course number and Title-LearningHello All, I have the SQL code that fetches the learning initiative number, name, Course Number, and Title, but I have found duplicate rows because the Course titles do …Thulasi Ram 113 views 8 comments 0 points Most recent by Soare Oldrich Alexandru-Oracle BI Publisher Learning Center -
Oracle Fusion Application MT Timezone is not reflecting sometimes in OTBI ReportsHi Everyone, I have set the timezone in oracle fusion application as UTC-07:00 Denver - Mountain Time (MT) and now when I am creating an OTBI analysis and using Now() fu…Himansh Agarwal 31 views 0 comments 0 points Started by Himansh Agarwal BI Publisher Learning Center
-
Bi Reporting Error #221When attempting to open our organisation structure report we are being hit with an error as shown in the screenshot attached. This error is occurring when initially tryi…
-
Can we Use .XLS template with Excel Macro enabledHi Team, Is it possible to utilize a BIP .xls template that has a macro embedded into it? Our User requirement is to have a Macro in excel template a user can run on the…
-
Use .XLS template with Excel MacroIs it possible to utilize a BIP .xls template that has a macro embedded into it? If so, are there any examples that can be shared with me? I am not sure how to apply for…
-
How to find the sum total of an element for all the groups in rtf template?Hi, I am working on an RTF template for Oracle BI Publisher and I am trying to get the total sum of amount for all the groups in the template. The scenario is there are …Kratika Sharma 1.1K views 0 comments 0 points Started by Kratika Sharma BI Publisher Learning Center
-
How to group rows based on one column and then find the sum for each group?Hi, I am working on a rtf template where it is required to group the records based on the tax code value. Now I want to show the sum of amount for each tax code in diffe…
-
BIP report Group data need to be show in message bodyI want to send a report to each manager with the employee details. Employee details should show in message body instead of attachement. Please let me know, how to do tha…
-
Need Oracle BI accountHi Team, We have registered as a Oracle Partner. We need Oracle BI reports account for creating and accessing data in it. Please provide us access to the account. Thanks…
-
HCM Extract attribute back end QueryHi All, We need your help in finding out the Actual query being used in the back end of Attribute in HCM Extract. We built a HCM Extract with data group using the user e…
-
query for receivables receiptsI wrote the query of receipts, but I need the receipt date, I think it's in the table AR_CASH_RECEIPT_ALL but I don't know how to join with the others. Can anyone help m…
-
how to select correction record from data?Hello everyone How to select by SQL query records of elements whose value was changed not by UPDATE but by CORRECT, is it in the HRC_EVT_OBJ_CHANGE_COMPONENTS table? or …
-
How to create from and to date parameter without default and mandatory fileHow to create from and to date parameter without default and mandatory file in BI PublisherRitika.ray-Oracle 21 views 7 comments 0 points Most recent by MandeepGupta BI Publisher Learning Center