Category 81
Discussion List
-
How to use "Combine results based on union, intersection, and difference operations?Summary: I don't understand how to use it. Whenever I add my 2 subject areas and then the fields, I don't know what to do after that. I need additional fields that are n… -
Absence DFFSummary: Dear All, I have created global DFF in the absence page and I want to show them in the analysis report for, I already use ( Workforce Management - Absence Real … -
Need to get distribution curve to work when count is 0I am trying to create a distribution curve for performance ratings. It looks good when there is a count >0 for each rating but when there is a 0 count for Unsatisfactory…
-
Where can I find the Specialization Description to add to my Specialization_Courses report?I can't find the description field to add to my report using the subject area Learning Records Real Time. Is this field in another subject area? Specialization Descripti…Lisa Marchand 33 views 2 comments 0 points Most recent by Lisa Marchand Reporting and Analytics for HCM
-
How do I define the dashboard prompt to include date range on the same columnSummary: Need help in defining the dashboard prompt to include date range on the same column, for example: date range on hire date and how to incorporate in BI Publisher…Surabhi Kumari 306 views 9 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How to Output a Table Entered in HTML Format in a Document Using BIPSummary: I am creating a document using BIP. I want to output table data entered in HTML format. I would like to confirm the following two points: What kind of SQL state…
-
Need a report which can provide details if any scheduled job runs and BI report run got missed.Hi Team, We have a requirement in place that if any report schedule and job schedule got skipped due to any reason then we need a BI or OTBI report by which we can track…Sanchit_Jauhari_2211 29 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to customize seeded Payment Register ReportSummary: How to customize seeded Payment Register Report Content (please ensure you mask any confidential information): Hi All, We got a requirement to add new columns i…Venkatesan 99 views 6 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
Query to get Statement of Earnings (Payroll -> Person Results -> Calculate Payroll)Team, It would be helpful if you can guide me on how to fetch Earnings Value. (Highlighted one).Manoharan 90 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
OTBI Analysis - How do you select the gross earnings for the max Date Paid per employee?Summary: We are able to get a list of gross earnings for each worker per pay date but we only want to SELECT the gross earnings associated with the max check date (Date …
-
Exception: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violationSummary: Failure: Due to oracle.xdo.server.ReportException: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violation Content (please ensure yo…Parag Hiremath 479 views 10 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How to join a Timesheet Row to an Absence Row (HWM_TM_RPT_ENTRY_V to ANC_PER_ABS_ENTRIES)Summary: If we have a person with 2 timesheet rows on the same day, each representing half day of absence, and we have 2 absence rows each of a different absence type - …
-
OTBI to show future effective datesSummary: Hi Community, Please refresh my mind: how to make the OTBI to show future dates from EFF table? Thank you, Alvaro Couto Content (please ensure you mask any conf…Alvaro Couto 24 views 1 comment 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
Assignmentrecords exist prior to the hiredate.Either delete assignmentrecords or change the hiredateSummary: While trying to change the hire date of an employee through HDL getting below error Error: Assignment records exist prior to the hire date. Either delete the as…Aruna Aounti -Oracle 85 views 1 comment 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
abcdabcdShyam Rajbhar 12 views 2 comments 0 points Most recent by Shyam Rajbhar Reporting and Analytics for HCM -
Table / View for New Features and Opt In Features?Summary: Is there a table / view that can be queried via BIP which would allow us to create a report of all of the implemented and non implemented features as seen in th…Monica Fundak 42 views 6 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
how to get the organization and customer hierarchy data from tables in oracle fusion planningSummary: Hi Team, What all are the table to extract the organization and customer hierarchy data from tables/BI report in oracle supply chain planning cloud? Content (pl…Nitin Aavasarmol 173 views 1 comment 0 points Most recent by gclampitt Supply Chain Planning and Collaboration
-
Performance Document Manager Overall rating doesn't apear within OTBI reportSummary: The issue arises with the rows displaying employee answers: the Manager Overall Score appears as “NA” instead of the actual score. Subject Area: Workforce Perfo…Peleg Puzaylov-Oracle 45 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How to report on 'Complete' Date in Oracle Cloud PayrollSummary: Our clients need the ability to be able to run a report to identify the tax liabilities generated based on 'Complete' Date (all on and off cycles completed on a…
-
How do Fusion deep links behave in case of multiple IDP's configured in Fusion?Summary: We have to configure 2 IDP's for authentication in Fusion. From UX, how do fusion deep links flow through and authenticate from these 2 IDP's? If Primary IDP ca…Milind Kulkarni 26 views 1 comment 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
disable_date not populated in HR_ALL_ORGANIZATION_UNITS_X after inventory org is disabledHi Team, We have disabled the inventory org and we are checking below condition but org.disable_date is not populated. Can you please help how we can populate org.disabl…vikram khengare 11 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Supplier bank country field in OTBI reportSummary: Supplier bank country field not found in "Supplier-Supplier Real Time" OTBI Subject area Content (please ensure you mask any confidential information): Version …Sharmava 23 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Supplier Management
-
Hide Schedule and Job option from reportSummary: Hide Schedule and Job option from report Content (please ensure you mask any confidential information): Hello experts, does anyone know how to hide the followin…Oriana L. 17 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
BI Reports are failing with error as Could not connect to OBI Presentation ServiceSummary: BI Reports are failing with error as Could not connect to OBI Presentation Service Content (please ensure you mask any confidential information): Hi Team, Greet…Parag Hiremath 43 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How can we create a distribution list in Oracle fusion Bi publisher?I need to share a custom report with multiple users through the following steps: Schedule → Output → Destination Does anyone have any idea about configuring a distributi…
-
What is the fast formula definition for Enterprise Hire dateSummary: I'm building a fast formula that will pull the Enterprise Hire Date of an employee for an eligibility profile. Need your help please. Content (please ensure you…
-
Total earnings inaccurate based on positions in Gross Earnings ReportI created an OTBI report include employees' 'Name', 'Position' and 'Gross earnings'. For prompt of time range, I use 'Pay period start date' and 'Pay period end date'. A…Yiming Xiong 13 views 4 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Position Hierarchy ReportContent (required): Looking for BI report to get the current logged in person's position and the positions under his hierarchy. Version (include the version you are usin…Nivya Mathire 93 views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Position Grade Code and Position Grade Name not being populated in OTBIHi all, We have an issue that the Position Grade Code and Position Grade Name is not being populated in OTBI. The only field that is populated is "Valid Grades" and this…
-
where we can see all the employees evaluations can be seenSummary: As a Learning Specialist Where i can see all the Evaluations which are compelted by employees. Content (please ensure you mask any confidential information): Ve…