Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o… -
Need help in retrieving PLAN MANAGER in workforce compensation planSummary: Hi Experts, I was trying to retrieve workforce compensation plan manager. I could not find comp plan manager as filter when searched under Matric Manager in Wor…
-
Equity check marketSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
IN OTBI Absence Real time issue on accrual balanceSummary: we have requirement is to show the report as ui(Annual accrual balance of annual accural ) in below screen shot but shown as below wrong Could you please assist… -
accrual balanceSummary: I have a report on front-loaded plans to show Accraul, leave taken, Leave scheduled, Adjustments and Accrual Balance. Now we have made some adjustments for empl…
-
Empty Reports on BIP Result files with DATA_DSSummary DATA_DS file removalContent Hello. I have created a daily BIP report that is sent to an SFTP, however the report is not expected to result in records every day. … -
OTBI Report Not Returning employment contract detailsSummary: Created an OTBI report using subject area "Workforce Management - Employment Contract Real Time" to extract contract details. However, the fields when added fro… -
How to sort the Questions in order using OTBI report?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to display the Questions under the Questionnair… -
Getting inconsistent data from event date fields. Can anyone help explain this or how to fix this?Summary: While creating an analytic for the state activation and completion, by job application, it created multiple lines. To solve this, we have in the past been able …
-
BIP Schedule ReportSummary: BIP Schedule Report Content (please ensure you mask any confidential information): Hi Team, Greetings! There are multiple BIP Reports scheduled at the different… -
what all types of the condition/logics can be used in e-text templateRequired Types of logics, condition and syntax for e-text templates in BI Publisher -
3rd Substring from a Field in OTBISummary: Need 3rd Substring from "Job"."Job Name" Content (please ensure you mask any confidential information): I have "Job"."Job Name" field and the data looks like "U…
-
Count of development Goals analysisSummary Can't add people with 0 Goals altogether with other Assignment fieldsContent Hi Team, We are trying to build an OTBI analysis that lists Person Name, Person Numb… -
OBIEE Data Model Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actuSummary Data Model Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 5389, maximum: 4000)Content Hi, I am trying to create a data mo… -
Prompt not working in a logical sql analysisSummary: I created a logical sql analysis (see image1). And I also created a dashboard prompt (see image2). I filtered the "Calendar_Year" as 'Is Prompted' but for some …
-
Tables to fetch queries used in DataModelsSummary: Hello Team, Is there any specific tables that are being used to fetch queries used in Data Models? Is there any way to achieve this? Thanks, Paramesh Content (p…
-
How To Loop Throgh a value set in Fast FormulaSummary How To Loop Throgh a value set in Fast FormulaContent Hi Team, we have a requirement to pull particular balance values i tried using the DBI Items but which is n…
-
Columns from Grade and Worker folders in Workforce Management - Eligible Jobs Realtime OTBI AnalysisSummary: Columns from Grade and Worker folders in Workforce Management - Eligible Jobs Realtime not showing results Content (please ensure you mask any confidential info…
-
OTBI prompt set default values for date between first and last day of current yearI know that I can set a default for a prompt as todays date using the SQL expression select current_date from "Workforce Management - Worker Assignment Real Time" I thin…
-
How to Disable OTBI agentWe have almost 160 agents in one of the folders and we need to disable all the OTBI agents. How to check whether the agents are actively running and how to disable them …
-
Need 2 Date Fields having Case or Filter functionality in OTBI ReportSummary: Interim Review Date ("Performance Document"."Performance Document Period Name" like '%Interim%') and Final Review Date ("Performance Document"."Performance Docu…
-
OTBI Analysis - Joining Work Relationship Real Time to the Checklist Real Time subject areaSummary Having an issue joining the two subject areas togetherContent In my OTBI analysis, i need to join the 'Workforce Management - Work Relationship Real Time' to the… -
BIP report or data model for fetching the data of all the employees with their Hire date, terminatioSummary Can anyone help me with BIP report or data model for fetching the data of all the employees with their Hire date, termination date, rehire date along with depart…
-
ORC OTBI Report issue when we export from outputSummary: Hi Team, we getting below issue when we ty to export the data. Thanks, ajay Content (please ensure you mask any confidential information): Version (include the …
-
Latest Tax not Pulling through Subquery ResultsSummary: Latest Tax not Pulling through Subquery Results Content (required): The sub query set up correctly pulls back latest tax code effective start date in a calculat…
-
Learn Records show Duplicates within OTBI Report for all employees and coursesSummary: Content (please ensure you mask any confidential information): Hello, I have recently created a report where the OTBI report shows duplicate rows for most cours… -
BIP query for Public Holiday assigned based on asg work location and showing in Calendar eventSummary: BIP query for Public Holiday assigned based on assignment work location and showing in View Calendar event in work Schedual. Content (required): -- AND PCEC.TRE…
-
Help with Query optimization - Sum of Payroll Balance DimensionSummary: Only months into our post-implementation and our pension report query is consistently timing out. I believe I have narrowed down the offending portion of the da… -
Secured List Views: For any information related to SLVs please raise a Service RequestSummary: I raised an SR some days ago asking for some additional information on Secured List Views (as instructed by Doc ID 2708546.1). I got this response: Your questio… -
Pull birthdays in the next 90 days in OTBI.Summary: Hello all, How to pull birthdays in the next 90 days in OTBI. The logic I currently use is to pull birthdays that fall between WEEK OF YEAR ( CURRENT_DATE) and …