To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Attach Custom List of Value to ESS JobSummary Custom List of Value to ESS JobContent Hi Experts, I have two questions pertaining to ESS jobs and are as follows:- 1) How can I attach a custom list of value to…
-
Enable All or Multiple selections from a Pivot Table prompt in OTBISummary The Pivot Table prompt should allow the selection of all or multiple items.Content We have a requirement to allow the selection of All or multiple items from the…
-
Tracking ESS Jobs ScheduleSummary Tracking ESS Jobs ScheduleContent Hi, We are on R12. We have scheduled some ESS jobs and found that some of the jobs were failing often (for various valid reason…
-
Schedule Report to monitor ESS Job StatusSummary Customer is required to monitor ESS job status and is looking for a way to automate the monitoring process through the use of a report that can be scheduled or e…
-
Anyone has query to link PPM projects with GL in fusion?Summary Anyone has query to link PPM projects with GL in fusion?Content Anyone has query to link PPM projects with GL in fusion?
-
Dynamic headings in columns when using relative promptsSummary Would like to be able to change the heading dynamically to proper formatting for our business, without hardcoding. We are using relative to prompt for accounting…
-
Invoice AttachmentContent Hi, When I have three instalment and when I click View Image from Invoice screen and it would print PDF with three pages which is seeded functionality. The templ…
-
What is the obj Type and obj key and Action to achieve drill down to 'Manage Project Page' from theSummary What is the obj Type and obj key and Action to achieve drill down to 'Manage Project Page' from the OTBI report.Content Hello Experts, I have followed https://ww…
-
Anyone has query to link PPM projects with GL in fusion?Summary Anyone has query to link PPM projects with GL in fusion?Content Anyone has query to link PPM projects with GL in fusion?Pradvin Heggar Prabhakar-147626 71 views 0 comments 0 points Most recent by Pradvin Heggar Prabhakar-147626
-
Creating Custom Account Analysis ReportSummary Create Account Parameter(Similar to Oracle seeded Account Analysis Report) in Custom BI report(ESS Job)Content Hello, I am creating a custom bI report similar to…
-
Viewing pending scheduled reportSummary How to view the schedule details for a scheduled reportContent Followed steps from other posts to search in the "hierarchy" view of scheduled processes. I do not…
-
BI Reports Usage AnalyticsContent Hello, Is there a way we can see the last time a specific BI report has been accessed by any user? Thank you Version 19D
-
Report completed in errorsSummary OTBI report completed in errorsContent Hi all, I have custom a OTBI report with data model and layout. Also, I have defined the ESS job in SaaS for user to submi…
-
Skipping to next lineContent Hi, Below is the XML tag in RTF template and the XML tags are highlighted in red Your payment terms is Terms The Installment installment is for an amount of Due …
-
ExternalReportWSSService -> runReport failing with error 415 Unsupported Media TypeContent I am trying to run a simple report from pl/sql using ExternalReportWSSService -> runReport and it is failing with error 415 Unsupported Media Type. The same payl…
-
What View Object uses GL_DAILY_RATES in 20A?Summary I need a VO that uses the data in that table to export via BIACC.Content Hi. I need to export the daily currency rates my company loads in Oracle. I checked the …
-
How to remove html tags from report outputContent Hi team, We built some Analysis based on Sourcing related subject area's Where we see some html texts in the resulting columns like below. How remove these sufix…
-
FRS Studio PDF preview not workingSummary When selecting either PDF or HTML Preview in FRS Studio, not shows in preview windowContent Anyway having or had this issue? Tks!
-
Highlight duplicate values in a columnContent Could somebody help me with the following problem, please: In an OTBI report, I would like to highlight values (eg. with colour or any other way), which are dupl…
-
Remove zero lines from customer statementSummary Remove zero lines from customer statementContent Hi, I am trying to modify the attached customer statement template to exclude lines where F_amount = 0 Any idea ?
-
How to register ESS Jobs in R13 20B?Summary How to register ESS Jobs in R13 20B?Content Hi Everyone, Can you please share your thoughts on How to register ESS Jobs in R13 20B? Thanks,
-
BI Analysis Error - custom column format may contain HTML tagsSummary Prior created report now giving this error when trying to edit and saveContent Reports created months/years ago are now giving me a message when trying to edit a…
-
BI Analyis Natural Account ParentSummary No data using Parent of natural accountContent Hello: Does anyone know how to use the natural account's Parent in filter? As long as the filter contains bottom o…
-
Distribution Email List for ESS JobsSummary Distribution Email List for ESS JobsContent Hi Everyone, Can you please share your thought on , how to setup distribution Email List for ESS Jobs? Thanks,
-
oracle.xdo.servlet.data.DataException: ORA-01722: invalid numberSummary oracle.xdo.servlet.data.DataException: ORA-01722: invalid numberContent Hi i have below error in Data model Parameter name: p_JV_NUM oracle.xdo.servlet.data.Data…
-
Is it possible to link a BIP or OTBI report to an FR report using related contentSummary Recently found that we can drill to a second FR report using related content and the parameters get passed on from the first report cell from which we drill. Exp…
-
Tracking non-financial information related to a chart of account segment for reporting with GL BalanSummary Does anyone have recommendations for storing non-financial information related to a chart of account segment and related GL Balance?Content We have some non-fina…
-
BI Content MetricsSummary Is Usage Tracking Available for Cloud-Hosted Installs?Content We are looking to track and report on the usage of various BI content we have developed, including …
-
Using a graph as filter to another graph in Analysis?Content In Tableau I can easily use a graph (lets say, a vertical column of income per month) to filter another graph when clicked on the first one (ie, a second one wou…
-
Drill Down in OTBI for code combination balance to journal linesSummary Drill Down in OTBI for code combination balance to journal linesContent Use case: We need to build a report listing all the account code combination balances and…