BI Publisher
Discussion List
-
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 -
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 521 views 5 comments 0 points Most recent by Jaeyshree Kumaran Reporting and Analytics for HCM
-
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 11 views 2 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP
-
Reporting on Area of ExpertiseSummary Reporting on Area of ExpertiseContent The Talent Profile - Me > Career Performance > Skills and Qualifications Includes an Area of Expertise section and we would…User_2025-01-23-21-24-21-434 87 views 2 comments 0 points Most recent by dwi Lestari-Oracle Reporting and Analytics for HCM -
How to Burst a BIP report (Excel format)Summary: Hi All, I have a business requirement to send an attachment to each of our vp's with their employees I have created a SQL with my information that has a paramet…User_2025-02-04-08-51-08-912 1.4K views 6 comments 1 point Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
Payroll Data Validation ReportSummary No results in Payroll Data Validation ReportContent I am trying to validate the data in test environment by executing the delivered Payroll Data Validation Repor…Sowdha Murugan 111 views 6 comments 1 point Most recent by Phia Belgica Reporting and Analytics for HCM -
Excel formula in BI reportSummary: Need to include excel formula like DATE and DATEIF based on hire date pulled in one column Content (required): Hi Our requirement is to calculate a date using e…Poornima Paliwal 32 views 4 comments 0 points Most recent by Poornima Paliwal Reporting and Analytics for HCM
-
Report for tracking duration of TerminationsSummary: We have a need to report on the duration of termination, in specific, how long was the time period between when the termination request/workflow was initiated a…Adil_R 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
seed report for intransit shipment (what id the tables ?)Summary: i need what a seeded report for intransit shipment ? and what is the tables to create this report ? Content (required): Version (include the version you are usi…
-
EEO-4 Report - any ETA from Oracle?Summary EEO-4 Report - any ETA from Oracle?Content As every customer need a standard EEO-4 report as part of requirement, I understand it is in scope of future release. …
-
Can you create custom subject areas for a SAAS implementation?Summary: It appears that custom subject areas can be created - but I am not able to find if this is available for standard SAAS HCM Cloud implementations or if any addit…Karen Long 21 views 1 comment 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Gross Pay Balance for full Fiscal Year for all EmployeesSummary: I need to create or run a report for all employees to get the Gross Pay for each employee for our full Fiscal Year. Format of data needed Person Number Display …Andrew_Schmitz 212 views 1 comment 1 point Most recent by Jaeyshree Kumaran Reporting and Analytics for HCM -
Table which holds notification modeSummary: We need table name which holds notification mode Content (required): table to print notification mode Version (include the version you are using, if applicable)…Nishanth B Jain 31 views 3 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP -
Query to get balance value from run resutsSummary: Need a query to fetch value for given balance name('Gross Pay') and its dimension('Core Assignment Tax Unit Run'). the query should get value from run results n…Jaeyshree Kumaran 2.8K views 1 comment 0 points Most recent by Milan_Mohanty Reporting and Analytics for HCM
-
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 22 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 12 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM