Category 67
Discussion List
-
Translation of Performance Document Reports RTF Templates to other languagesHi Team, Kindly suggest a best approach or is it feasible on how we can translate an English language Performance Document Worker Ratings Report RTF template & Performan… -
Learning DashboardDoes anyone have a template for Learning Dashboards in OTBI? -
BIP Letter Templates and ImagesHi all, I've created a simple data model that allows an end user to run a self service report where they input the employee number and it generates a semi complete lette…
-
How to extract only employee's current grade step using BI publisher?How to extract only the last grade using BI publisher? I tried to filter on EFFECTIVE_LATEST_CHANGE, EFFECTIVE_SEQUENCE and ASSIGNMENT_SEQUENCE, but it is the same recor…Cindy Mavioga Malaga 1 view 1 comment 0 points Most recent by Cindy Mavioga Malaga BI Publisher Learning Center
-
query to get the tax liability account of the tax rateHi, Could you please advise in which SQL table can I find the natural account of the tax rate. Setup and Maintenance → Financials → Manage Tax Rates and Tax -Recovery Ra…Elyse Meouchi 133 views 1 comment 1 point Most recent by Ken Kramer-Oracle Tax Reporting (Direct Tax)
-
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 1 view 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 1.2K 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 sqlSravan Kumar Meka 1 view 0 comments 0 points Started by Sravan Kumar Meka BI Publisher Learning Center
-
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 119 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 34 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.3K 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…