Report Output
Discussion List
-
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 58 views 13 comments 0 points Most recent by Sovitendu Jalli-Oracle 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 5 views 0 comments 0 points Started by AjayKumar Maddipati 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 3 views 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 31 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 25 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 31 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) -
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 1 view 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 1 view 3 comments 0 points Most recent by Shashidhar Goud General Transactional Reporting (OTBI)
-
how to auto run an analysis with promptSummary: I have created an analysis with prompts. I want that when an analysis is run, it should display the output with default prompt option 'All Column Values'. Curre…Dilpreet Kaur 2 views 1 comment 0 points Most recent by Amrita Gupta-Oracle 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 12 views 10 comments 0 points Most recent by Matthew Voss General Transactional Reporting (OTBI) -
Records dropping from basic analysis due to filter(s)Summary: Content (required): I have a very basic analysis in obiee that is pulling all active CWK. I need to include Home Email, however, when I filter, I lose ~25% of m…Karen Delaney 1 view 1 comment 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
Approval date not extractedSummary: Content (required): Hello everybody, In editing a report concerning various information about a job requisition. We needed to extract the "Approval Date" of a j…Gerardo Peluso 1 view 1 comment 0 points Most recent by ravikiran goda-Oracle General Transactional Reporting (OTBI)
-
How to run an OTBI Analysis and save output without having it deliveredSummary How to run an OTBI Analysis and save output without having it deliveredContent Currently in Schedule option of of OTBI analysis , there is option to deliver to e…Shivaji Muttarapu 24 views 8 comments 0 points Most recent by Shivaji Muttarapu General Transactional Reporting (OTBI)
-
OTBI Analysis Prompts NOT SEEN when I run the report in supply chain planning moduleSummary OTBI Analysis Prompts NOT SEEN when I run the report in supply chain planning moduleContent Hi, OTBI Analysis Prompts NOT SEEN when I run the report in supply ch…Sanjiiv Chavaan-158651 13 views 2 comments 0 points Most recent by Pulkit Kumar Jain General Transactional Reporting (OTBI)
-
Custom column in OTBI analysis with case statement is not displaying data in graphSummary I have created an analysis with one of the columns using case statement to derive the status of the performance document based on certain conditions. The graph d…Harpreet Shergill 23 views 4 comments 0 points Most recent by Harpreet Shergill General Transactional Reporting (OTBI)