Reports
Discussion List
-
BI Publisher - Bursting - Email Delivery Channel - HTML Message BodySummary BI Publisher - Bursting - Email Delivery Channel - HTML Message BodyContent All, Able to burst BI Publisher Reports and deliver them via email using: Email PARAM…User_2025-02-05-22-13-16-277 849 views 6 comments 3 points Most recent by M Tanatwi Reporting and Analytics for HCM -
Compensation Amount (Filtered by Team) field OTBI Subject Area in CompensationSummary Compensation Amount (Filtered by Team) field OTBI Subject Area in CompensationContent Hi All, Could you please suggest in which Subject Area/Attribute or BIP tab… -
Remove White Spaces from RTF TemplateSummary: Hello All, Can any body please suggest on removing white spaces from RTF Template. In the the RTF template ->Right Click Paragraph ,We have tried to set the Par…MilanMohanty 1.7K views 1 comment 0 points Most recent by Natalia Rappleye-Support-Oracle Reporting and Analytics for HCM -
How to use drilled down in BI Report when I use normal layoutSummary: How to use drilled down in BI Report when I use normal layout Content (required): I have graph in my BI report and what I want is - when we click on graph it sh…
-
User account data restriction issueSummary: Data Restriction issue. Content (required): Hi Team, Me and my HR using same admin user account. And in my organization we have one of the report called Leave B…
-
Calculation Component Reference Values vs. NamesSummary: In Oracle HCM OTBI: Is there a way to add in the from the person calculation card, earnings distribution override screen the name of the component reference as …User_2025-03-07-05-52-31-902 21 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Calculation Card Reporting - CitySummary: We need a way to report on employees that have a split percentage city tax (part work city & part home city to represent working partially in office vs. remote)…Chelsea Holden 31 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Transfer Dashboard's gear icon to the HCM UIHello, Our client has a requirement, in which he wants the user to have access to the page options (gear icon) of the dashboard in the HCM UI, in the exact same manner i…Ioannis Adamou 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reports - Page options available to the user environment?Hello, I have been asked to find a way to make available the page options of the analytics to the Reports tab. To be more specific, we need the gear icon from the analyt…Ioannis Adamou 51 views 6 comments 1 point Most recent by Ioannis Adamou Reporting and Analytics for HCM
-
How to get list of roles from systemSummary: Content (required): Hi Expert, We have a requirement to get all the roles we have in the system. So we just wanted to know how to get all the roles. Please sugg…Faizan Rashid 41 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to add multiple filters in HCM Extract Filter CriteriaSummary: We want to add another filter under HCM Extract Data Group Filter Criteria to filter out terminated employees who has been rehired later from our result set. Co…GauravGupta39 621 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Can anyone assist with joining two tables in Learning? WLF_EVENT_ASSIGNMENTS_F and WLF_LEARNING_ITEMSummary: I am trying to join the course and the associated initiative information from the two base tables in Learning. Content (required): Joining the learning_item_num…Thulasi Ram 111 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Oracle HCM Cloud: Where can I see the seeded Packages for BIP?Summary: Does Oracle have a list of DB packages that we can use for BIP? I saw this one "pay_balance_view_pkg" but I wanted to know if Oracle have a full list of package…
-
Provide Deep Link for a Performance Document inside a BI Publisher ReportSummary Refer to the direct Deep Link for Performance Document for Manager's feedbackContent Hi All, We are building a custom BI Publisher report that will generate Emai…Kalyan Amaravathi 143 views 4 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
when i ran My Bi reports I'm getting error is ORA-01427: single-row subquery returns more than oneSummary: Hi Team, when i run my report some countries coming data and some of times als coming the data but some times I'm getting below errror: ORA-01427: single-row su…AjayKumar Maddipati 717 views 13 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
ODBC Error - ADFService11g on OTBI AnalysisSummary: After 22B went into our Test environment, a report built on a few subject areas no longer works. It is giving us the following error: State: HY000. Code: 77031.…
-
Restricting report access to read only using Application RoleHi, In HCM (Reports and Analytics), We are trying to restrict reports access to read only for particular users using Application role. For that created a new role assign…
-
Language translation for OTBI ReportSummary Can we change the language of custom OTBI report Report Header, Report Title and Report Name?pooja yelsangikar-Oracle 62 views 3 comments 0 points Most recent by User_IBL58 Reporting and Analytics for HCM -
Report to pull goals not createdSummary: Can any one please send me the query or analysis to pull the employees who not created goals. Content (required): Version (include the version you are using, if…Reddykrishna Chidella-Oracle 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Hourly Rate FormulaSummary: I have a report using the subject area Compensation – Salary Details Real Time and need to add a formula that calculates a base hourly rate. Here is what I'm lo…JHaden3 121 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Date Match Formula ErrorSummary: Date match formula errors when I run the report. CASE WHEN "Work Relationship Details"."PER_PPS_LEG_DDF_ST_BS_SR_STRT_T_" = "Workforce Management - Worker Assig…
-
Provide Participant Feedback" link text needs to be changed in BI notification templateSummary Provide Participant Feedback" link text needs to be changed in BI notification templateContent We need to change link text in notification however unable to find…
-
OTBI Report Performance IssueSummary: OTBI Report Performance Issue Content (required): Hi Team, We have developed the turnover dashboard using "Workforce Management - Workforce Trend Real Time" sub…Vasanthakumar Ravi 81 views 1 comment 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
Need to configure HCM infolets in Newsfeed SpringboardSummary Need to configure HCM infolets in Newsfeed SpringboardContent Hi All, I want to know the priviledges for showing only HCM infolets. By default, it is showing CRM…Ravi Singh 68 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP table for pending approval assignees?Summary: We want to be able to get the list of assignees from an approval process/transaction, before it is completed. Content (required): If an approval process is stil…User_2025-02-12-18-16-11-815 51 views 2 comments 0 points Most recent by User_2025-02-12-18-16-11-815 Reporting and Analytics for HCM
-
Turnover -Month on MonthSummary: I am looking for calculating turnover 12 months from a certain date month by month. But I want the period start date to remain the same as the start month of th…
-
Most recent salary record (Active and Termed)Summary: I have a report using the subject area Compensation – Salary History Details Real Time. I need the report to display only the most recent salary record for both…
-
Need inputs to display Dependent and other information side by side in OTBISummary: Need inputs to display Dependent and other information side by side in OTBI Content (required): We developed Benefit OTBI report. Currently if an employee is ha…
-
Image stored on Web content Server not getting displayed in the Email Output after scheduling ReportSummary: Hi, We have created a check-in on content server to store an image and we are using that link in a report. The link is working fine when tested directly. We als…Abhishek Bhawalkar 141 views 5 comments 0 points Most recent by Abhishek Bhawalkar Reporting and Analytics for HCM
-
OTBI Reports of ORC - Job Requisitions not open yet - Field Status come filtered and only show opeSummary I´m trying to create a report to list all job requisition that are in a phase before been publish or open to publish. But whe I add Phase field from phase histor…Christian_Kaladjian-Oracle 39 views 6 comments 0 points Most recent by Bounmy Reporting and Analytics for HCM