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 a way in BIP PL SQL to retrieve where the transaction has been done?Hello Experts, for example, the transaction was done in Me Tab, then PL SQL will tell that this is Me tab page, or in a My Team page. I am currently creating a transacti… -
What table that holds actual work schedule of employee ?I want a query that gets the actual work schedule of employee in this screen
-
Need SQL query to fetch answers submitted by employee for questions configured using flex fieldSummary: Need SQL query to fetch answers submitted by employee for questions configured using configurable forms as follows. Hence i need SQL query to fetch Country of B…
-
How to use ASCII Values in OTBISummary: We are using this statement REPLACE(REPLACE("Document and Rating Details"."Rating Comments", CHAR(13), ''), CHAR(10), '') in BIP Report.How can i use the same s…
-
Report for active State Withholding ID for W2Summary: Report for active State Withholding ID for W2 Content (please ensure you mask any confidential information): Hi All, Greetings! We need to get the list of the a… -
We need to send files to Microsoft teams Through any automated processWe have a BIP report that needs to scheduled on a daily basis and we want to store those output files in Microsoft teams under Files Section. We don't want to store them…
-
How can we create a distribution list in Oracle fusion Bi publisher?I need to share a custom report with multiple users through the following steps: Schedule → Output → Destination Does anyone have any idea about configuring a distributi…
-
How to report for those absence leave requests which are in denied statusHi, Can you please suggest how to report for those absence leave requests which are in denied status. Thanks in advance. -
Get firstname lastname of user without person recordSummary: Requirement to get firstname, lastname of a user record which doesnt have a person record. since its ERP project, HCM part would not have been configured. PER_L…
-
Annual salary not equal across different subject areasWe are having a problem with annual salary not being equal in Compensation - Salary Details Real Time and Compensation - Workforce Assignment Salary Real Time. It appear…
-
Assigning HR AOR Roles Changed ReportingSummary: We are moving our HR Specialists to AOR Roles, based on Location. And in testing this in our lower instances, everything on the screens is working as expected. …
-
Subject Area -- Custom Column Formula IssueWe have an analysis built off of "Workforce Management - Accrual Real Time" joined to "Workforce Management - Work Relationship Real Time." Results return on a data tabl…
-
SQL query that returned the Leave approverSummary: Does anyone have a SQL query that return the leave approver? Content (please ensure you mask any confidential information): Version (include the version you are… -
How to alignment of text in TCS statement ?Summary: The text alignment in columns of TCS reports is inconsistent, with some columns using left alignment and others using right alignment. However, the alignment of…
-
How to control the font size in TCS ?How to control the font size in TCS? The font size for the Total value in TCS is smaller than the font size used for tabular data.
-
BI Publisher or OTBI Reporting on field used for ADP Workforce Now integrationHi, we do payroll in ADP Workforce Now and run a daily integration from Oracle. We want to know if it possible to report on this field used for the ADP integration only.…
-
Sample SQL Query for IBANHi, we have to develop a report with the Employee's Personal Payment method Details like IBAN and bank account info etc. Please share if any sample SQL query to capture …
-
OTBI Report for Gross EarningSummary: Hi Can you please suggest if it is possible to create a report in OTBI that will provide gross earnings per element for a specific period? If it is possible, ca…
-
BI report: how to differentiate between learning outcomes and prerequisitesHello, is it possible to differentiate between learning outcomes and prerequisites? which table can we use to retrieve learning outcomes and what table for prerequisites… -
Global Talent Community Pool data not visible in OTBISummary: Hi Team, We are using OTBI to fetch data from the candidate data belonging to "Global Talent Community Pool". However, we are getting only one record having sta…
-
Bursting sending one consolidated email instead of multiple emailsSummary: Needs to send one email to Manager with consolidated notifications of all the employees instead of sending one notification for each employees. Content (please …
-
Showing month name in graph in OTBI AnalysisHi, I've developed an OTBI Analysis which has a Graph view where I'm printing the Month in the X axis. The issue I'm getting is month is coming as numeric value but our …
-
How to calculate Holidays and Weekends using groovy in Fusion Sales Cloud ObjectsSummary: The requirement is to calculate calculate age of the record which is (today()-creation date). But the age should exclude weekends and public holidays. Is this p…
-
my FRS is showing duplicate accounts on reportsSummary: Reports were correct when created but now have this issue of duplicating and categorizing accounts under cost of sales but still appear in the correct category …
-
Find Missing Registered Nurse LicenseSummary: Does anyone have a report to share that identifies active persons who are missing an RN License. Details: A person can have multiple different licenses. Using a…
-
Custom LOV for OTBI PromptSummary: Custom LOV for OTBI Prompt Content (please ensure you mask any confidential information): Hello experts, we have created a report for all the managers within th… -
Dashboard error.Summary: Hi Expert, I am getting below error while running the dashboard. If I provide the some Active LE and LDG and location still getting same error. Waiting for prom…
-
OTBI - Retrieve Manager of indirect reportsSummary: OTBI - Retrieve Manager of indirect reports Content (please ensure you mask any confidential information): Hi experts, we would like to create a report for all …
-
sql query to get job level in oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Date parameter is defined as date but I still get errorSummary: I have created p_date as a date parameter in my data model. p_date is defined as date data type and parameter type date. I am looking to get the days between p_…