Category 81
Discussion List
-
How to know recipients of bursting report that is not job history?Hi, we have many scheduled BI Publisher reports leveraging Bursting functionality to send emails to many recipients. Our client has the requirement to report on those pe…Fabio_Testa 115 views 9 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
In OTBI report when I schedule the report through agent to me or others all records not coming?Summary: HI Team, We have head count details report with nearly 41000 records and we are used only one subject area(worker assignement real time ) with 25 cloumns so iss…AjayKumar Maddipati 43 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Sick Leave Duration greater than XX days over a rolling periodSummary: We are trying to report on employees who have recorded more than 40 days of sick leave in a rolling 365 day period. Content (required): We have used Leave Durat…Emily Robinson 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Default Language in OTBI subject areasSummary: Hello, Do you know which subject area contains employee's "Default Language"? I've created a report presenting default languages in BIP, but it needs to be recr… -
How to send attachments from BI publisher?Summary: How to send attachments from BI publisher? Content (required): Hi All, We got a requirement to send a onboarding notifications for the new hired employees with …Venkatesan 22 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
OTBI Agent Sender Name ChangeHello Experts, Need your help & suggestions for the below issue that we are facing recently. We changed the OTBI Agent Sender Name by raising an SR to Oracle Support. It…Bhaskar Konar 41 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Need OTBI report showing all active employees AND whether or not they are enrolled in MedicalSummary: I have been asked to develop a report that shows all active employees (Assignment Status Type = Active) and include a column showing the medical plan name they …JHaden3 305 views 2 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Need help with CASE formulaSummary: I'm using this formula in an OTBI report (using WFM Worker Assignment Real Time subject area). The formula should do this: If an employee hire date is
-
Not able to add the BI report in View Analytic pageSummary: Content (required): Hi All, We have created a BI report and we want to add this report in the talent review meeting in View Analyst option, but when we are tryi…Faizan Rashid 23 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Serial numbering in the reportHello, In a notification I prepared, I would like to give a serial number to the document that will be sent to the people in that month. For example, document no;01 docu…Sinem Kara 23 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
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 68 views 1 comment 0 points 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 22 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 306 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…
-
BIP Report is taking more time while Using Bursting, Without Bursting it completes in 10 minSummary: Custom BIP Report is running for more than an hours and it is not bursting output to FTP(secure) while using bursting query. But when we are running the same re…
-
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 137 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 63 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 141 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 51 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 52 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 22 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 52 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 52 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 22 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 55 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM