Report Output
Discussion List
-
How to Fetch more than 1000 records with BIP or OTBI reportSummary: Fetch more than 1000 records with BIP or OTBI report. Content (required): Hi, How to fetch more than 1000 records with BIP or OTBI report. I tried with Paramete…Sudheer YN 31 views 6 comments 0 points Most recent by Rich Merkel General Transactional Reporting (OTBI)
-
Earliest Working Pattern RecordSummary: 52 week working pattern start date is not reportable at the moment. Content (required): Each time the employee changes to a zero hours week there is a new worki…Dawn Cawston - CPS 11 views 2 comments 0 points Most recent by Dawn Cawston - CPS General Transactional Reporting (OTBI)
-
How to default the method of opening for an analysis that has been favorited?I have an analysis with a filter marked as a Favorite. The issue I have is when I click on the analysis from the Favorites dropdown, it opens into edit mode. Is there a …Mike Burnett 51 views 10 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
we need every year annual review value in performance documentsSummary: Hi Team, We need every year annual review value in performance documents in OTBI in sunbject area of performance rating real time. EXample--FY2021 Employee Annu…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by AjayKumar Maddipati General Transactional Reporting (OTBI)
-
We have set operations report but unable to reviewSummary: Hi Team, we have set operations report but I'm unable to find out applied filters and where we need to check . any one help me on how can we review for enchanem…AjayKumar Maddipati 11 views 2 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
we have questin text and answer report but all questions are coming in columnsSummary: Hi , we have questin text and answer report but all questions and answers are coming in columns. so we get multiple records for each employee i mean 7 questions…AjayKumar Maddipati 21 views 4 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticeContent This white paper provides the best practices for working with BI catalog folders, and s…User720640-Oracle 108 views 1 comment 9 points Most recent by HarishVummidi General Transactional Reporting (OTBI)
-
Report showing incorrect rolling monthsSummary: Hi Team, We have absence rolling report last 12months but only showing last 10 months data for country. i mean rolling need to Feb'22 to Jan'23 but its taking o…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Dhruvjoshi23 General Transactional Reporting (OTBI)
-
How do you convert UTC time to EST for transaction reportingSummary: Content (required): We are experiencing having issues with Oracle time zones defaulting to UTC vs EST for transaction reporting. Our client business operations …MBaze 21 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
Add division parameter to OTBI ReportSummary: I am trying to create an OTBI report under the expense report templates to show approvers of given POs. I am able to add fields for company, department, and acc…Trent M 71 views 13 comments 0 points Most recent by Sovitendu Jalli-Oracle General Transactional Reporting (OTBI)
-
Table name to capture reverse termination date & its details for reverse terminated employeesSummary Table name to capture reverse termination date & its details for reverse terminated employeesContent Hi All, In which table I can find the reverse terminated dat…Nirmal Kumar L 20 views 1 comment 1 point Most recent by Parag Hiremath General Transactional Reporting (OTBI)
-
Exist Interview Responses Report Not working for some of countriesSummary: Hi Team, we haveExist Interview Responses Report it was developed on few years back still no issue but now yesterday only one of country working fine but reamin…AjayKumar Maddipati 1 view 0 comments 0 points Started by AjayKumar Maddipati General Transactional Reporting (OTBI)
-
We have Connect Conversation Questionnaire below in Performance mgmt how can we extract the reportSummary: we have Connect Conversation Questionnaire below in Performance mgmt how can we extract the report in below questions and answers filled by emps. Performance >>…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by AjayKumar Maddipati General Transactional Reporting (OTBI)
-
Fetch Manager Nation Identifier/SSN on OTBISummary: We need the Managers SSN on OTBI Content (required): None of the OTBI Subject Areas have Manager SSN/National Identifier. How do we get it on any of the Employe…Vibha Pandey 11 views 3 comments 0 points Most recent by Mandeep Gupta 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 40 views 5 comments 2 points Most recent by ravikiran goda-Oracle General Transactional Reporting (OTBI)
-
In OTBI Agent how can we apply mails in CC (carbon copy)Summary: HI Team, I can't seen in OTBI Agent no option for cc (carbon copy) Mails to add the recipecients. only To option available . Any other option for cc in otbi age…AjayKumar Maddipati 11 views 2 comments 0 points Most recent by ravikiran goda-Oracle General Transactional Reporting (OTBI)
-
we have developed new OTBI report but when we Export analysis issue is occuringSummary: Hi Team, when we Export analysis > data > excel we get each row have person number, name some columns coming each row. and we export another way like Export ana…AjayKumar Maddipati 21 views 5 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
when i taken manger number and name from manager folder then company level coming mulitiple numberSummary: Hi Team, when i taken manger number and name from manager folder then company level coming mulitiple numbers for each mangers . How can i rectify the issue. PFA…AjayKumar Maddipati 21 views 7 comments 0 points Most recent by AjayKumar Maddipati General Transactional Reporting (OTBI)
-
duplicay coming for each employee due to each employee have showing multiple mangersSummary: Hi Team, In below screen shot we have taken employee name and manger name, but same employee has two line mangers coming that is the issue facing in the report.…AjayKumar Maddipati 41 views 14 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
When we creating the otbi report that time showing as UI but some times showing dff nameSummary: Hi Team, when we create the OTBI report that columns shown as as per ui but in some time showing as dff name directly in report. PFA Thanks, Ajay Content (requi…AjayKumar Maddipati 31 views 2 comments 0 points Most recent by AjayKumar Maddipati 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)
-
oracle cloud HCM OTBI Dynamic File Name and TitleSummary: Output File naming :-YYYY-MM-DD – [Business Unit] – [Last Name], [First Name} [Incident Event Type] Title: Safety Incident Report for [Incident Number] [Inciden…Surya -Oracle 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-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)
-
In OTBI report each employee have getting two rows but businees need only one row?Summary: Hi Team, when i set order as per bussiness requiremnt i taken and suppress the columns then when i export into csv or excel and with out usiing formatted option…AjayKumar Maddipati 51 views 6 comments 0 points Most recent by Amrita Gupta-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 41 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. 31 views 2 comments 1 point Most recent by Rajasekhar Bandaru-Oracle General Transactional Reporting (OTBI)
-
Employee salary details not able to view through Compensation - Salary Details Real Time Subject AreSummary: We are trying to create a OTBI report for Employee assignment details with Salary details using Compensation - Salary Details Real Time % Assignment Real Time S…Srinivas Sakinala 31 views 3 comments 0 points Most recent by Srinivas Sakinala 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)
-
How to verify and validate correct date formats in OTBI where the column is supporting references.Summary: We have a scenario where we are using a supporting reference column and casting it as date. But due to multiple formats of date being entered in the column with…User_M14OP 1 view 1 comment 0 points Most recent by Sahithi Kolasani-Oracle 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 11 views 3 comments 0 points Most recent by Shashidhar Goud General Transactional Reporting (OTBI)