Core HR
Discussion List
-
How to query fusion tables in SQL developerSummary: We have a data model to select the email_address_id from fusion.PER_EMAIL_ADDRESSES but we want to be able to query this table or data from this table (or IRC_C…maria.stanciu 31 views 2 comments 0 points Most recent by maria.stanciu General Transactional Reporting (OTBI) -
Any one help Skills ReportSummary: Hi Team, we need skills report in Bi or OTBI Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-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)
-
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 25 views 1 comment 0 points Most recent by PatriciaS-Support-Oracle Recruiting, Opportunity Marketplace -
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 31 views 8 comments 0 points Most recent by Amrita Gupta-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)
-
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 87 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)
-
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)
-
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)
-
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)
-
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)
-
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)
-
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) -
OTBI CertificationSummary: OTBI Certification Content (required): Since last year we have been using HCM.I have been trying to create some reports in OTBI, however, I see that I need to l…KMore 11 views 5 comments 0 points Most recent by Shashank Verma-Oracle General Transactional Reporting (OTBI) -
Is there any possibility to get latest job change date in OTBI ReportHi Experts, Good Day!! Can someone please let me know how to get the latest job change date in OTBI Report For Example, one employee Job changed from "AA" to "BB" on 01-…Divya Kollipara 11 views 1 comment 0 points Most recent by Dave.Lazier-Oracle 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 41 views 0 comments 0 points Started by Eva Elks Herrmannsen General Transactional Reporting (OTBI)
-
OTBI Report running into error when I add Sum on a column-Sort has no work space in the work directoSummary OTBI Report running into error when I add Sum on a column-Sort has no work space in the work directory.Content Hi, I have an OTBI Report running into error when …Aloka Bhattacharya 15 views 5 comments 2 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI) -
Export OTBI to CSV includes excluded columnsSummary: How do we ensure that OTBI reports exported into CSV, do not include the excluded columns. Content (required): Currently I have a learn report that I have filte…Dawn Cawston - CPS 11 views 1 comment 0 points Most recent by Bhaskar Konar 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 21 views 1 comment 0 points Most recent by Maruvada Sanat Kumar-Oracle General Transactional Reporting (OTBI)
-
Workforce Management - Checklist Real Time doesn't contain Pending WorkersSummary: I need to report on those colleagues who haven't completed a certain checklist task prior to employment which would mean reporting on Pending workers. However a…MattW 1 view 1 comment 0 points Most recent by ravikiran goda-Oracle General Transactional Reporting (OTBI)
-
OTBI: Diff of Two dates to get Age is rounded to next highest valueSummary OTBI: Diff of Two dates to get Age is rounded to next highest valueContent OTBI: Diff of Two dates to get Age is rounded to next highest value Example: If differ…Srinivas Challa 77 views 3 comments 1 point Most recent by Matthias Ludewig General Transactional Reporting (OTBI)
-
BI publisher report how can we change the sender display of the email notification?Summary BI publisher report how can we change the sender display of the email notification?Content Hello , We would like in BI Publisher reports to have the ‘FROM’ , the…Revital Mefano 27 views 1 comment 1 point Most recent by Noelle Bartlam-Oracle General Transactional Reporting (OTBI) -
Presentation Variable Prompt causes Error on Results tab, but not in Open linkSummary AsOfDate prompt causes errors OPR4ONWY:U9IM8TAC:OI2DL65PContent I added the follow prefix to my analysis: SET VARIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate}'; Then I…Brenda Jacks-49721 83 views 8 comments 0 points Most recent by CB General Transactional Reporting (OTBI)
-
Report on BIP Catalog Folders detailsSummary Report on BIP Catalog Folders details like Roles and Permission etc.Content Dear Team, How to report on BIP Catalog Folders details like Roles and Permission etc…Karthik K-Oracle 78 views 9 comments 2 points Most recent by Alok Suraj-Oracle General Transactional Reporting (OTBI) -
Audit on Data Models in BISummary Need Audit on data modelsContent Hi Experts, Could any one let me know how to get audit on data models in BI Publisher in Oracle Fusion. Thanks in Advance.Charan Kollipara 38 views 4 comments 1 point Most recent by Robert Fighiroae-Oracle General Transactional Reporting (OTBI)
-
Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataSummary Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataContent Hi, We need to fetch the pending transaction Transfer details like New Loc…Nirmal Kumar L 23 views 1 comment 1 point Most recent by User_OWH0W General Transactional Reporting (OTBI)
-
How can I export a list of all active reports we have HCM?Summary I need to have a list of all our reports in HCM BIP (and/or)OTBIContent How can I found out how many reports there are in use at the sys? Who created them, activ…Orit Dekel 35 views 5 comments 1 point Most recent by Christian Berg-0racle General Transactional Reporting (OTBI) -
Deferred Termination field in OTBISummary looking on how to determine a deferred terminationContent Hello, I have been asked to create a report showing the associates with a deferred termination. When th…Kevin Lee Choon 30 views 3 comments 2 points Most recent by prjohnson General Transactional Reporting (OTBI)
-
Filter for terminations in prior calendar weekSummary I'm creating a termination report and trying to show which terminations were in the calendar week (Sunday-Saturday) prior from the week when the report was runCo…Karen B 34 views 3 comments 1 point Most recent by Lavanya Reddy General Transactional Reporting (OTBI)