BI Publisher
Discussion List
-
Timezone used by time parameter is always in GMT. How can I let user pick the timezone when enterinContent I have a BIP report with a parameter with a time component (It is a date type with a date string of" MM-dd-yyyy HH:mm:ss am"). What I am noticing is that date en…Joe Roberts-Oracle 38 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
In which report Enterprise name along with organization structure is displayedContent Hi Team, Do we have any report which displays Enterprise name alone with org structure details like Enterprise, division and so on. Kind Regards, Rahul -
Adding run_result_values for multiple element_names in OTBI analysisSummary Need help in OTBI analysis with adding the run_result_values for different element_namesContent Hello Everyone, I am new to OTBI analysis and I need help with co…GauravGupta39 19 views 3 comments 0 points Most recent by GauravGupta39 Reporting and Analytics for HCM -
How to display embedded dashboard only on a custom page categoryContent Hi Team, I have embedded a dashboard on homepage springboard. Now that dashboard is embedded to all tabs of the springboard. 1) Is there a way to embed it only t…Punam Roy Karmokar 27 views 1 comment 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM -
Need Help : 9 BOX Talent ReviewContent Hi Expets, I have been looking catlog or some kind of link form which we can build or design 9 BOX Talent Review. Tried in different sources and not able to find…Kiran Kancherla 38 views 5 comments 0 points Most recent by Aparna Damle Reporting and Analytics for HCM -
Post 21B release HRC_TXN_DATA.Data cache column doesn't show XMLSummary Approved/Rejected Global transfer transaction XML data is not coming up in HRC_TXN_DATA data cache column.Content Hi All, We are aware of HRC_TXN_DATA data cache…Hari Arumugam 39 views 1 comment 0 points Most recent by Sahil_Makhiza Reporting and Analytics for HCM -
Briefing Books FunctionalitySummary Briefing Books FunctionalityContent Hi All, I would like to know the briefing books functionality, Please share the briefing book document or session video if an…[Deleted User] 40 views 2 comments 0 points Most recent by [Deleted User] Reporting and Analytics for HCM -
DATA_CACHE column deprecation from HRC_TXN_DATA tableContent We are currently on Oracle HCM Cloud 20D. We have a scenario where we need your suggestion/feedback. Oracle is deprecating DATA_CAHE column from HRC_TXN_DATA tab…Abhishek_Jain 95 views 2 comments 2 points Most recent by Hari Arumugam Reporting and Analytics for HCM -
Mail Merge TemplateSummary Create a document that will populate certain fields directly into the documentContent Looking to create a document i.e. VOE that will grab and populate the data … -
Report Recipient's list ReportContent Hi All, Is there any way to get Report for all recipients list. Recipient Name Report Name Frequency abc Report1 Daily xyz Report 12 Monthly Thanks, VijayUser_2025-02-07-19-03-14-525 31 views 1 comment 0 points Most recent by Prudence K Reporting and Analytics for HCM -
Do we have any report to see configured Approval Rules?Content Hello, We need a list of all HCM related processes for which approvals are configured in system. Do we have any report or query through which it can be extracted…Devanshi Fulvani 29 views 2 comments 0 points Most recent by Devanshi Fulvani Reporting and Analytics for HCM -
Need help with BI publisher reportSummary Need help with SQL for BI publisher ReportContent Hello, I have a BI publisher report that is run at the end of every pay period to provide payroll information o…GauravGupta39 52 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
How to schedule BI report only when it has dataContent Hi All, Can some please help me if its possible to schedule BI Report when there is data. I know we do it in OTBI in condition tab. Thanks, VijayUser_2025-02-07-19-03-14-525 41 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
How to stop dashboard auto runSummary How to stop dashboard auto runContent Hi Team, Greetings of the day!!. Dashboard is getting auto run even the parameter was not passed in oracle fusion. Is there…Vasanthakumar Ravi 240 views 4 comments 0 points Most recent by Seiichiro Yasui Reporting and Analytics for HCM -
questionnaire joins to the candidate in BIPSummary how to join the questionnaire and answers to a specific candidate in BIPContent Hi, I am developing a report in BIP which displays the questions from the questio…Iann hick 43 views 5 comments 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM -
Drill down report not showing up for a specific userSummary Drill down report not showing up for a specific userContent For viewing the Drill down report does the user need any special security? The user can able to see t…Prabhu Krishnamoorthy 8 views 2 comments 0 points Most recent by Prabhu Krishnamoorthy Reporting and Analytics for HCM -
Is it possible to have conditional Display of report parameters on the basis of value in other paramSummary Is it possible to have conditional Display of report parameters on the basis of value in other parameter ?Content Hi Experts, Is it possible to have conditional …Abhishek Sood HCM 185 views 6 comments 1 point Most recent by Abhishek Sood HCM Reporting and Analytics for HCM -
Excel based Template Report- Does not provide PDF export optionSummary Excel based Template Report- Does not provide PDF export optionContent One of our BI Report, The Report was created using an Excel based template (Means: Created…Prabhu Krishnamoorthy 20 views 2 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM -
What is Talent Rating Subject areaContent Hi Team, We have the talent rating where we have, Performance rating, Risk of loss etc. Is there any possibility to get the from OTBI? I know, We can get through…User_2025-02-11-13-25-48-351 28 views 2 comments 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM -
BI publisher SQL for finding users who are active in the security console but terminated in the applContent Hi experts, We have found an issue where sometimes when an employee is terminated in HCM they are still showing as an active user in the security console. To res… -
Create Custom Subject AreaContent Hello experts We need to do a dashboard with an easier layout to deal with. and better UX then Publisher native Is it possible to use a query and create the subj…Pedro Teixeira 26 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Issue with Views in HCM cloud Learning Management (WLF_LRNR_COMPLETION_DETAILS_V) in SpecializationSummary Joins are missing in the Specialization item type part in the Views WLF_LRNR_COMPLETION_DETAILS_V and WLF_LRNR_COMPLETION_SUMMARY_VContent In the code of the vie…Rajesh Ravikumar 47 views 2 comments 1 point Most recent by Rajesh Ravikumar Reporting and Analytics for HCM -
How many columns can report based on Excel Template have?Summary How many columns can report based on Excel Template have?Content Hello. I am busy creating a data migration extract (BI Report) that contains a lot of fields. I …IanDeKoker 29 views 4 comments 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM
-
Oracle Documents of Records linkContent Hi Guys, Is there a OBIEE BIP SQL CODE code that can turn the column value into a clickable link, please see image for reference. Here's my current sql code. tha…User_2025-02-05-11-53-59-507 32 views 2 comments 1 point Most recent by Seiichiro Yasui Reporting and Analytics for HCM -
Base Salary and Payroll elements tablesContent Hello experts, I need to extract by SQL compensation data for a specific employee. Do you know in which table I can find the following information: -Base Salary …Valerio Curzi 44 views 5 comments 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
E-Sign Policy documentSummary E-Sign Policy documentContent Hi All, We have a requirement to create BIP template using provided Onboarding Policy template(.RTF). In the Template we need to ad…Prabhu Krishnamoorthy 41 views 2 comments 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM -
call Dashboard from HCM page -how to keep BIP paramsContent MY BIP report has two params (one dependent on another). I need to create a dashboard and display the dashboard under 'My Client Groups'. I did it all. However, … -
BIP SQL to show the Emplid, Name and Today's date of the Login userSummary BIP SQL to show the Emplid, Name and Today's date of the Login userContent I am creating template report which should automatically show Emplid and name based on…Prabhu Krishnamoorthy 92 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
per_addresses not having dataSummary per_addresses not having dataContent I don't see PER_ADDRESSES TABLE GETTING POPULATED, Instead the tables like per_addresses_f is having data but the per_addres…Prabhu Krishnamoorthy 533 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
List of Core HR Audit Tables - For Building Audit report in BIPSummary List of Core HR Audit Tables - For Building Audit report in BIPContent Can anyone provide me the List of Core HR Audit Tables - For Building Audit report in BIPPrabhu Krishnamoorthy 47 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM