BI Publisher
Discussion List
-
View Display Error- Odbc driver returned an error (SQLExecDirectW).Summary: I created one OTBI analysis with some filter as prompted. The analysis is working fine with admin roles but when line manager is running report it is showing Vi…Kamini Kaushik-Oracle 66 views 0 comments 0 points Started by Kamini Kaushik-Oracle Reporting and Analytics for HCM -
ORC fields mapping with HCM TablesSummary: We're looking for mapping documents to associate each ORC field to the correspondent item in the HCM tables (e.g. ATTRIBUTE_CHAR1 etc) Content (required): Hello…gguittini 160 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Table Names which stores the Journey InformationSummary: Hi Experts, Need one help, we have created one Journey which has 2 Questions. This journey will be assigned to each employee and each employee need to answer th…Gaurav Bhardwaj 569 views 2 comments 0 points Most recent by Gaurav Bhardwaj Reporting and Analytics for HCM -
Need OTBI/BI query for checklist QuestionnaireSummary Need OTBI/BI query for checklist QuestionnaireContent Hi All, We have created Off boarding checklist and we are planning to develop a report(OTBI/BI)based on que…User_X612P 248 views 6 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BIP report includes a parameter as the first column in the CSV formatSummary: BIP report includes a parameter as the first column in the CSV format Content (required): Hi experts, BIP report includes a parameter as the first column in the…Volodymyr Faranosov 211 views 7 comments 1 point Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Candidate Profile Print out ReportSummary Candidate Profile Print out Report BuildContent Hi All, I have a new requirement to build Candidate Profile Print out Report HCM--> My Client Group --> Hiring --…Iann hick 92 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to link locations with geographySummary: Content (required): Hello Guys, We would load the city present in the locations inside the Geography of the recruiting. How could we perform it? Where could we …Giuseppe Iacono 43 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Payroll Costing and BalancesSummary: Has anyone ever used these two subject areas in an OTBI analysis correctly? : Payroll - Payroll Costing Setup Details Real Time & Payroll - Payroll Balances Rea…Andrew_Schmitz 49 views 7 comments 2 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
how to sum two condition in e-text template on oracle fusion hcmSummary: When we add all 4 fields the output of the report comes blank. I am able to add Shift Pay+Incentive+Current Salary the output appears but when i add Lead Pay (w…
-
Not able to add dashboards objects and OTBI contents on Dashboard pagesSummary: I am trying to create one dashboards using analysis but when I created one dashboard and trying to add column sections and other dashboards options on dashboard…Kamini Kaushik-Oracle 26 views 5 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Unable to get the BIP DataModel With DataCache References in Diagnostics ResultsContent Hello All, As per the oracle KM note 'Fusion Global HR: BIP DataModel With DataCache References Diagnostics Resulting Failure: null (Doc ID 2754842.1)', i tried …Janardhana Kondaveeti 39 views 12 comments 2 points Most recent by Peng Yang Reporting and Analytics for HCM -
Employee Phone Numbers Comparision ReportHi Experts We have client requirement for design a report which pulls up Employee details along with their work and home phone numbers. The inputs are Start Date and End… -
HCM Transaction Status DashboardSummary HCM Transaction Status DashboardContent Hi Team, Do we any dashboard to monitor all HCM transactions? Thanks. Version 20B
-
CUSTOM BIP NOTIFICATIONS NOT TRIGGERINGContent Hi, After adding BIP_CLIENT_REFRESH_TIME in Manage Administrator Profile Value, we are observing that many transactions aren't triggering custom BIP notification…Mohit Sinha-Oracle 103 views 9 comments 2 points Most recent by A.JOSH Reporting and Analytics for HCM
-
Schedule Event Trigger in Data Model Errors immediately when ScheduledSummary: I have created an event trigger in a data model, which I have done before without issue, but for this one as soon as I schedule the report that uses this data m… -
Query to get account numberSummary: Query to get account number present in below screenshot Content (required):Navigation - Payroll>Statement of earnings>Costing Results>Account number. Can anyone…Jaeyshree Kumaran 43 views 1 comment 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM
-
workforce structure change reporttrying to build a report that captures changes on the department table. We maintain history on our departments, but would like to be able to report on it. If we do the r…Mike Borghoff 88 views 4 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
View Formatted CLOB Text in BI Report Excel TemplateSummary: We are trying to fetch a formatted CLOB Data in an Excel template. However, the report is fetching HTML tags in the Excel cell . We tried the solution given in …Tanu Shri Patel 296 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to use one or the other parameter in a SQL querySummary: I have a query that I built that is supposed to either pull in the list of terminated employees based on the date range entered OR a list of terminated employee…User_2025-02-04-08-51-08-912 55 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Can we Hide Exporting options from user while running BI Publisher Reports ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Kaustubh Deshmukh 36 views 7 comments 1 point Most recent by Kaustubh Deshmukh Reporting and Analytics for HCM
-
Combining two analysisHi Team, Can we combine two or more analysis (columns are same for all analysis) results in a single report? Thanks.
-
Report With the FileURL (Download Link) of an Employee DocumentSummary: We need a BIP report with a download link to an employee's document (DocumentRecords) Content (required): Hi, Is it possible to generate a BIP report with the d…Yaniv 26 views 5 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
PARAM_EFFECTIVE_DATE based on payroll balance effective dateHi Team, We are creating report using logical SQL. We are fetching balance details for the whole year. So, Assignment details should be based on the balance effective da…
-
Job Start date in OTBI reportSummary if employee having multiple assignments but can we fetch job start date in OTBIContent Employee : works for property #1 (legal entity) with job of cashier starti…User_VR8E0 62 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report showing new managers with direct reportsContent Hello, We need a report that will show managers with direct reports and the effective date of when they had their first direct report assigned to them. This repo…Shanna Oppenheim 107 views 7 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Print performance document from MobileSummary: When i try to print a performance document from mobile, it's blank. I created a custom button to print it Content (required): Talent Management Version (include…
-
What tool(s) are recommended for populating a data warehouse?Summary: Content (required): We are currently using BIP because the EDW has requested full tables. We're looking into the alternatives due to our volume (35,000+ workers…Scott Paulin 15 views 1 comment 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM
-
Dynamic file name and dynamic sheet name for excel templateSummary: Content (required): I need to run the report for every month and output generated via Excel template. I need the output file name with the month and year for wh…Jaeyshree Kumaran 284 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Dynamic Pivot in excel templateSummary: Content (required): I have 2 sheets on my excel template output. the second has all the output columns and their data. Based on second sheet I need to create a …Jaeyshree Kumaran 36 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM