BI Publisher
Discussion List
-
sql query to get the Legislative Info and Associated Profiles associated with job in oracle fusionI need to fetch job code, job name ,Overtime Status under Legislative Info and details of Associated Profiles associated with job in BIP reportAnjali_Kumari4121 597 views 1 comment 0 points Most recent by GowriTatikonda Reporting and Analytics for HCM -
BIP report RTF template excel output type date formatting issueSummary: Hi, Trying to show BIP report output data in excel using RTF template, but when we click on the output data column in the excel data file , the date value showi…Phani S-Oracle 466 views 5 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
How to rename the Remote File Name, in order to display hour and minuteSummary: How to rename the Remote File Name, in order to display hour and minute Content (please ensure you mask any confidential information): Hi, we scheduled a BIP re…Barile Alberto 47 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
BIP Bursting - Linked OTBI Reports HelpHi all, I'm wondering if anyone has a solution to a challenge I've encountered recently. I have two OTBI reports, a feed and a report where the report links to the feed.…MikeW 16 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to run the Talent Profile seeded report?Summary: I need to export an XML file, but I won't be able to view all the fields and content sections. See below parameters used: Version (include the version you are u… -
We need to send files to Microsoft teams Through any automated processWe have a BIP report that needs to scheduled on a daily basis and we want to store those output files in Microsoft teams under Files Section. We don't want to store them…Kunal_444 19 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Table to get the Time Card Required field in Payroll Relationship page.Summary: We have a requirement to pull the "Time Card Required" field on the Payroll Relationship page. But we are unable to get the table. Please help me with the table…Rengaraj G 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
How can we find the path of the report being referenced in a dashboard within OTBI/catalog?Content Hi All, Is there a way to find the path of the report that is referenced in a dashboard? We have several custom dashboards built by various people within the org…PriyaPenugonda-SC 781 views 5 comments 0 points Most recent by Gokul Reporting and Analytics for HCM -
SQL query to fetch Division, BU and Department namesSummary: Hi Team, We have created a SQL query to fetch Inactive employees AOR. We would like to fetch division name, Department name and Business unit name also in the s…Ooha Pranathi Akkala 4.2K views 12 comments 0 points Most recent by RyanPasca1 Reporting and Analytics for HCM
-
add date conditionSummary: Hi Everyone, I need your assistance in regards to add a date condition in analysis. I have to add a condition in the where clause and want out those positions. …
-
query or table in service request managementSummary: We need to identify tickets that are not addressed for those requested information /response is already provided in Oracle service request management. We have c…
-
What tables to use to pull Learning Class Training Supplier?Summary: Need to find which database tables to use to pull 'Training Supplier' found in Oracle HCM Learning Classes Content (please ensure you mask any confidential info…marcfromhawaii 346 views 4 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
How to exclude null values in eText output using RTF templateSummary: Example: My output file is comma separated .txt file generated using RTF template for HCM extract. I have 25 columns, out of which first 5 columns are fixed i.e…Shilpa Varghese 204 views 3 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM -
Scheduled Report randomly times out.Summary: Hi, We have a data model report that pulls related Personal, Assignment, Comp and Payroll data for all Active employees based on an effective date parameter, th…BDO Sue Cronin 17 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
User Role Audit ReportSummary: User Role Audit Report - We want to see when changes were made, who made the changes, what change was made, what role to user is added or removed Content (requi…SAKTHI SUNDAR 119 views 5 comments 0 points Most recent by User_BN0QX Reporting and Analytics for HCM
-
Assignment Manager (Unsecured) Dimenssion in Goals Real Time SASummary Data Role Data security not working in OTBI, when using the Assignment Manager (Unsecured) Dimmension in goals Subject areaContent Hi Team, We are using the Dime…User_2025-01-23-22-36-48-692 55 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
I would like a way to report that includes the following information in one report:Approval Status: Details of the goals. Pending approvals indicating whether they are with the HR manager or department. Goal details before HR approval: To allow review …
-
How to adjust the alignment of the bar graph for charts function in RTF Template of BIPSummary: Hi Team, The goal is to display a bar graph in RTF Template with question vs ratings. How to adjust the alignment of the bar graph for charts function in RTF Te…Harini Sairam 19 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
createException: Security violation... permission: 16578Summary: I created a report but a few users receive this error message, why? Content (please ensure you mask any confidential information): Version (include the version …Stefano_Mazzocca 500 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Cancel scheduled reports in oracle fusionSummary: Cancel scheduled reports in oracle fusion Content (please ensure you mask any confidential information): Version (include the version you are using, if applicab…
-
How to get full length sentence of a label in bar graph for charts function in RTF Template of BIPSummary: We do have feedback questions and ratings against each question. The goal is to display a bar graph in RTF Template with question vs ratings. How to get full le…Harini Sairam 17 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to SUM G_1, G_2 and G_3 in DATA_DS summary record for ETEXT template?Summary: we have 3 Records as G_1, G_2 and G_3 and need to show the total number of records in each of them have to be sum and display in DATA_DS in E-text fixed length …Vinay Prasad 33 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
BI Publisher is limited in Storage?Summary: Does anyone know, What is the maximum volume of gigabytes that can be stored in different file formats? Regards, Content (please ensure you mask any confidentia…Hernan Modlin-Oracle 7 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Need to create a report on the bursting job history detailsHi, We have a job which triggers letter to employees. We need to create a report wo whom and all the letter is triggered from job history. Can you help me with the table…Shanmukhi 20 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to correctly write a BIP query in the OAC environmentSummary: Obtain the value list of launch parameters in a BIP report on the OAC environment Content (please ensure you mask any confidential information): Hi when I write…AM HRE 26 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Is CRC32 function supported by Oracle fuion BISummary: Is CRC32 function supported by Oracle fuion BI Content (please ensure you mask any confidential information): Version (include the version you are using, if app…Ishtiaque AHmed 31 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
What can be the sql query to determine the person address subject to LDG address configuration?What can be the sql query to determine the person address which satisfies the condition of having all the mandatory address field by the person LDG address configuration…
-
Query to get Report run History in Fusion HCMSummary: Query to get Report run History in Fusion HCM Content (required): Hi All, Can we get the detail who all have run the BI report, is there any query available. He…Swati U 1.7K views 11 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM
-
Report on Career AmbassadorHi, is there any Oracle HCM table available to report employees who signed up for Career Ambassador?Francesco Cerioni 25 views 5 comments 0 points Most recent by Francesco Cerioni Reporting and Analytics for HCM -
Global Talent Community Pool data not visible in OTBISummary: Hi Team, We are using OTBI to fetch data from the candidate data belonging to "Global Talent Community Pool". However, we are getting only one record having sta…