Reports
Discussion List
-
Scheduled OTBI report missing in month of first day but when manually extract that report no issueSummary: Hi Team, we have custom OTBI report, so we started scheduling to business with filter of April first on words only so when we scheduled that report April 1st mi…AjayKumar Maddipati 8 views 0 comments 0 points Started by AjayKumar Maddipati General Transactional Reporting (OTBI) -
How to create a flag field to know if a colleague is a Manager or not in OTBI report directly?Summary: In addition, wanted to understand if there's any in-built field present which can let us know whether listed Supervisor is in Active or Inactive status. If ther…Abhishek Bagh 12 views 6 comments 0 points Most recent by Abhishek Bagh General Transactional Reporting (OTBI) -
How to default an OTBI SQL in a Data Model to Table View?Summary: How to default an OTBI SQL in a Data Model to Table View? Content (required): Does anyone know if it's possible to default the Data tab of an OTBI Data Model to…Mike Burnett 9 views 3 comments 0 points Most recent by Mike Burnett General Transactional Reporting (OTBI) -
Recruiting: How to create a report to show the list of Offer approversSummary: Hi All, There have been many issues in 22B regarding (Recruiting) Offer approvals getting stuck, or not working the way they should be. It was just recently fix…Jessie Gee 11 views 2 comments 0 points Most recent by Jessie Gee General Transactional Reporting (OTBI) -
Recruiting: How to create a report to show the list of Offer approversSummary: Hi All, There have been many issues in 22B regarding (Recruiting) Offer approvals getting stuck, or not working the way they should be. It was just recently fix…
-
Does anyone know how to convert dynamic timezone in Oracle SQL via Data Model?Summary: Is there a way to dynamically convert timezone based on what timezone is being set in UI? (specifically in learning activity start time and end time) Content (r…Hazel De Castro 1 view 2 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
Want to know the exact name and subject area in OTBI for adding 'Reference Number' fieldSummary: Hi Team, OTBI - Could you please suggest the correct subject area and field name for adding Reference Number field (Highlighted in Yellow below) available in th…Rahul Kumar Gupta.-Oracle 1 view 6 comments 0 points Most recent by Rahul Kumar Gupta.-Oracle General Transactional Reporting (OTBI) -
OTBI report and data role securitySummary: Should an OTBI report using General Ledger - Balances Real Time subject area (linked to the Essbase cube) inherit custom data roles configured in SaaS? Content …Craig Hevey 1 view 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
which subject Area need to take for Talent RatingsSummary: Hi team, we have new requirement on Talent ratings of employees So how can I go with and in which subject area below columns are available ? Talent ratings>care…AjayKumar Maddipati 21 views 5 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
Error while calling Oracle BI Publisher REST API in 22ASummary: Error while calling Oracle BI Publisher REST API in 22A Content (required): Hi Everyone, Tried calling REST API for Oracle BI Publisher from postman but got err…Shashidhar Goud 11 views 9 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
What controls access to "all job histories" versus "my job histories" in Report Job History?Summary: How do we grant a user access to see all job history not just their own? Content (required): We are trying to grant access a power user access to all job histor…Lisa G. 21 views 2 comments 1 point Most recent by Rajasekhar Bandaru-Oracle General Transactional Reporting (OTBI) -
OTBI Analysis - Show Managers Direct and Indirect StructureSummary: OTBI Analysis - Show Managers Direct and Indirect Structure Content (required): I am looking to show a manager's indirect structure, for example, I like to know…Harminder Banga-283414 1 view 2 comments 0 points Most recent by Andrew_Schmitz General Transactional Reporting (OTBI)
-
Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22ASummary: Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A Content (required): Which table in SaaS stores information for Audit Reports? Table …Abhilash Karappankutty 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI) -
Absence Leave Amount & Payroll Element NameContent Good Day, We have been tasked to create a report where anyone who has booked less than a full days leave is highlighted. This in its self is very easy and achiev…Clifford-Barrington Trett 44 views 3 comments 0 points Most recent by Peeyush Chandel General Transactional Reporting (OTBI) -
Report for vacant positions and open job requisitionsSummary: Hi, I was wondering if anyone has a report that shows active vacant positions with active open job requisitions? We are looking to pull: Active position current…Eva Elks Herrmannsen 11 views 0 comments 0 points Started by Eva Elks Herrmannsen General Transactional Reporting (OTBI)
-
R13.x Deprecated and New BI View ObjectsSummary This posting includes R13 deprecated Business Intelligence View Objects (BIVOs) that are unavailable for extraction using BI Cloud Connector (BICC) in Oracle App…Rohan Lobo-Oracle 2.4K views 5 comments 8 points Most recent by Sahil Makhiza General Transactional Reporting (OTBI)
-
Invalid date in BIP report for some usersHello, We have an issue where some of our users are seeing invalid dates in the BIP report. e.g. actual date in table (at db level) is 15-Nov-21 but certain users are se…User_ZTN0B 21 views 5 comments 1 point Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
REST API for Oracle BI Publisher not working in 22AHi Everyone, Tried calling REST API for Oracle BI Publisher from postman but got error from Oracle Public cloud with 404 code and page not found error message. Not sure …Shashidhar Goud 1 view 3 comments 0 points Most recent by Shashidhar Goud General Transactional Reporting (OTBI)
-
Hide Seeded Folders from Reports and AnalyticsSummary: We are able to hide customs Folders by Using Shell role and and Permission feature. However While trying the same with Seeded Folders or the folders within them…Shashank Verma-Oracle 11 views 1 comment 0 points Most recent by Priscila Terazawa-Support-Oracle General Transactional Reporting (OTBI) -
ZMM Notes columns - SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID in Receivables - Transactions Real Time?Summary: Is anyone familiar with the subject area - Receivables - Transactions Real Time? I am looking for the equivalent of SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID column…Scott McAnally 12 views 1 comment 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
Text AnalyticsSummary step by step procedure to proceed Text Analytics in OBIEE 11gContent Hi, I need step by step procedure to proceed Text Analytics in OBIEE 11g. I'll be happy to r…Andrews J Stanley 21 views 2 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI) -
Person Records Secured By AOR Does Not Restrict Data Reflected In OTBI ReportsSummary: Hello Everyone ! I am trying to secure the data returned by HR_ANALYST job role by using an AOR with a scope of Department. Although, it works fine in the HCM U…Maruvada Sanat Kumar-Oracle 1 view 1 comment 0 points Most recent by Maruvada Sanat Kumar-Oracle General Transactional Reporting (OTBI)
-
Do analyses run with Agents log to "OTBI Usage Real Time" subject area?Summary: Do analyses run with Agents log to "OTBI Usage Real Time" subject area? Content (required): Version (include the version you are using, if applicable): Code Sni…Andrew_Schmitz 1 view 2 comments 0 points Most recent by Andrew_Schmitz General Transactional Reporting (OTBI)
-
Issue Combining Multiple SAs - blank fieldsSummary: Issue with combining two SAs: Workforce Management - Worker Assignment Real Time & Recruiting - Recruiting Real Time Trying to put a flex field from Recruiting …Andrew Mc 1 view 1 comment 0 points Most recent by Sahithi Kolasani-Oracle General Transactional Reporting (OTBI)
-
OTBI Report Too Slow / Not Generating ResultsSummary: Have created a report to pull all roles for all users (Audit purposes), and admittedly there is an excessive amount of data to pull. That being said, when runni…User_DKPSX 11 views 10 comments 0 points Most recent by Matthew Voss General Transactional Reporting (OTBI) -
Repeat Column Headers in BI Publisher Excel TemplatesSummary Repeat Column Headers in BI Publisher Excel TemplatesContent Hello Everyone, I have a requirement to repeat column headers in BI publisher excel templates when t…Dhanuka Chamal 20 views 3 comments 2 points Most recent by Lydia Jayasingh General Transactional Reporting (OTBI) -
Is there a way to limit OTBI Dashboard Prompt values based on securityHello, Is there a way to limit/restrict the OTBI Dashboard Prompt values based on security / data roles assigned to current user ? We are seeing that the analysis, when … -
Pull a report of OTBI User Folder AccessSummary We need to be able to pull a report of all user access to all OTBI folders.Content We need to be able to pull a report of all user access to all OTBI folders. To…Steph Hamelbeck 70 views 3 comments 8 points Most recent by User_ZTN0B General Transactional Reporting (OTBI)
-
Is there a way to find what reports/anaylsis are set up for Bursting?Summary Is there a way to find what reports/anaylsis are set up for Bursting?Content Hello I need to find out what reports/analysis have been created and set to burst ou…Helen Thomas-53877 48 views 6 comments 0 points Most recent by Raghavan p-Oracle General Transactional Reporting (OTBI)
-
Does anyone have any suggestions to help me fix this issue?Summary: Dashboard performance issue Content (required):Pivots populate within seconds within the analyses report. However, running through the dashboard it can take up …Donna Fazio 1 view 1 comment 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI)