BI Publisher
Discussion List
-
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i…Ayoub AFRASS 882 views 5 comments 0 points Most recent by Juan Pablo Gonzales Reporting and Analytics for HCM -
BIP Query Job Roles and the roles assigned to themSummary: I'm trying to create a BIP query that shows me Job Roles and the roles assigned to them. I tried to create the report, but I can only get it to this point: sele…JaimeOrtega 115 views 4 comments 0 points Most recent by JaimeOrtega Reporting and Analytics for HCM -
How to convert RTF template file from LF to CRLFSummary: Convert file from LF to CRLF Content (please ensure you mask any confidential information): I would like to ask on how to use the CRLF in RTF Template. Is it li…MayCab 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Values being truncated at 240 characters in the non-Excel output formatsHow to address those values being truncated at 240 characters in the non-Excel output formats.Ronel M 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Balance trending reportWe have developed a Balance trending report for current & previous check dates. When we are running for a particular employee we are able to see data within 2 seconds, W…JanardhanP 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Building a BIP Report for User Access TrackingSummary: Dear Customer Connect Community, I hope this message finds you well. I am looking to create a BIP Report using standard SQL to track user access within specific…Matheus Roberto 32 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
User All Login Details within a specific periodHello Experts, Below query provides information on Last Login Date. For example, a user last logged in 1st Nov, this query will provide Last Login Details. However, is i…ImSt2509 92 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Payroll - Element Entries Real Time SA not returning car allowance Elements in the reportSummary: I have created an OTBI report with car allowance element entries for two Business units by using "Payroll - Element Entries Real time" subject area, each BU hav…Hitachi ServiceDesk 12 views 0 comments 0 points Started by Hitachi ServiceDesk Reporting and Analytics for HCM
-
How to use outer join in OTBI AnalysisContent Hi All, I am using Worker Assignment Real Time Subject area and i have to pull only the person who has home phone number . The person who don't have home phone n…User_2025-02-04-18-22-33-673 1.4K views 5 comments 1 point Most recent by RajaPalli Reporting and Analytics for HCM -
Excel Output Formats is not generating any data and file size is showing only 7 KBSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…sayeed_ahmed 11 views 1 comment 0 points Most recent by sayeed_ahmed Reporting and Analytics for HCM -
Encryption format supported by OracleSummary: The public key algorithm for this private key is not supported error while connecting to a FTP server Content (please ensure you mask any confidential informati…
-
SQL Query to fetch value set details with respect to modulSummary: Hi All, I want to fetch the value set details with respect to module, can anyone help me with table name or query? Version (include the version you are using, i…ShawShankk 239 views 1 comment 0 points Most recent by Deepak Deenadayalan Reporting and Analytics for HCM
-
Seniority Dates V2 to V3 TransitionContent Hi all - my search skills are seriously lacking, or there is just no information out there ... what work is involved in transitioning from V2 to V3 for the new s… -
Timing issue for an SQL querySummary: Content (please ensure you mask any confidential information): Hello experts, we built a query to retrieve the organization manager assignment id for a specific… -
Query to fetch the individual Manager Rating and Employee rating corresponding to each Goal.Summary: I am creating a custom report to get the employee and manager ratings for each performance goal. I got the summary ratings from table 'HRA_EVAL_RATINGS'. But fo…Rahul K-Oracle 733 views 2 comments 0 points Most recent by Jean Vishal Reporting and Analytics for HCM
-
Report to get Original Date Earned of element entrySummary: Report to get Original Date Earned of element entry Content (please ensure you mask any confidential information): Hi Team, Greetings! Does anyone have the repo…Parag Hiremath 235 views 3 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Need sample query to fetch list of document records for dependentsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Mallikarjuna Reddy 1 view 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How to get manager comments from absence approval notification in BI reportsHi Team, How to get manager comments from absence approval notification in BI reports We are searching for table name and field name that stores manager's approval comme…Anup Karmankar 31 views 1 comment 0 points Most recent by Florin Dumitru-Oracle Workforce Management
-
How to change 'TO' email address in workflow approval email notifications BIP TemplatesSummary: We have a requirement to change the "TO" email address when approving /rejecting workflow emails. We need to replace it with organization email address. Then it…Aditya Jena 31 views 2 comments 0 points Most recent by Venk Kudire- Support-Oracle Fusion Applications Administration -
OTBI filter show no dataSummary: Hello experts, we have a report for recruiting requisitions, but when trying to search in the values we get no data.. the list of values: SELECT DISTINCT IRB.RE…Lucas B Maciel 21 views 3 comments 1 point Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Embed BI Publisher report without Fusion HeaderSummary: Hi - I am trying to embed a BI Publisher report into a page for our Learning admin to use but when I embed the report using the link provided within the catalog…
-
Health and Safety incident photo table fieldSummary: How can I query a photo inserted on a Healthy and Safety incident? Content (please ensure you mask any confidential information): Hi, I have inserted the follow…Matteo Pacchiana 21 views 3 comments 0 points Most recent by Glen Walton-Oracle Human Capital Management
-
I need to retrieve a list of all data roles and job roles associated with a given privilege.When querying by privilege name, I want to capture all the corresponding data roles and job roles linked to it. I attempted using the tables ASE_PRIVILEGE_VL and ASE_PRI…Kanishka DIas 22 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How do I write a number in full in the report?Summary: I need to write the salary amount in full, for example, R$ 1,000.00 (one thousand dollars). I know it's possible using a PL/SQL function, but I couldn't do it i…Simiao Oliveira 11 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
We are trying to send a static (fix)pdf attachment to all newly created candidatesSummary: We are trying to send a static (fix)pdf attachment to all newly created candidates, for that we tried below query . Have uploaded a pdf doc to content server as…Awadhendra Tripathi 31 views 3 comments 0 points Most recent by Manikanta Reddy S Reporting and Analytics for HCM
-
DocumentsOfRecordEO psValue Meaning/ MappingSummary: Mapping/ Meaning for DocumentsOfRecordEO psValue Content: Support doc https://support.oracle.com/epmos/faces/DocumentDisplay?id=2692905.1 refers to different fu…Jan Barz ACN 45 views 1 comment 1 point Most recent by Ravinder Namsani-Oracle Human Capital Management
-
SQL Query to retrieve employee evaluation in performance documentSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query retrieving the employee overall rating in performance d…Valerio Curzi 583 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
SQL query to fetch the list of values for each value setSummary: Business requirement is to fetch the list of active values for each value set code in excel. Need to develop SQL query to fetch Each segment Value set code valu…Badripalli Archana-Oracle 2.3K views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Privilege required to see Home Phone and Home Email Address in BIP ReportSummary: Content (required): We have few BIP reports created to cater to the client requirement. We see that the report doesn't fetch the Home Email Addresses and Home N…Prajna Hegde 240 views 11 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
BI report: how to differentiate between learning outcomes and prerequisitesHello, is it possible to differentiate between learning outcomes and prerequisites? which table can we use to retrieve learning outcomes and what table for prerequisites…Alessandra T. 4 views 1 comment 0 points Most recent by Elaine Berrick Reporting and Analytics for HCM