Category 81
Discussion List
-
Average Salary for Job over TimeSummary: Need average salary for a job code over time Content (required): Is it possible to look at average salary for a job code month over month? Version (include the …Riti Malhotra 22 views 12 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Bulk upload/edit fixed asset location segment values "descriptions"Summary: Updating the location value description in fixed assets in bulk Content (required): There is a requirement in order to update the asset location segment values … -
How to convert xml data to columns in BI Publisher report Using ExtractValue?Summary: How to convert xml data to columns in BI Publisher report Using ExtractValue? Content (required): Version (include the version you are using, if applicable): Co…Lydia Jayasingh 51 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Procurement > Dashboards > Procure-to-Pay no 'Period' list of valuesSummary There is no value in the list of values for 'Period'Content Hi, I'm trying to open the seeded dashboard Procurement > Dashboards > Procure-to-Pay But with any us… -
Using BICC PVO in data model for BI publisher reportingSummary: is there way to configure data model to use BICC PVO? we need some custom reporting built and would like to leverage BICC PVO in data model Content (required): …Roman Havrylyak 41 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Update UDA using API/GroovySummary Updating member UDA upon runnen calc ruleContent Hi all, For one of our customers we want to update (assign/remove) a UDA for the entity dimension, triggerd by a…
-
Report on 'Ad Hoc' feedbackContent The business has decided they want the option to give feedback without the one receiving the feedback being able to see it (don't ask me why). We've advised the … -
Do BICC and OTBI have access to the same data?Summary Wondering if there any differences in what data can be accessed via BICC vs OTBIContent Am wondering if there any differences in what data can be accessed via BI…Jeff Hare CPA CISA CIA 74 views 3 comments 3 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to join 2 tables without common column in SQLSummary: Content (required): How to join 2 tables without common column in SQL and get the columns from both the tables side by side? I tried using the CROSS JOIN and UN…Prajna Hegde 31 views 2 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM
-
How to use the Min aggregate function along with group by clause in OTBI analysisSummary: I have a requirement to build analysis to fetch all the benefit enrollment data for a participant as well as dependent. I need to fetch the actual enrollment da…
-
Learning Initiative Automated AssignmentsContent We currently have a Learning Initiative programmed with analysis criteria for each of our required courses. We selected in the initiative how many days each new …
-
Report to fetch Element with assignment number and name for employeesSummary: i am using the below SQL to fetch the details. But the SQL is taking time to fetch the details. Can anyone please let me know if my i am missing any join Conten…minati_behera-Oracle 21 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Sum of Distinct/Unique values in Header for ETEXT templateSummary: Sum of Distinct/Unique values in Header for ETEXT template Content (required): I have 4 records for same person in my xml. All 4 records have same salary($2000)…Jaeyshree Kumaran 511 views 5 comments 0 points Most recent by Jaeyshree Kumaran Reporting and Analytics for HCM
-
Turnover for a Certain PeriodSummary: Is it possible to report on period start headcount and period end headcount for anytime period instead of month start and month end from the Workforce Trend Rea…Anita 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Bulk upload/edit fixed asset location segment values "descriptions"Summary: Updating the location value description in fixed assets in bulk Content (required): There is a requirement in order to update the asset location segment values …
-
Schedule BIP in fusion in 1st 10 days of EVERY monthSummary: Content (required): Is there a way we can schedule a custom bi publisher report in fusion for the first 10 days of every month? Version (include the version you…Vinay Gharge 31 views 2 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP -
Schedule BIP in fusion in 1st 10 days of EVERY monthSummary: Content (required): Is there a way we can schedule a custom bi publisher report in fusion for the first 10 days of every month? Version (include the version you…Vinay Gharge 12 views 2 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP