OTBI
Discussion List
-
Identify persons active both as Employee and Contingent WorkerSummary: I have a requirement to identify employee records that have a User Person Type "Employee" AND a User Person Type "Contingent Worker" where Assignment Status Typ…JHaden3 222 views 5 comments 0 points Most recent by Gopinath.Ulaganathan Reporting and Analytics for HCM -
Display Formatted Job Description Details on OTBI or BIP ReportSummary: Display Formatted Job Description Details on OTBI or BIP Report Content (required): We are trying to display Formatted Job Description Details onto an OTBI repo… -
What table stores reports that have hdl templates and hsdlSummary: I want to list all BIP reports that have HDL templates and list all HSDL templates. Is there a table backend that I can use or subject area that can pull this i… -
Is there a way to filter the result of OTBI Report?Summary: I am creating Asset OTBI Report to capture the assets that registered with past dates since there is no standard report is available. I have created OTBI below …Karen Ito-Oracle 2 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
Incorrect drill-down results (action link to BI content) when using UNION in OTBI AnalysisI've written an analysis against the Workforce Goals - Goal Status Overview Real Time subject area. I had to use a UNION to accommodate some complex criteria and breakou…Shawn Gertler 12 views 6 comments 0 points Most recent by Shawn Gertler Reporting and Analytics for HCM
-
OTBI Learning - Unable to extract certain informationHi, I'm facing an issue on OTBI for Learning Module on the "Workforce Learning - Learning Management Real Time" subject area. When I try to extract these information of …
-
we need to modify the "reply to" on the dashboards and analysis that we send via emailSummary: We have different dashboards or emails that are sent via email to different users. However we want the users to be able to "reply" to any of those emails and th…
-
How do I report on the field 'Order Reference'In Court Order Calculation Card page, I need to report on the Order Reference field - how and where can this be found?Helen Tilling 1 view 2 comments 0 points Most recent by Helen Tilling Reporting and Analytics for HCM
-
BIP Scheduled Trigger Failing - Help NeededSummary: Hi all, I'm trying to add a schedule trigger to my BIP report that's currently scheduled, but when it runs with the code, it fails with the following message: D…
-
Reporting on assessment attempt scores when there's more than one assessment in the offeringSummary: I need to report on the score achieved for each attempt within an assessment however I find that if an offering contains more than one assessment activity, the …
-
Report not displaying Barcode when executed from ESS jobSummary: Report not displaying Barcode when executed from ESS job Content (please ensure you mask any confidential information): We have customized the Receipt Traveler …
-
OTBI report on Project analysisSummary OTBI report on Project analysisContent Hi Experts, I am creating OTBI report on project analysis. I got all the columns in work area. Now need to add one column …
-
Sql query listing transactions with 'Pending' status with transaction tablesI want display_name and person_number information of records in 'Pending' status from transaction tables.Is there a sample query you can share?Cansel Karasoy 736 views 6 comments 0 points Most recent by Nitin Kashiv-Oracle Reporting and Analytics for HCM -
OTBI Report for Learning module, to extract expiration dates of coursesSummary: I'm trying to create an OTBI report that will show the courses, assignees and expiration dates from the Learning module but am struggling to pull through validi…
-
OTBI Need subject areas with Representative Name to be pulled into reportContent Hi Team, We have captured HRBP in the representative section of Manage Employment. Now I want to capture that information in my OTBI report. But I am not able to…
-
How to restrict the access folder level in BIP ReportsCould you please advise if there is an option to grant the permission only one folder (Eg: Pyables Custom) . We’re looking to ensure users cannot view or access for any …Linga Murthy 11 views 2 comments 0 points Most recent by Linga Murthy Reporting & Analytics for Fusion Service
-
Employees with Manager Change can be viewed in OTBI by the old manager?Summary: OTBI report with the following info: Employees info + performance ratings + worksheet manager name info. This report has been delivered to managers. If an emplo…Oriana L. 12 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Do we have any equivalent view in Fusion for mrp_orders_sc_vHi, I've a requirement to provide the Demand quantity. Please provide me the equivalent view for mrp_orders_sc_v. SELECT inventory_item_id, abs(sum(quantity_rate)) dmd F…Dinesh K89 21 views 2 comments 0 points Most recent by Dinesh K89 Supply Chain Planning and Collaboration
-
Asset RegisterSummary: Looking for SQL query or OTBI report to get Project Segment (CoA) wise Asset Register Report. Balancing Segment, Cost Centre and Natural accounts are visible in…
-
Export Approval DetailSummary: Hi We are currently setup po approval in setup and maintenance. We are not using BPM. But in another product segment, we use BPM, such as project budget approva…
-
Is there a way to schedule Inventory Inspections?A customer requires to schedule inventory inspections in order to execute visual inspections weekly to an item in a specific subinventory. Is there a way to schedule Inv… -
Report on candidate log-ins for experience siteSummary: We have a requirement to identify the last time a candidate logged into their candidate profile through the external career site. Is there a reportable field in…Audrea Miller 1 view 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
is it possibile to check uniqueness of a field using page composer and el expression?I need to verify that when a user creates a customer of type person it is not already existing in cloud trate the fiscal classification code, because people do not have …
-
FTE in Compensation Subject Area is not correctSummary FTE value is showing 5 instead of 1Content Hi All, I need your help. I am getting two different values for FTE in OTBI. One comes from Compensation Subject Area …Alvaro Couto 41 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to display Name given Person Number.Summary: We have a DFF tied to Department that has the Person Number of the Executive overseeing the department. The name of the executive (not just Person Number) is of…