Category 115
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) -
Which Subject area & folder to use to extract Manager Hierarchy fields (upto level 10) correctly?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Abhishek Bagh 11 views 3 comments 0 points Most recent by Priscila Terazawa-Support-Oracle General Transactional Reporting (OTBI)
-
how to enable dff in otbi report?Summary: I am trying to enable dff in otbi anlaysis. even though i run the schedule on Import Oracle Fusion Data Extensions for Transactional Business Intelligence dff's…Nagaraju P 12 views 5 comments 0 points Most recent by Nagaraju P General Transactional Reporting (OTBI)
-
Do we have Manager Country field available in OTBI?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Abhishek Bagh 1 view 0 comments 0 points Started by Abhishek Bagh General Transactional Reporting (OTBI)
-
is it possible to compare Person Number (Colleague) with Manager Person Number (Supervisor)?Summary: Can we compare Person Number with Manager Person Number dynamically (for all records in a report) to analyze if listed Supervisor is actively present in Person …Abhishek Bagh 11 views 4 comments 0 points Most recent by Abhishek Bagh 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) -
Report containing all the agent(s) I have definedSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):User547534-Oracle 11 views 3 comments 0 points Most recent by Jahnavi-Oracle General Transactional Reporting (OTBI)
-
SQL/report to get the list of consultants (not having Person ID)We are looking for a user/role report that list users firstname/lastname/email and roles. The report we have only lists if they are linked to a person record. We have co…Vijay Ramani VJ 11 views 4 comments 0 points Most recent by Vijay Ramani VJ General Transactional Reporting (OTBI) -
how to remove HTML markup from columns of an OTBI reportSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Abhishek Bagh 21 views 3 comments 0 points Most recent by Gaurav Bharadwaj-Oracle 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)
-
How to use subject area Workforce Learning - Learning Records Real TimeSummary: Workforce Learning - Learning Management Real Time is going to get decommissioned soon, how to use Workforce Learning - Learning Records Real Time subject area …Sandip Karmakar 11 views 2 comments 0 points Most recent by Sandip Karmakar General Transactional Reporting (OTBI) -
we need subject area in career and peoformance for performance Connect ConversationsSummary: Hi Team, we need to track the career and peoformance>peoformance>connect conservation >Performance Document Name related columns in OTBI any one have any idea h…AjayKumar Maddipati 11 views 2 comments 0 points Most recent by Raghavan p-Oracle General Transactional Reporting (OTBI) -
Filter out Employee RatingSummary: I have created a report that has the field Rating Level Name but it includes both Employee and Manager Rating Level Content (required): I how do I identify whic…Dawn Cawston - CPS 1 view 3 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI) -
Matrix Manager field not showing up values as recorded in myHRSummary: When I try to include Manager Type field into the report & look at options (for Matrix Manager) - don't see Matrix Manager option to pick. Can you let me know h…Abhishek Bagh 1 view 0 comments 0 points Started by Abhishek Bagh General Transactional Reporting (OTBI)
-
Tenure calculation in OTBISummary: Used Current_Date function & Enterprise Seniority Date field to calculate Tenure (in a separate field) however the result is not accurate (its showing value zer…Abhishek Bagh 21 views 6 comments 0 points Most recent by Abhishek Bagh General Transactional Reporting (OTBI)
-
how to compare Person Number with Manager Number fieldSummary: I would want to apply a condition to know if Colleague is present in Manager Name field or not. How do we compare the Person Number field with Manager Person Nu…Abhishek Bagh 21 views 3 comments 0 points Most recent by Amrita Gupta-Oracle 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)
-
Pie Chart does not return all itemsSummary: Table results not displayed in Pie Chart Content (required): We have a table that is ranked and everything ranked above 10 is grouped under the reason name 'Oth…Dawn Cawston - CPS 1 view 6 comments 0 points Most recent by Amrita Gupta-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)
-
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)
-
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)
-
Where To Find Overtime Approval FieldsHi all, I'm building a report within OTBI that pulls back all overtime submissions by employee. For the most part, this works great, but I've been asked to include the m…
-
Adapting Previously Used SQLSummary: Amending a BIP Report we have that's not pulling the correct results back Content (required): Hi all, Apologies if this is the wrong place to ask. I've been ask…
-
OTBI Report with two subject areas that are not connectedSummary: I am trying to build a report that provides information on intercompany invoicing with details of the time entries, comments and costs associated with it. I am …Ravi Natarajan-240775 11 views 3 comments 0 points Most recent by Ravi Natarajan-240775 General Transactional Reporting (OTBI)
-
OTBI - Joins between Procurement and Payment related Subject AreasSummary: Content (required): Hi Team, There is an issue while joining two Subject Areas related to Procurement and Payment (trying to join below subject areas as in atta…Sridhar Gupta Yerram-Oracle 11 views 1 comment 0 points Most recent by Raghavan p-Oracle General Transactional Reporting (OTBI)
-
Communities in LearnSummary: Hi, I am working on LEARN report. I have to pull 'communities' field into my analysis can anyone provide me the specific Subject area and field name through whi…Praveen_Chouhan 11 views 2 comments 0 points Most recent by Ramzzz 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 add parameterized OTBI report on InfoletSummary: Hi Team, We have created parameterized OTBI Report and a dashboard with prompt. However when we add them to infolet , but infolet is not asking for parameter an…Nidhi Chhajed 11 views 1 comment 0 points Most recent by Raghavan p-Oracle General Transactional Reporting (OTBI)