BI Publisher
Discussion List
-
Learning Calendar: In Monthly Calendar ViewSummary: Hi, have anyone prepared and implemented Learning Calendar in Monthly Calendar view. If so, could you share the report layout. Content (required): Version (incl… -
Table details for My Public Info-->About Me SectionSummary Table details for My Public Info-->About Me SectionContent Hi All, Could you please help me with the table/Column details for employee 'About me' Section. I am a…nitin Sharma 113 views 10 comments 0 points Most recent by Amee Patel Reporting and Analytics for HCM -
Fusion BIP Reports Permissions Changes AuditHi, Is it possible to know the person name/ID/number who updates the permission of various reports/folders in Reports and Analytics for BIP. Thanks!Shilpa Varghese 31 views 5 comments 1 point Most recent by Shilpa Varghese Reporting and Analytics for HCM -
How do we export the expected effort of non-catalog item to OTBI?Summary: Expected effort of non-catalog items are not showing up in OTBI Content (please ensure you mask any confidential information): We are currently doing an integra…
-
Join between HR_ORGANIZATION_UNITS_F_TL and per_all_assignments_m table in Oracle Fusion HCMSummary: Join between HR_ORGANIZATION_UNITS_F_TL and per_all_assignments_m table in Oracle Fusion HCM for fetching employee division. Content (please ensure you mask any…Hitha Harikumar 1K views 16 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to convert data rich text format to plain text in BIP.Summary: Am getting below output for one of Field format,:1. Words: 17Characters (with HTML): 897challa praveen 114 views 3 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM
-
Query to fetch EOSB (End of Service Benefit) details from Oracle Fusion HCMSummary: Query to fetch EOSB (End of Service Benefit) details from Oracle Fusion HCM like : Hire date Hiring position Hiring grade Current grade Current position End of …Hitha Harikumar 311 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
User Entity Talent HCM ExtractHello friends. I need to create an extraction in the HCM Talent module. But I never had contact with this module to find out information such as which user entity I shou… -
How to retrieve the job req status for BIPSummary: How to retrieve the job req status for BIP Content (please ensure you mask any confidential information): Hello experts, we would like to build a BIP report wit…Oriana L. 92 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
HDL Template to update assignment recordsSummary: Hi All, I may request a data loader to update all the assignment records simultaneously too since I just received ALL the statuses for 100% of the population to… -
Fetch balance values from Fast FormulasI have a requirement to fetch balance values based on input balance names passed to Fast Formula. I am using Balance Specific DBI's to fetch their values. When I hardcod…
-
Chetana Pawar 121 views 4 comments 0 points Most recent by Chetana Pawar Reporting and Analytics for HCM
-
Record Limit in Payables Invoice RegisterSummary: What is the limit (Max number of Invoices can be pulled in) of Payables Invoice Register? Content (required): Client want's to know what is the maximum number o…Prateek Bajpai 51 views 2 comments 0 points Most recent by Kratika Sharma Payables, Payments & Cash Management
-
Lookup Type that stores raw completion status and previous event statusSummary: Hello, I need the lookup_type and lookup_code for the raw_completion_status and previous_event_status in WLF_EVENT_ATTEMPT_INTERACTIONS table. Content (please e…
-
Query to extract second manager level (under top manager) for all employeesSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query to retrieve for each employee the second level manager …Valerio Curzi 302 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
how to convert number in words in erpIn BIP report in cloud , we have to print one amount column in words. We have used the condition as below to convert it , but unfortunately it works upto one limit and l…RupaliGahalot 112 views 3 comments 0 points Most recent by RupaliGahalot Reporting and Analytics for ERP
-
Download External certificateSummary: Dear Expert, Is there any way to download the non-catalog item certificate for a user via the BIP report? Content (please ensure you mask any confidential infor… -
Build reports for questionnaire templatesSummary: We have built evaluation, pre-enrolment forms. We can view individual learner response. How do I build a report to show this. I've never built a report before, …
-
Context sensitive DFF in LookupSummary: Actually i have done all the setup and Before i'm able to see the DFF value in lookup. My system got cloned from Prod. After performing all the steps as before …
-
Query/ table to find the new joiners detailsSummary: Hi team, Please help to find the Query/ table to find the new joiners details in Oracle Fusion HCM such as: Current Job Title Last Title (Designation from previ…Hitha Harikumar 21 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Employee Dates History ReportSummary: I have been asked to build a report showing an employees employment dates history; showing hire date, rehire date (if applicable), term date, and 2nd or 3rd ter… -
Expense Authorization along with expense report matched in Expense module reportSummary: Expense Authorization along with expense report matched in Expense module report Content (required): Expense Authorization along with expense report matched in … -
How do I re-enable download functionality of BI Publisher output when using Firefox?Summary: After Firefox updated to version 123 yesterday, Feb 20, 2024, we can no longer download BI Publisher output anymore. Content (please ensure you mask any confide…BeachDreamer 12 views 2 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
Workflow Transactions Detail BI ReportContent Hi All, We have a requirement to create a report to fetch all the details of all workflow transactions going through approval. Is there a way to create a single …User_Z7BKU 265 views 4 comments 0 points Most recent by Neysan Mohajer Reporting and Analytics for HCM
-
query to get the vendor email id by vender id in publish report..?Summary: query to get the vendor email id by vender id in publish report..? Content (please ensure you mask any confidential information): Version (include the version y…
-
RTF Template creates incorrect word wrapping in output to PDFSummary: We have a company policy document that needs employees signature. We have an RTF template that contains all the verbiage and signature sections. When we output …Brian W 52 views 2 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
How do I exclude two question codes from the following query?Summary: Unfortunately I do not know SQL and am struggling with what I would think is a simple ask. I am trying to exclude two question codes from a query that I have. C…Tammy Hemmingson 21 views 2 comments 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM -
Count Time Cards Approved by WorkerSummary: Trying to determine how many timecards there are for a worker that make up the Processed Time Cards.Processed Hours from the Workforce Management - Processed Ti…Jason Snipes 31 views 4 comments 0 points Most recent by Jason Snipes Reporting and Analytics for HCM -
Talent Pool Report in Oracle BIPSummary: This report is required by the business to report on the grades of talent pool candidates while they are actively part of the talent pool and later, in future y…Pradnya_Pampatwar 42 views 9 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM