BI Publisher
Discussion List
-
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 284 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 155 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 12 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 117 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 51 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
retrieving timestamp is not giving correct date and timestamp from Table PER_EXT_APP_IDENTIFIERSSummary: retrieving timestamp is not giving correct date and timestamp from Table per_ext_app_identifiers Content (please ensure you mask any confidential information): …
-
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 12 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 361 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 12 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 18 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 1 view 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 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
SQL query to retrieve Division Name and Manager division display nameSummary: Content (please ensure you mask any confidential information): Hello experts, I need to extract the Manager Division full name field and the Division name as we…Valerio Curzi 412 views 4 comments 0 points Most recent by Valerio Curzi 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 22 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 21 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.6K 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 21 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…
-
Certification: Retrive attachments information with OTBI or BI PublisherHello, our customer asks to retrive the information associated to the attachments section of certifications (URL and PDF), is it possible? if so, how? Any advice? Thank … -
Query to get interview details for a job requisition using BI ReportSummary: Hello Team, I am trying to get interviewer details (Interviewer person number and email address) using below query but I am not getting the right results. Can a…HCM_Rahul 348 views 4 comments 0 points Most recent by Girish Kushibi Reporting and Analytics for HCM
-
HCM secured views - listHi, Can you please suggest where can I get all the list of secured views for HCM? Thanks in advance. Version (include the version you are using, if applicable): 24C -
CertificationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Vijay Kumar Reddy 2 views 1 comment 0 points Most recent by Harish Vummidi Reporting and Analytics for HCM
-
Is there a way in BIP PL SQL to retrieve where the transaction has been done?Hello Experts, for example, the transaction was done in Me Tab, then PL SQL will tell that this is Me tab page, or in a My Team page. I am currently creating a transacti…Joliver Caangay 4 views 1 comment 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM
-
Is it possible for Oracle Tables for all HCM transactions including archived transactionsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Can anyone please share the best practice to create BIP Report template having more than 50 columnsSummary: Can anyone please share the best practice to create BIP Report having more than 50 columns I have a requirement to develop a BIP report having 54 columns and he…Kundan Kumar17 14 views 0 comments 0 points Started by Kundan Kumar17 Reporting and Analytics for HCM