BI Publisher
Discussion List
-
We have OnBoarding_15Days_Report but timeout error coming on below querySummary: Hi Team, we have OnBoarding_15Days_Report its runing ok but few days onwords we getting error is timed out error, we apply one year durationand even schedule al…AjayKumar Maddipati 42 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Fetching column for employee Feedback(in PD) whether it is completed/bypassed in OTBI reportsSummary: I have a requirement to add one column in OTBI report to fetch the status of employee feedback if is completed or bypassed. Can we use SQL query to fetch the de…Kamini Kaushik-Oracle 11 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
MAX functions for payroll element effective start dateSummary: Content (please ensure you mask any confidential information): Hello experts, I need to extract the most recent effective start date for a payroll element loade…Valerio Curzi 44 views 11 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Need a sql to get "extra info" on "position details" pageHi All, I'm trying to find SQL tables and joins behind getting "Regulatory Licence Information" under Extra Info Section of Position Details. Navigation : Set up and Mai…
-
Oracle BI Tables to retrieve last payroll element entries amount and last dateSummary: Content (please ensure you mask any confidential information): Hello experts, which BI tables collect data related to payroll element entry last amount and last…Valerio Curzi 31 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
SQL to retrieve employee name,person number,department name and department DFF detailsSummary: SQL to retrieve employee name,person number,department name and department DFF details Content (required): Hi All, Please share SQL to retrieve employee name,pe… -
How to create User defined table (UDT)Summary: How to create User defined table (UDT) with screen shorts. Requirement: i want to store the below data in User defined table & which table can store this inform…Ravindr-Oracle 11 views 3 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
How post a copy of the burst output to the UCM/content server so a web service can get the fileSummary: We have a burst report which goes to workers when they terminate that we would like to archive to our doc management system. In order to do so we need to post a…Mario Lieras 17 views 2 comments 0 points Most recent by Mario Lieras Reporting and Analytics for HCM -
How to customize BICC to control data that can be accessed by BI teamSummary: Hi All, We plan to use BICC for pulling data out of HCM but our HR team is concerned on the data access front. We feel like the BI team will have access to sens…
-
Offers Report not pulling dataSummary: Content (required): Anyone experiencing data not pulling through on OTBI analysis reports created using subject area: Recruiting - Recruiting Real Time? Anyone …
-
HCM native datamodels/bipSummary: are there another schema.table wich sample reports delivered in HCM Cloud are stored to extract a list of them ?? Content (please ensure you mask any confidenti…
-
csv output giving multiple date format while using etext templateSummary: I have built a report to display a date column in dd-mm-yyyy format using etext template. the report output is displayed in text or csv. In both the cases when …Nisha_Hegde 74 views 9 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
SQL instruction to join data from 2 or more BI tablesSummary: Content (please ensure you mask any confidential information): Hello experts, which instruction when building queries in data models allows me to join two or mo…Valerio Curzi 15 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Connections BIP report - how to remove HTML tags?Summary: Hello, I've created a BIP report for Connections. Could you please advise how to remove HTML tags? Please find SQL query attached. Kind regards, Marta Content (… -
How to remove the duplicates in rtf templateSummary: Currently using the three Data sets in the report First DS will contain the employee details,legal employer name ,Dept id and element amount Second DS contains …
-
Add parameters to BIP report URLHello, Is it possible to add parameters to a BIP report URL? My report BIP URL: https://***/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=****%2FF…
-
How to capture employee working as a manager in Employee details oracle BIP reportSummary: What is the table and column to capture working as a manager column, to write a employee details BIP report. Content (please ensure you mask any confidential in…
-
Issue while configuring BI Publisher ReportSummary: Hi, I've configured the BI Publisher files custom folder but not able to see the folder after Upload successfully done. Do you have any suggestions? Need your h… -
Is it possible for rich text format stored in a Data Field to display as Rich text in a report?Summary: We are using Rich text format in Questioners in Carrer conversation. Content (please ensure you mask any confidential information): 1.Thinking big, what do you …challa praveen 22 views 2 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM
-
Learning BIP Report Table LogicSummary: Hello, The current BIP Report we have in our org is based on the Learning Assignments Table (WLF_ALL_ASSIGNMENTS_V). However, we had an issue that a person was …
-
xmlpserver: RTF Template for quick action Change AssignmentWe were able to locate RTF templates for Person Management changes on the xmlpserver, but we were unable to locate quick actions like Change Assignment RTF templates. Th…Ashok Kumar Sharma 13 views 4 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
Workflow Notification TranslationsSummary: Workflow Notification Translations Content (please ensure you mask any confidential information): Hi , When we customize seeded notification and make copy of it…
-
Enabling BPFM Notification and Template customisation for Goal ManagementHi Team, 1)Can we include BPFM in Goal FYI notifications? 2) How to bring supervisory in Goal FYI notifications rules in "THEN" Condition and which rule is triggering no…
-
How to resize Rows and Columns in OTBI reports?How do I set column or cell dimensions to have a consistent format for my report?
-
SQL count of vacant positions in each department for the last three monthsSummary count of vacant positions for each department group by the last three monthsContent Hi, I am trying to write a sql in BIP to get the count of active vacant posit…
-
Seeded RFT changes take a long time to get reflected in worklistSummary: Hi Team, I've updated the Seeded RFT and it takes a long time(1 day almost) to get reflected in worklist Let me know for any process name to make the response t…Sowmiya Velusamy 32 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Attaching employee image in BIP notificationSummary: I need to attach employee image files in BIP notification . Is this feasible ? if not what are the other alternative solutions? Content (required): Version (inc…Debarun Baidya 21 views 2 comments 0 points Most recent by Debarun Baidya Reporting and Analytics for HCM
-
Do we need to give Username & Password in Bursting Query for ftp delivery Channel?Summary Do we need to give Username & Password in Bursting Query for ftp delivery Channel?Content Hello Experts, I have a requirement to deliver bursting file to ftp des…Anil Pillaresetty 277 views 21 comments 1 point Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
Learning Ad hoc Access Group Deleted From UI are showing Active in BIP tablesSummary: I am fetching all the learning items along with access and access group assigned to them. Once I created access using Access tab under Learner tab I am able to …Kamini Kaushik-Oracle 35 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
BIP Job History Retention PeriodSummary: BIP Job History Retention Period Content (required): I'm trying to give clear guidance to our customer, and I'm unable to find a consistent answer on this topic…CodySisson 131 views 3 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM