BI Publisher
Discussion List
-
Seeded Data Model and Report For Grade Step ProgressionSummary Seeded Data Model and Report For Grade Step ProgressionContent Hi Team, Where do get the Seeded Data Model and Report for activity 'Grade Step Progression' scree…User_2025-02-01-03-43-13-079 112 views 13 comments 0 points Most recent by Vijay Gorania Reporting and Analytics for HCM -
Reporting on Investigation QuestionnairesSummary Looking for a way to report on investigation questionnairesContent Hi Experts! Does anyone know if it is possible to report on the investigation questionnaires w…Lindsay Lamont 53 views 9 comments 0 points Most recent by Sacha Agostini Reporting and Analytics for HCM -
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 11 views 2 comments 0 points Most recent by Kamini Kaushik-Oracle Reporting and Analytics for HCM -
How to avoid Line Manager seeing personal and family contact names in ReportsSummary: How to avoid Line Manager seeing personal and family contact names in Reports Content (required): How to avoid Line Manager seeing personal and family contact n… -
Passing parameters to schedule event trigger in flow patternSummary: Hi All, We have defined a flow pattern consisting of different tasks. We have the parameters in the flow which is linked back to the individual tasks. One of th…Anirudh Udupa 21 views 2 comments 0 points Most recent by Anirudh Udupa Reporting and Analytics for HCM
-
Query the email sent in the BIP ReportHello All, We have checked that there is an available record to check the scheduled process that trigger the report that does the email bursting. What we wanted to check…Don Martin Querrer 161 views 2 comments 1 point Most recent by Aaron Hager Associated Bank Reporting and Analytics for HCM
-
Query the email sent in the BIP ReportHello All, We have checked that there is an available record to check the scheduled process that trigger the report that does the email bursting. What we wanted to check…Don Martin Querrer 11 views 0 comments 0 points Started by Don Martin Querrer Reporting and Analytics for HCM
-
How to translate link text in Analytics Dashboard?Summary: How to translate link text in Analytics Dashboard? Content (required): We have created a dashboard with link tool, now the requirement is to translate the capti…Punam Roy Karmokar 21 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
How to convert scientific number to decimal in BI report?Summary: In a report for corporate rate, value is fetched as 6.666666666666666666666666666666666667E-02 We tried with using to_number to convert this but it kept giving …Priyanka More-Oracle 21 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
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 61 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 161 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 581 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 241 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 86 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 41 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 41 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 21 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 32 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 101 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 41 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 81 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 301 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 51 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 31 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.