BI Publisher
Discussion List
-
How to have a Batch ID parameter which is present in BIP Report in the Dashboard?Hi , We are creating a dashboard of a BIP Report for our use-case, BIP Report has a parameter called Batch ID with which we will pull the data regarding that batch load.…Sainatha B 25 views 1 comment 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM -
Payslip - Other Deductions Section is showing doubled amountSummary Need help in determining if the issue is just with the BI Report or if the dataset is pulling in the wrong informationContent An employee had his garnishment (In…User_2025-02-04-08-51-08-912 61 views 2 comments 0 points Most recent by Saisandeep Nutheti Reporting and Analytics for HCM -
OTBI report update historyWe have several OTBI reports being updated that are not deployed by our support team. How is the owner updated to System Account? Is there a way to get the audit history…Angela Grace 15 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Determine Account date for PAY_COSTS entriesSummary: I am trying to figure out how to get back to the accounting date from each entry in the pay_costs table. We have a need to get this down to the person for some …Jason Snipes 8 views 3 comments 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM -
Help in query to retrieve Relationship Criteria on Eligibility Profile for BenefitsSummary: Hello! I am currently biulding an query to get all the Eligibility profiles and their criterias. Currently, I am in need to find the table to give me the relati…Matheus Roberto 31 views 1 comment 0 points Most recent by Thiru-Oracle Benefits-Oracle Reporting and Analytics for HCM -
Getting multiple values with HZ_LOCATIONS queryHello, I am creating a BI report to fetch location values from HZ_LOCATIONS table for longitude and latitude along with person details from employee table. The query is …Vaishnavi Katiyar 72 views 0 comments 0 points Started by Vaishnavi Katiyar Reporting and Analytics for HCM
-
How to pull data from Additional Compensation in BIP ReportsHello Experts, Does anyone know how to or who has available SQL to fetch these data from Additional Compensation ThanksJoliver Caangay 8 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Function "per_bipntf_flex.getEFFAttributesFromCompare" is not retriving the data properly.Summary: We are using TABLE(per_bipntf_flex.getEFFAttributesFromCompare(htd.TRANSACTION_ID, 'Responsive', 'j_CategoryPerAsgEitResponsiveEmplFlowsVORow','FALSE')) functio…
-
23D:AUDIT MASS DOWNLOAD OF DOCUMENT RECORDS-hr_dor_mass_requestsHello All I am trying to query the hr_dor_mass_requests and its populating the values. It populates the numeric values for status and object version number as 3,4,7. wha…
-
Audit Report for Talent for changes in skills and qualification pageSummary: Audit Report for Talent for changes in skills and qualification page Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there…Parag Hiremath 8 views 0 comments 3 points Started by Parag Hiremath Reporting and Analytics for HCM -
Performance Document - Current ApproverSummary Need report for who is the current approver of a perfomance documentContent I have the report which shows the Next Performance task status. Which is great, but i…
-
Custom report is changed using page integration. But the link is showing the previous reportThe report is added to the home page as a page entry using page integration. Later the report path is changed and report is modified using page integration. However, the…Reshma Eldho 8 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need to fetch the grade, grade step and grade rate at the employment level using BI reportSummary: Hi all I need to fetch the grade, grade step, and grade rate whichever assign to the person, but in my query, I am getting multiple grade steps assigned to the …Deepak Bhatt 2.8K views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
ORA-01719: outer join operator (+) not allowed in operand of OR or IN with payroll reportHi, The environment was recently upgraded to version 24D. Following this upgrade, the payroll report started encountering the attached error during execution (ORA-01719:…Saurav R-Oracle 126 views 1 comment 0 points Most recent by Matthew Hancock Reporting and Analytics for HCM
-
How to return values within a subquery by referencing tables from outer query?Summary: Content (please ensure you mask any confidential information): How can I return the name of the task owner from Oracle HCM Journeys using the Task Owner Person …Giuseppe Cannova 31 views 2 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM -
Query to find schedule details of a BIP reportSummary: Content (required): Hi Team, Is there a way to identify the schedule details of a BIP report like schedule start date, schedule end date, frequency etc? Version…MandeepGupta 1.2K views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
how to customize employee promotion letter notificationSummary: how to customize employee promotion letter notification Content (please ensure you mask any confidential information): Hi Team, We got a requirement to add new …
-
I am not able to fetch the pay value for Social Security DeductionsI am not able to fetch the Pay Value of Social Security Deductions For Oman Salary Payment Report in Oracle Fusion Cloud HCM . Can someone help me out with the query or …Tuhinaa Nanda 6 views 1 comment 0 points Most recent by Tuhinaa Nanda Reporting and Analytics for HCM
-
HSDL Updates to Requisition are not captured in IRC_LC_HISTORY TableSummary: When a requisition is updated using HSDL and if EXT_PUBLISH_JOB_STATUS , EXT_PUBLISH_JOB_END_DATE columns are being updated without any change to phase or state…vinay karumanchi 16 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Spreadsheet Data Loader (HSDL)
-
HCM Embedded BIP ReportsSummary: How to show BIP report with parameter in Comp landing page Content (please ensure you mask any confidential information): I'd like to show Embedded BIP Reports …CHANZAWA-Oracle 29 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to create a custom report in BIP with calendar .ics as attachmentSummary: If we need to create a BIP report which has calendar invite .ics as attachment along with other content in email, how can we do that? The requirement is the ema…Hemali Khatri 17 views 2 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
custom report in Thrive that relates to competency assessments within an individual’s profileHi, I am looking to build a custom report in Thrive that relates to competency assessments within an individual’s profile. There doesn’t seem to be a suitable native rep…Chintan Shyara 5 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to enable Report Job History to BI Consumer in Home page of BI Catalog?Summary: Please refer to the BI Catalog Home page of BI Author and BI Consumer. How to enable also Report Job History link in Home page of BI catalog to BI Consumer? Wha…CS Yuen-Oracle 114 views 2 comments 0 points Most recent by CS Yuen-Oracle Reporting and Analytics for HCM
-
Error Installing BI Publisher - Set Word2007 flg failedSummary: Receiving an error when trying to install BI Publisher Content (please ensure you mask any confidential information): I am currently trying to install BI Publis…Becky Mixon 421 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
SQL query to retrieve employee country (work relationship level)Summary: Content (please ensure you mask any confidential information): Hello experts, is there a way to retrieve Country field at the employee level by SQL query? If so…Valerio Curzi 507 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
"Test Notification Email Address" TableHi, Is it possible to query the BPM Worklist "Test Notification Email Address" from a table? Thanks, Derrin
-
The XML which we have pulled for the Job History doesn't hold the Job statusThe XML which we have pulled for the Job History doesn't hold the Job status if it is success or failed the against individual employee if the job is success of failure …Shanmukhi 3 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
how to convert blob type to actual text in oracleSummary: the underlying tables store the xml data of employees in blob format, the customer wanted to see the exact content of this File_data column in output results.. …Rama123-Oracle 50 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Time Change Request reportSummary: Hi All, Has anyone Developed a BI/OTBI Report on Capturing Details of Time Change Requests? We have a requirement and working on this. Appreciate if anyone can …Abhishek Bhaskar 77 views 3 comments 1 point Most recent by Peeyush Chandel Reporting and Analytics for HCM -
Getting an Error in BIP Report: ORA-01427: single-row subquery returns more than one rowSummary: Currently, we are using the attached data model to generate a BIP report for Employee leave Details which is working perfectly. We got a requirement to get the …sayeed_ahmed 103 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM