Category 81
Discussion List
-
Subject areas to make analysis of BPM Transactions in OTBISummary: Subject areas to make analysis of BPM Transactions in OTBI Content (required): I need to make an OTBI Report to show the detail of BPM Transactions, including t…Hameed 81 views 1 comment 1 point Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM -
We need basic details of time card submission details in BI or OTBISummary: HI Team, We need basic details of time card submission details in BI or OTBI. person details. time card submission details, project name, etc. Thanks, Ajay Cont…AjayKumar Maddipati 26 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM -
Get rid of white space at the top of a tabular reportSummary: Has anyone experienced a large white space at the top of a tabular report. Please see attached screenshot. Content (required): Has anyone experienced a large wh…
-
Need SQL Query to fetch the Advanced Mode Absence Duration in Absence RecordsHi Experts, Could you please help me on SQL Query to fetch the Advanced Mode Absence Duration in Absence Records. Thanks, Nagaraju.Naga raju Ibba 323 views 4 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Is there a way to pull comments section off Requisitions and Offers into reports?Summary: Pull the Comments field from Job Requisitions and Offers into reports Content (required): Looking to be able to pull the Comments field from Job Requisitions an…
-
BI Publisher Bursting Email from Company Domain IDSummary: Hello Experts, We have a requirement to trigger emails from our company domain ID (@companyname.com) while triggering emails from BI Bursting. We don't want the…Gourabh Choudhary 156 views 3 comments 0 points Most recent by Gourabh Choudhary Reporting and Analytics for HCM
-
Primary Email in Oracle TablesSummary: Hello. Could you please advise which table contains Primary Email? I'm building a BIP data model using query below. There are email type and email address inclu… -
Reporting the Career Development screenHi, I want to generate the data sql report on the My Team>>>Career Development screen. But I can't find the table where this information is kept. Can you help and share?…Cansel Karasoy 64 views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Schedule Report to Run Prior Month/QuarterSummary: Currently, only a few HR members can run reports, no one outside of HR can. If they need a headcount roster or turnover, I would run the report for them. There …Ratha Sun 146 views 11 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
Compensation Approval Chain in OTBI ReportSummary: How to view all managers who approved a compensation change? Content (required): On the front end I can see for each compensation change, a list of managers who…s_b 59 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Passing parameters from a UI page to html opening BIP Report doesn't work anymoreSummary: Passing parameters from a UI page to html opening BIP Report doesn't work anymore Content (required): Hello Experts, I'm facing an issue when passing a paramete…Dario_DiFranceschi 54 views 4 comments 0 points Most recent by Dario_DiFranceschi Reporting and Analytics for HCM
-
Dashboard screen customizationI have a dashboard report that I have prepared with parameters and I want the parameters to look like the screenshot. I couldn't find how to make the background visually…Cansel Karasoy 25 views 7 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM
-
Email-Bursting Without Split-ByWe have a requirement to send an email with details. The email body should have the details with table format. The query has more than one record and it should be printe…
-
Need table name to fetch 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen.Summary: Dear Experts, Which table stores the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached Screenshot for your reference. Than…
-
How to determine timing delay how long does it take for data to be committed to the audit tables?Summary: We receive ad hoc tasks from business every time there's a compensation refresh happening. This process contains updates in the Assignment and Salary Section of…
-
Can we build a single report for BIP or OTBI and then restrict columns for different users.Summary: We have a requirement to build one report and then send it to multiple users with different combination of columns. Content (required): Hi Team, We have a requi…Vikas V. Kamat 51 views 9 comments 0 points Most recent by Manoj.Gupta Reporting and Analytics for HCM
-
Regular Temporary column from Workforce Management - Worker Assignment Event Real TimeSummary: There is no "Regular Temporary" column in the "Assignment Event Details" folder from the Subject Area "Workforce Management - Worker Assignment Event Real Time"…Chan Jun Yu 53 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
What can we do so that OIC applications do not use license limits?Hi, What should be done to prevent the versions created for the live and test environment from using license limits in the applications we develop in the OIC environment…Cansel Karasoy 24 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Position hierarchy report prepared from Oracle AnalysisHi, I am preparing a position hierarchy report using an analysis report. How can I find the person in the next position of a position? RegardsCansel Karasoy 54 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Agent - would like to see why it failed to runSummary: Is there a way to see the reason for an Agent's failure? Content (required): When an Agent fails to run and deliver an Analysis, we can see that it Failed (unde… -
Interview Feedback Report - BIPSummary: I need to create a feedback report , where we need to fetch responses Content (required): These are some of the fields that I am trying to fetch in the report. …Sushant Srivastava 77 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Control Infolet visibility on HCM Home page based on person GenderSummary: Control Infolet visibility on HCM Home page based on person Gender Content (required): how to control Infolet visibility on HCM Home page based on logged in per…Nirmal Ignatius 17 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Way to restrict the options in Output Tab during BI Report SchedulingSummary: Content (required): Hi All, Is there a way to restrict the options in Output tab not to be modified during BIP Scheduling? Example - if bursting is enabled in r…Ramanathan Sockalingam 43 views 5 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
Valid Grade Report-Multiple Grades on jobs auditSummary: We are trying to run a report on all the active valid grades associated with a job, to audit and clean up any that may have multiple grades associated with the …Tammy Hemmingson 45 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Restrict Security Groups available under Content Server DestinationsSummary: When running an HCM report through BIPublisher, you can send the output to the Content Server. We would like to remove the ability to pick these options from th…Terri Woodard-TI 30 views 2 comments 0 points Most recent by Terri Woodard-TI Reporting and Analytics for HCM
-
Requisition creation "use", which subject area is this data housed in?Summary: Trying to report on the requisition "use" field; see screenshot below, but unsure of which subject area this may be housed in? Content (required): Using the sub…Cheryl Calsetta 65 views 4 comments 1 point Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
OTBI Report in Workforce Goals - Goal Status Overview Real Time, Unable to add Organization LevelsI am building an OTBI report in a single subject area (Workforce Goals - Goal Status Overview Real Time). I am able to add Development Goals details from the "Developmen…rd17 146 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Why am I unable to report on the ratings given within a completed performance document?I need to be able to report on the ratings given by the manager for a pre-assigned performance document. I am using the Workforce Management - Performance Rating Real ti…Helen Tilling 65 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Are Deduction Code; Deduction Amount and Deduction Factor available in OTBI or Oracle HCM BI tables?Summary: Content (required): Hello experts, are Deduction Code; Deduction Amount and Deduction Factor available in OTBI or Oracle HCM BI tables? If so, could you share t…Valerio Curzi 47 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Document Record Deep Link in SQL Query - use parameter regarding uploaded document record IDSummary: There is a requirement for BI report to have direct / deep link to a document record for persons Content (required): I found the Deep Link URL and several of it…Shant Sarkissian_NES 422 views 3 comments 1 point Most recent by Balaji Vijayakumaran Reporting and Analytics for HCM