BI Publisher
Discussion List
-
OTBI reports doesn't display all the information loaded in the systemSummary: Content (required): Hello experts, we have noticed that some OTBI reports display 25000 rows at maximum and some information is missing. We suppose that for rep… -
How to get the total Headcount of Employees and contract worker on monthly basis.Summary: We are trying to create a dashboard using Analysis Report, but when we try to fetch the headcount of employees and contract workers through analysis, there is a…Harish.M 591 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Getting Shift Hours For An Employee On Particular DateSummary: Folks, We have a requirement to fetch the Hours On Date. Example. Find the screenshot attached. If we pass parameter date as 03-Dec-2018 then 35 hours 77777700-…
-
No data in balances when using Natural Account SegmentSummary: When working with Subject Area General Ledger - Balances Real Time I cannot see any data in balances: Beginning Balance, Period Net Activity and Ending Balance …JJ_DTU 21 views 2 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
Need SQL to fetch all Fast Formula and mapped HCM extractsSummary: Need SQL to fetch all Fast Formula and mapped HCM extracts Content (required): Version (include the version you are using, if applicable): Code Snippet (add any…
-
Accomplishment person profile database item Value Column NameSummary: Hello experts, when creating custom sections for person profile, I can see the Value Column Name for the flexfield as for example ATTRIBUTE_NUMBER1. What is the…
-
Privileges required to open Payroll Element Entries - Real Time subject areaSummary: Hello experts, do you know the privileges required to open Payroll Element Entries - Real Time subject area? Thanks in advance for your time! Kind Regards, Vale…Valerio Curzi 11 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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
-
Extract Completion DataSummary: Does anyone have a report to extract all completion records from Learning Cloud? I don't see a User Entity in HCM Extracts for Learning. Content (required): Ver…
-
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
-
Default Period Prompt to Current Period (ICM BIP Report)Summary: We have an ICM BIP report where we need the "Period" prompt to be defaulted to the current period. We tried using the SQL below, but it does not reflect correct…
-
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 -
Analytic needs to work with Prompt in DashboardSummary Analytic needs to work with Prompt in DashboardContent Hi, I have a Dashboard include one analytic and one prompt. When i open the dashboard, analytic is searchi…User_2025-02-05-02-38-04-251 45 views 4 comments 2 points Most recent by A.JOSH Reporting and Analytics for ERP
-
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 631 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 222 views 7 comments 1 point Most recent by Volodymyr Faranosov Reporting and Analytics for HCM