OTBI
Discussion List
-
In OTBI is there a way to pull in expenditure batch workflow? (Who created/approved)Summary: With the new project cost workflow introduced, I can no longer use the Actual Costs Real Time subject area to pull in created by. It now goes through a separate…Rich Merkel 11 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle 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 9 views 3 comments 0 points Most recent by Mandeep Gupta General Transactional Reporting (OTBI)
-
Pull monthly accrual rate for absence planSummary: I'm creating a report using Accrual Real Time as Subject Area and I'm planning to retrieve all employees that is eligible to Annual Leave and also I wanted to s…Kobe Chavez 10 views 1 comment 0 points Most recent by Noelle Bartlam-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…MikeW 1 view 1 comment 0 points Most recent by Noelle Bartlam-Oracle General Transactional Reporting (OTBI)
-
which subject area we get father/husband names in OTBISummary: Hi Team, we need data employees of father and husband names so could please assitance on. Content (required): Version (include the version you are using, if app…AjayKumar Maddipati 21 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get notified when a scheduler does not deliver a report (due to any reason)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 17 views 4 comments 0 points Most recent by Abhishek Bagh General Transactional Reporting (OTBI)
-
Can we report on the columns and subject areas used in an OTBI report?Summary: As 22d is removing the Workforce Learning - Learning Management Real Time subject area, I wondered if there was a report that could tell us which of our reports…Dawn Cawston - CPS 41 views 6 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI) -
how to put a Countif in a unique field in an OTBI reportSummary: In my report, I have Person Number field which is unique, however the report has some duplicate entries. I only need to understand how do I get a count to see h…Abhishek Bagh 25 views 8 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
OTBI Usage and Performance Dashboard SampleSummary OTBI Usage and Performance Dashboard SampleContent Real Time OTBI Usage & Performance * Two subject areas are available in 20D to monitor OTBI usage and performa…Noelle Bartlam-Oracle 986 views 22 comments 19 points Most recent by User_XPQO3 General Transactional Reporting (OTBI)
-
User limited to 33 report loads in Report Job HistoryHello, We have a user that is being limited to only 33 report loads in job history. This is the only user that has reported this behavior and the behavior differs when t…bobby.hussey 1 view 2 comments 0 points Most recent by Frank Davidson 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 11 views 7 comments 0 points Most recent by ravikiran goda-Oracle General Transactional Reporting (OTBI)
-
List of BPM PVOs available in Fusion or accessible through OTBISummary: Would like to know the list of available OTBI PVOs which hold BPM related information to be able to cater to some reporting scenarios - for e.g. - how long does…Amit Garg-Oracle 1 view 1 comment 0 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 12 views 2 comments 0 points Most recent by ravikiran goda-Oracle 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 3.9K views 14 comments 8 points Most recent by LCann-Oracle General Transactional Reporting (OTBI)
-
how to calculate Tenure dynamically (including for a historical date)Summary: I have an active HC report where I included a Tenure field using below formula however it is not good when we try to pull the report for a historical date. I am…Abhishek Bagh 1 view 0 comments 0 points Started by Abhishek Bagh 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)
-
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 4 views 4 comments 0 points Most recent by Andrew_Schmitz General Transactional Reporting (OTBI)
-
OTBI: Find the number of Working/Business Days between two dates and exclude Public HolidaysSummary OTBI: Requirement to find the number of Working/Business Days between two dates, therefore the calculation must exclude days that fall on Weekends or Public Holi…Richard Beet 103 views 5 comments 0 points Most recent by Venu Kumar General Transactional Reporting (OTBI)
-
OTBI Multi Language Support - Report not bringing back data when in different languageSummary: When users who have a different language selected other than English runs a New Hire report, the report will bring back no data because of a string in the filte…Max W 12 views 4 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
How To Restrict Values In OTBI Dashboard Prompt Based On SecuritySummary:Want to Restrict Values in OTBI Dashboard Prompt based on Security Content (required):You have a role that has access to an OTBI Dashboard, and the data in the r…vjsalve 24 views 2 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
Audit Analysis/BI Publisher Report ExportsSummary: Is it possible to monitor which user exports the output of an analysis and/or BI Publisher report? Content (required): The current BIP Audit reports track execu…Ron Nelson 11 views 1 comment 0 points Most recent by Raghavan p-Oracle General Transactional Reporting (OTBI)
-
OTBI Analysis - Getting DFF meaning instead of the valueContent Hi, I am developing an OTBI analysis that deals with several DFF from Oracle HCM Cloud. These DFF have value sets that get values from lookups loaded into the sy…Tmolina-Oracle 92 views 5 comments 0 points Most recent by Yves Chassein 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)
-
Is there possible to create prompts in combine resultDear , i have otbi report which showing result based on two criteria means combine and now i want to click on colleague name and opens new report based on that name so i…Mirza_Adeel 11 views 3 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
Remove repeating valuesSummary: Some of the column numeric values repeat even though Suppress is enabled for the column. Is there anything else I am missing? Thank you Content (required): Vers…Eva Mirzoyan 11 views 1 comment 0 points Most recent by Bhaskar Konar 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 4 comments 0 points Most recent by Abhishek Bagh 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 14 views 5 comments 0 points Most recent by Nagaraju P 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 83 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)