BI Publisher
Discussion List
-
Need to create a BI report to See What Jobs Are Scheduled Along With Frequency, Start and End dateSummary: Hi All, We've a requirement from the customer where they need to create a report to See What Jobs Are Scheduled Along With Frequency, Start and End date. Can so…Sandeepan Rana-Oracle 22 views 3 comments 0 points Most recent by Sandeepan Rana-Oracle Reporting and Analytics for HCM -
What table is storing Change working hoursHi Team, Which table is storing change working hours information? Any sample will be helpful.
-
how to bulk download the attachments in report job historyHi Team, I have a requirement to download the output name (attachments) in the Job History. But when I download the files it's coming in the XML Format. can anyone tell …Haritha 25 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Unable to get the proper count for Assignment Count when I am using two subject AreasSummary: Hi Team, we have requirement to get the count for Nationality to get this column we are using 'Person Real time' Subject Area. and we also have to filter this c…Ashok Dhara 11 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
I need query to get expense approver nameDoes any one have query to get expense approver nameSwati U 219 views 2 comments 0 points Most recent by Stephen Westerfield-Oracle Reporting and Analytics for HCM
-
Subject area/database table for historical manager hierarchySubject area/database table for historical manager hierarchy Client is interested in building dashboards to show different HR metrics for which historical manager hierar…
-
Data Model throws a nullpointer exception while trying to retrieve dataSummary: I have created a data model with 2 data sets (one for employees and one for Contingent workers) - I have created an Excel Template that has 2 tabs for the data …User_2025-02-04-08-51-08-912 283 views 3 comments 0 points Most recent by John Peter Noble-Oracle Reporting and Analytics for HCM -
How to setup dynamic filters in BIP report?The dynamic filter should adhere to the following logic: Year: If today falls between February and December, use the current year. If today is in January, use the previo…Janardhan ACS-Oracle 25 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
Calling an external image in bursting using tokensHi We need to call an external image in the bursting query. by passing token. Please help in achieving this. Regards, ShanmukhiShanmukhi 11 views 3 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
Profile id not available for some employeesSummary: Profile id not available for some employees Content (please ensure you mask any confidential information): Hi experts, we want to create a report that retrieve … -
BIP Report Job History RetentionSummary: Hi, How far back can we view Report Job History in Oracle Fusion? Is this the right answer? I want to be able to download the reports like in first picture. I h…
-
Pull a list of custom OTBI and BIP reportsSummary: Hello everyone, Is there a way to pull a list of custom OTBI and BIP reports? Thanks and REgards Content (please ensure you mask any confidential information): …
-
is there any way to hide the rows in excel using bi publisherSummary: Hi, I am new to bi publisher and wanted to have this in my report template using excel. is there any way to hide the rows in excel using bi publisher that is be…
-
DOJ from date and to date , DOE from date and to date parameter not working in BIP reportHello , I have create Date of Joining date parameter and Date of Exit parameter, however when user try to select dates and filter records , records are not getting filte…
-
Report detailsHi, There are lot of reports we are using and we want to know security of each report. Is there any way to find out below details from system 1)List of reports 2)Roles/p…Namrata_20 21 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
can we use fetch multiple columns using single case statementHi Team, i am using the case statements as below to retrive the data for a single person but it is giving me the 4 rows for same person is there any way to group them al…Chetana Pawar 21 views 1 comment 0 points Most recent by Swathi Shetty Reporting and Analytics for HCM
-
Costing of PositionContent Hi All, I am trying to get the Costing of position in SQL query. Does any have the SQL which can give the costing details of position. Thanks,Misbahul Khair-266763 427 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Journey report - display 'Saved as Draft' status in the reportHello, Related to Journey, I want to create a report that shows the task's progress status for each performer. In case of the performer saves the task as "Saved as Draft…Liran 23 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
Days of service calculationHi Team, I am using "Workforce Managemnet - Work Relationship Real Time" subject area and I want to calculate "Days Of Service" only for Terminated employees. I want to …Raghu_Nandan 21 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
How to use an SQL query to select records of elements whose value was changed by CORRECT?Hello everyone, How to retrieve with an SQL query records of elements whose value was changed not by UPDATE but by CORRECT, is it in the HRC_EVT_OBJ_CHANGE_COMPONENTS ta…Alex_Balanovsky 73 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
debugging an errorSummary: debugging an error Content (please ensure you mask any confidential information): Hello everyone, I am getting this error when running a report in PROD but not …
-
Seniority date blank on front end but populated in PER_SENIORITY_DATES_F TableSummary: For many employees Seniority date is blank on front end but populated in PER_SENIORITY_DATES_F Table. I noticed TOTAL_ADJUSTMENT_DAYS is Negative and if I add i…Seema Kalantri 23 views 3 comments 0 points Most recent by Seema Kalantri Reporting and Analytics for HCM
-
How to get the Name equivalents of RECRUITING_LOC_HIERARCHY_ID and RECRUITING_ORG_HIERARCHY_ID?I'm trying to get the Recruiting Type, Recruiting Location Hierarchy and Recruiting Organization Hierarchy from the Areas of Responsibility - Scope section, but I only h…
-
How to distinguish the output file basing on the scheduling dateSummary: How to distinguish the output file basing on the scheduling date Content (please ensure you mask any confidential information): Hi, we created a BI report; the …
-
Report to get cost center and account from time management (OTL)Hi Experts, I have an requirement to fetch Cost center and account from time management page. Please check below navigation and Image to identify requirement. My Client …Rajdeep Chavda 11 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Query or table to get the employee work schedule as of the leave start dateSummary: Hi Every one, Do any one have any query to get the employee work schedule as of the Leave Start date . The requirement is when employee applied the leave, I nee…Charan Kollipara 700 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Is there a way to get new and old value for an object in OTBI without logical SQL?is there a subject area that inherently stores old and new values of objects like department lAloka Bhattacharya 51 views 5 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
Observation Checklist Link not found in Oracle TablesHow is the observation checklist link/URL being created or generated to use for notification? Can it be found in Oracle tables? Where could the link be stored? Is there …
-
Need a sample SQL for HDL Summary ReportSummary: I'm trying to create a HDL summary report, where I wanted to fetch the Submission Time, Finish Time and Elapsed Time which I'm unable to find the exact table. P…Sujeeth Chinta 23 views 4 comments 0 points Most recent by Sujeeth Chinta Reporting and Analytics for HCM -
Retrieve Person addressesSummary: Do we have any package function to retrieve the person addresses? Please share. Content (please ensure you mask any confidential information): Version (include …MilanMohanty 21 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM