Category 81
Discussion List
-
Calendar Quarter column formatSummary: Hello, Could you please let me know how to change the format of column "Time"."Calendar Quarter" in OTBI subject area "Workforce Management - Workforce Trend Re… -
Column Formula to get bi-weekly salarySummary: I need to get the bi-weekly salary of the employees, dividing the annual salary by 26 ( pay periods). Content (please ensure you mask any confidential informati…Ayesha Iroshani 22 views 2 comments 0 points Most recent by Anna-MariaP Reporting and Analytics for HCM -
Table that stores BIP error detailsSummary: Which table stores BIP error details text? Content (required): We are trying to build a custom BIP report to summarize all BIP job errors into a notification em…Abhishek Potnuru 223 views 8 comments 1 point Most recent by Sneha Sao Reporting and Analytics for HCM
-
Unable to fetch Resignation Transaction approval rules data in the reportWe have a requirement to fetch the approval rules data in the BI report. But we are not able to get the full approval flow from the tables.KeerthanaBaskaran 31 views 9 comments 0 points Most recent by KeerthanaBaskaran Reporting and Analytics for HCM
-
Unable to Upload PGP key Post 24A UpgradeI'm Unable to Upload PGP key Post 24A Upgrade in BI Publisher using Administrator. It is giving 'Generating BI Publisher kaypair failed: reason = gpg --gen-key command f…SushantAnand 131 views 2 comments 0 points Most recent by SushantAnand Reporting and Analytics for HCM
-
report to show timecards that aren't approved (when the last editor was not the worker him/herself)Summary: Just sharing BI SQL. We have a need to output instances onto a report to show which worker did not re-approve a timecard that was edited by a member of our time…Shant_Sarkissian_WJG 55 views 2 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM -
How do you compare columns in a formula when the columns are in two different subject areas?Summary: Specifically, we are trying to compare the resident state (from Person Real Time) to the Worked State (from Calculation Cards Real Time - Location). I'm able to…
-
SQL Report Filter for Previous_MonthSummary: I am trying to create a filter in my OTBI report that will return Pay Date results from the Previous month. Any suggestions? Content (please ensure you mask any…
-
Privileges/Roles to access the Reports and Analytics Work areaSummary: Content (please ensure you mask any confidential information): Hi experts, I'm working with a custom job role that should be able to access the Reports and Anal…Elena_Panniello98 223 views 1 comment 0 points Most recent by Joe Dorrian Reporting and Analytics for HCM
-
how to remove a certain value from drop down of a field.Summary: how to remove a certain value from drop down of a field. Eg: in below ss Content (please ensure you mask any confidential information): Version (include the ver…Gleamy Mishra 61 views 5 comments 0 points Most recent by PriyankaAgarwal -Oracle Human Capital Management
-
ORC:Date of Probity, Date of Interview, Date of review fields in Subject AreaSummary: Currently there is no any subject area available in ORC to get details directly against Date of Probity, Date of Review, Date of Interview and other phases. can…Siddhesh Nisal 21 views 4 comments 0 points Most recent by Siddhesh Nisal Reporting and Analytics for HCM -
User-Defined tables name in Oracle HCM BISummary: Content (please ensure you mask any confidential information): Hello experts, do you know the BI table to extract user-defined tables? Thanks in advance for you…Valerio Curzi 11 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
OTBI Dashboard Prompt showing Error Code:ACIOA5LNSummary: OTBI Dashboard prompt showing Error Code:ACIOA5LN for one of the user account ? What could be the reason? Content (please ensure you mask any confidential infor…Pannala 407 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
User not able to run a dashboard in OTBISummary: Content (please ensure you mask any confidential information): Hi, I am testing a user where he is able to view the Dashboard and when I click on it, the prompt…Pannala 124 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to link transaction adminstration Real time with worker assigenment Subject area ?Summary: HI Team, We have need to track the all transactions in hcm of : Change Location, Change Manager, DeleteAssignment Promotions ResignationTransfers. with worker d…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to: Translate BI Publisher Report Parameters at 24ASummary: How to: Translate BI Publisher Report Parameters at 24A Content (please ensure you mask any confidential information): Version (include the version you are usin…Ishtiaque AHmed 41 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM
-
How to create a historical report with actions reasons in OTBI?Summary: How to create a historical report listing all actions/reasons since the hire date including future dated action reasons/ Content (required): I'm using Worker As…Stefaan Onderbeke 163 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to find Notifications setup on a Scheduled Process scheduleSummary: In Scheduled Processes, how you do view/edit Notifications setup on a scheduled report? Content (please ensure you mask any confidential information): Version (…
-
create a performance template section based on goals subtypeSummary: Create 2 goals section in performance template Content (please ensure you mask any confidential information): Hello, I have a request to use the subtype to spec…Catherine Abi Samra 22 views 2 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
Repeating Groups - Excel Template BI PublisherSummary: Hi, I am trying to create a PO History Report and I am wondering if there is an easier way to group the data by a specific PO? Right now I have PO Number and PO…Simranjeet Singh 103 views 1 comment 0 points Most recent by Alexandru Burcea-Oracle Reporting and Analytics for HCM
-
SQL or ORA exceptions caused due to invalid sql, database package state or some database exceptionsSummary: Me pueden ayudar con el error que genera solo para periodos del 2024, el informe es un Publisher .Elia Lican 21 views 1 comment 0 points Most recent by Alexandru Burcea-Oracle Reporting and Analytics for HCM
-
OTBI Dashboard-when i click the apply button it not changing the dashbord dataSummary: HI All, I have edtionally added completion date but when i click the apply button it not changing the dashbord data but when i apply the hire date of dates its …AjayKumar Maddipati 32 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
What is the OUTPUT CHARACTER SET can support German umlauts in etext templateSummary: What is the OUTPUT CHARACTER SET can support German umlauts in etext template. Could anyone please provide any information about this. Content (please ensure yo…mohityagyik 84 views 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for HCM
-
RTF holding on the empty space if the condition is not satisfiedHi, I facing an issue with rtf template where if the condition is not fulfilled it shows blank space and then the next text in the report like below picture Is there som…chpriyanka 246 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to get the action reason from the Enterprise Hire Date?I'd like to get the Action Reason based on employee's Enterprise Hire Date. However, when I'm about to add the Action Reason column within the analysis, the value didn't… -
How to Print data in reverse mode through RTF template , Ex: ABCD>>DCBASummary: For one of the client requirement , in rtf template i need to show the text in mirror look. Please do the needful. I found fonts from internet , but those are m…SAKTHI SUNDAR 127 views 4 comments 0 points Most recent by Narendra Prasad Golla Reporting and Analytics for HCM
-
Query to list all the tables used by a BI publisher reportSummary: Experts - Is there any base table that stores the various tables used in a datamodel for a BI publisher report? Content (required): Version (include the version…Vijay Rajendran 799 views 4 comments 2 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for HCM
-
How to access deleted data information using BI Publisher?Summary: 22A Record Additional Data When Deleting an Assignment Record Using Employment Info Page indicates accessing the deleted data information in BI Publisher (PER_E…Viviane Beaudoin 22 views 1 comment 0 points Most recent by Viviane Beaudoin Reporting and Analytics for HCM -
Get the (comments and attachments) in the performance approval document notificationI want query to get the comments and attachments that appear in the performance document approval notification depends on the employee numberMustafa Abu Dayeh 42 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM
-
How to configure reminders for workflows notificationSummary: How to configure daily reminders for approval workflows notification if no action is taken from approver Content (please ensure you mask any confidential inform…Gleamy Mishra 63 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM