BI Publisher
Discussion List
-
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 35 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 163 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 24 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 27 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 29 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 80 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 54 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 789 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 242 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 264 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 54 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Scheduling BIP Report in Fusion Financials (Cloud) - Conditional SendSummary: Is a trigger necessary on a data model to conditionally send or not send a report in BI Publisher or will a data model that returns rows or doesn't suffice? Con…User_2025-02-10-15-12-48-631 32 views 2 comments 1 point Most recent by User_2025-02-10-15-12-48-631 Reporting and Analytics for ERP -
What table contains the Receipt Amount in Contract Billing Details screenSummary: Hi - what is the underlying table(s) that contain the Receipt amount in the contract billing screen Content (required): Where is the table containing this data … -
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 47 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… -
Error Receive when View ReportSummary: Error Receive when View Report Content (required): User receive the error message below when generating dashboard Version (include the version you are using, if…CraigX 11 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
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 23 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 34 views 12 comments 2 points Most recent by Peng Yang Reporting and Analytics for HCM