Get Started with Redwood for Oracle Cloud HCM Begin Now
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
-
Count Distinct by Two AttributesSummary I am not able to get distinct count by management level and genderContent Hello - I'm creating a simple analysis to count the number of employees by a grouped ma… -
Sql query or Table name for Workforce Compensation plan cycles assigned to planHi team, We are unable to find the table where the "Plan cycles" information stored for HCM compensation module. Could you please provide us the table or sql query to ge…
-
How to report on reverse termination?Summary: Trying to report on reverse termination, but I get no results We are sruggling to document reverse terminations performed by our costumers in HCM, since in the … -
How to translate BIP Report Parameter TitleSummary: We have a requirement to translate the report parameter label. We couldn't get any link from Community or MOS to check the translation. We would require your su…
-
External Provider learningSummary: External Provider learning Content (please ensure you mask any confidential information): Hello experts, we would like to create a BIP report with the details o… -
We need termination reson column but how to link with any table ?Summary: We need termination reson column but how to link with any table ? PER_ACTION_REASONS_TL Thankss, Ajay Content (please ensure you mask any confidential informati… -
Unable to map missing columnSummary: Our team is redesigning an OTBI report and is facing an issue with mapping the column from the old subject area "Workforce Learning - Learning Management Real T…
-
In BIP template how can i get columns printed by and printed on ?Summary: Hi Team, we have BIP template how can i get columns printed by and printed on ? Thanks, Ajay Content (please ensure you mask any confidential information): Vers…
-
OTBI and BIP Report Scheduling - Ideal Time WindowHi all, Just a quick question I'm hoping someone can answer. Is there a preferred time for scheduling OTBI and BIP reports during the day? Any times to avoid / best time…
-
Combining multiple max formula criteria in OTBI resulting in no values returningSummary: I'm having trouble pulling in someone's latest record or assignment in a report without it creating multiple line items for their various Job Names. When using …
-
24B Feature Talent Management REPORTING ON PROFILE ATTACHMENTSSummary: When perform the Analysis, report unable to show the link on Profile Attachment attached. Are we supposed to have link to view it? What is the different between… -
Creating Recruiting Support ReportsSummary: We need to create support reports for our mapping operations in the recruiting module. Specifically, we need to extract the following data: The list of Candidat… -
How to remove blank line from RTF template report output?There is a BI report(RTF Template) with the following data as output: Name: DOB: Gender: DOJ: The requirement is to hide DOB(both text and the value) for a certain c… -
subject area to get "in error time card details" in otlSummary: we are creating a report to get in error tome card details. Currently we are using "Workforce management - Reported Time Cards Real Time" subject area, here all…
-
We need citizenship column in BIP querySummary: Hi Team, We unable to find the citizenship column and we checked on per_citizenships table also . any one help me on ? Thanks, Ajay Content (please ensure you m…
-
query to get variable rate program for all employeesSummary: Content (please ensure you mask any confidential information): Hi all, I currently have a query where I am trying to get the variable profile name (under manage… -
With below sub query i'm getting error is ORA-01427: single-row subquery returns more than one rowHI Team, when i sepeartely run the below sub query is working fine but when i run the total below query I'm getting single-row subquery returns more than one row. how to…
-
FTP server setup for BIP - Save or Test connection not availableHi Team, I am trying to add FTP server setup. I can enter all the details but I do not see Save or Test connection. I should be a complete administrator, but seems I hav…
-
FAW connection - Is support Oauth for Salesforce and PeopleSoft & SFTP supports - PGP encryptionFAW connection - It supports Oauth for Salesforce and PeopleSoft & SFTP supports - PGP encryption: Please confirm it is possible.
-
Different Child Data Set fields are not coming in Interactive format of BIP Report.I have modified the Data model of Compensation Report to increase the report performance in Oracle HCM Cloud (Fusion) After making different data sets, linking by parent… -
OTBI HelpSummary: Need help to get last day of the current month in OTBI. Content (please ensure you mask any confidential information): Version (include the version you are usin… -
Which tables stores the information about the benefits that are being used in an organizationSummary: Can some one help me in finding the table for finding benefits that are being used in an Organization Content (please ensure you mask any confidential informati…
-
HCM Table to fetch Saved SearchHello, I'd like to create a BI report to see whether employees have created their own Saved Searches on Document Record page. Do you know which HCM table store this piec…
-
How to retrieve Country of a Logged in User to be used in a value set of a DFFCreating a DFF to determine Yes/No based on country (and some other details) of the logged in user in the value set of the same. First is it possible at all, if yes then…
-
Can we get Completed By and Task Start Time of Task/Activity?Summary: we need to pull Completed By and Task start time fields using BIP ? Do we have direct columns ? Content (please ensure you mask any confidential information): V…
-
Where can I find the BIP tables storing the "Personal Brand Administration" related details?Summary: Hello, We have a requirement to fetch Personal Brand Administration related data, specifically the information under the "Skill Settings" section - "Skill Data …
-
360 peer review participants not showing in OTBI reportI am trying to create a report to show the name of the peer participant and status of the task for a 360 document. The only names that I can get to appear are the employ…
-
Employee Contract Extended data filter needed in OTBI ReportHi Team, I have a requirement to extract employees whose contracts are going to end in the next 60 days. For this, I have added the filter below, and it is working as ex…
-
Can we recall the triggered emails from scheduled reports via the system ?Hi All, Is there any possible ways to recall the triggered emails from scheduled reports via the system ? Regards, Jeba
-
Trying to find the job details from the grade table through valid grades tableSummary: We are developing the grade ladder report in that we need to get the job details for the grades. However, we get duplicates due to the multiple valid grade IDs …