Category 81
Discussion List
-
Query to fetch count of colleagues for whom balances have got loaded into systemSummary: After execution of "Load initial balances" job in system as part of HDL upload of balances. Now I need to know for how many colleagues balance information is lo… -
Master data historySummary: Looking for an Audit query, which shows old and new values of master data. Content Hi I am looking for a query to track changes in Master data (Position, Locati…
-
Delegation InfoletSummary: I want to know if the employee asking for a leave absence has made the required delegation or not before approving the request Content (required): Is there a wa…
-
Convert Numbers to words in OTBI Report.Summary: Hi Everyone! I am trying to build a OTBI report for employees salary. Subject area used: Compensation - Salary Details Real Time. I want a column where it displ…
-
Rehire employee informationSummary: I need to create an OTBI analysis to get information about rehire employees. Content (required): Which subject area do I need to use to get the Action/ Action r…Ayesha Iroshani 62 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there a way to report on changes made an employee makes to their address or number?Summary: Is there a way to report on changes an employee made makes to their address or number? Content (required): Is there a way to report on changes an employee makes…PrJohns-Oracle 27 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Query to get Transactional dataSummary: Hi Everyone, Currently, I'm working on a report, the requirement of this report is to pull the employee's current and proposed data. like the employee transferr…
-
Full-Time equivalent is not working within USING clause of a FILTER operator in OTBII have created an OTBI report using Subject area - Workforce Management - Employee Assignment real time and Full-Time equivalent i am fetching from the "Worker Assignmen…Utkarsh M 26 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Workforce Management - Worker Assignment Real Time - position Management Business UnitSummary: Which fusion table can provide value for OTBI field "Workforce Management - Worker Assignment Real Time - position Management Business Unit" ? Need to create a …Rishita 35 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Embed BIP report on Employment Info Responsive UISummary: Embed BIP report on Employment Info Responsive UI Content (required): Developed a BIP report and used Assignment_id as parameter. We have placed it as Hyperlink…Kammasavala Ramadevi 107 views 3 comments 0 points Most recent by Kammasavala Ramadevi Reporting and Analytics for HCM
-
How to restrict All subject area Access from Line manager roleSummary: We wanted remove all subject area analysis from line manager role. We are able to remove some subject are by deleting the transaction analysis privileges . Rest…Aditya Jena 118 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
I'm new to E-text template, how can I learn and How can we develop in Bi reportsSummary: Hi Team, I'm new to E-text template,how can I learn and How can we develop in Bi reports. Any suggestions . Thanks, Ajay Content (required): Version (include th…AjayKumar Maddipati 43 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
NULL value creating duplicates in UNION queryAfter adding NULL value to some columns , it is showing Duplicates in UNION query. Like: AUTHORIZATIONCODE, JOBDESCRIPTIONDATE, JOBEVALUATIONDATE.Dona Das-Oracle 13 views 1 comment 0 points Most recent by Manoj.Gupta Reporting and Analytics for HCM
-
Create Report from Tags and Experience sections in ConnectionsSummary: Content (required): Hello Experts, Is it possible to create a custom report for the fields in the Connections, more specifically for Tags, Experiences, Interest…Fabiana De Arruda 17 views 2 comments 0 points Most recent by Janine Brown Reporting and Analytics for HCM -
how can start and learn oracle extracts in hcm ?Summary: Hi Team, Please help and Guide me on to learn Extracts. Thanks, Ajay Content (required): Version (include the version you are using, if applicable): Code Snippe…
-
Line Manager access to personal data in subject area WFM - Person Real TimeSummary: Line managers don't have visibility on personal data in report based on WFM - Person real time subject area. Content (required): We have a custom line manager r…User_2025-07-18-02-04-51-132 17 views 4 comments 0 points Most recent by User_2025-07-18-02-04-51-132 Reporting and Analytics for HCM
-
OTL Approval workflow data - Current manager for approval, Submitted by, SubmissionSummary: Does anyone have an SQL for OTL Approval workflow data - Current manager for approval, Submitted by, Submission? Content (required): I am looking to develop a B…Neena S 35 views 2 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Need to attached FF:Summary: Hi Team, We have a requirement in Oracle cloud recruitment where we need to attach FF for only US and Polad country. could someone help me to get this FF. Will …
-
Which subject area gives the payslip earnings?Summary: Report pullings details from Pyalip Content (required): Does anyone know which subject area I can use to get the payslip details as per the screenshot attached?…Isabela Radivoi 76 views 5 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM -
How to call a BI report when email id is created?Summary: How to call a BI report when email id is created? Content (required): Hi All, We got a requirement to send notifications to new joiners when their work email is…Venkatesan 43 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to find the Report path with the report nameSummary: I have the report received to one of the recipient. The recipient request to add another person name to the report scheduling. I do not have the information whe…
-
Create an analysis report to see the workflow for a specific Job RequisitionSummary: Create an analysis report to see all job requisition workflow Content (required): Does anyone know how to create an analysis to see all workflow for a specific …
-
Can OTBI pull payment Method details e.g concatenated bank account No and Sort code ?Summary: I want to add to my audit bank details Report the payment methods details such as concatenated bank account and sort code. Content (required): Not sure if possi…Isabela Radivoi 60 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Difference between 2 dates - BI PublisherSummary: Hello, I'm trying to get the difference between 2 dates in BIP data model. The difference should present number of days between cmp.DATE_FROM and cmp.LAST_UPDAT… -
Reporting the termination screenHi, When I terminate the employee from the My Client Groups>>Termination>> screen, I want to report the part that opens in the screenshot below. I need a sql query for t…Cansel Karasoy 23 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Report to pull out the date since a position is vacantI have a business requirement to pull out the date since when a position is vacant. Is there a way to pull this out or does someone have a report that i can plug and pla…Girish Bhatia 18 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Parameter's label in two different languages.We have a requirement to display the parameter's label as per the language who logs in. The actual requirement is to display the label as per the users who logs in . If …
-
How to get the position level of a position from the top using OTBISummary: We have a requirement to get the position level of a position from the top. eg: CEO is the top position and should be at level 1, 2 directors reporting to CEO s… -
How to prevent state taxes from being withheld based off addresses onlySummary: How to prevent state taxes from being withheld based off addresses only Content (required): Hello all. Employee is now per diem and changed his address to NY. H…Michael Cashin 23 views 2 comments 0 points Most recent by Michael Cashin Reporting and Analytics for HCM
-
OTBI - Talent Review - Holding AreaSummary: Not everyone are placed in a box assignment, some are in the holding area. Content (required): Subject area doesn't seem to have a Holding Area field. I need to…Ratha Sun 36 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM