Reports
Discussion List
-
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.9K views 8 comments 8 points Most recent by Dave Kekish General Transactional Reporting (OTBI) -
The content is blocked contact the site owner to fix the issue. OTBISummary: We have created a custom report using SQL based data model and gave permissions to the user for running it. But, they are receiving this error when trying to ru…Goutham.Manthri 31 views 8 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe…Swapnil Kashid 31 views 7 comments 0 points Most recent by Swapnil Kashid General Transactional Reporting (OTBI) -
Not able to see budget amounts in Fusion OTBI AnalysisSummary: Content (required): I had uploaded Budget amounts using FBDI and it is appearing in Account Monitor also in General accounting dashboard. But while creating ana…Akash Nandwal-Oracle 1 view 1 comment 0 points Most recent by Sahithi Kolasani-Oracle General Transactional Reporting (OTBI)
-
which subject area varaible pay plan details have in OTBI ?Summary: Hi Team, we need varaible pay plan details in OTBI report so mayi know which subject arae avilable ? Thanks In Adavance. Content (required): Version (include th…AjayKumar Maddipati 11 views 2 comments 0 points Most recent by Julian Castro-Oracle General Transactional Reporting (OTBI) -
when I using matrix manger columns list I'm unable to find Top manger type mail IdSummary: Hi Team, I'm using worker assignemnet real time subject area in that we need to fecth the performnace manger name , number and email so we are filetr out from t…AjayKumar Maddipati 11 views 4 comments 0 points Most recent by Julian Challenger-Oracle General Transactional Reporting (OTBI)
-
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 11 views 1 comment 0 points Most recent by Amrita Gupta-Oracle 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 11 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 11 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 13 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)
-
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 11 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)