OTBI
Discussion List
-
Assignment Category was Limbo (PRN) for entire yearSummary: I have a requirement to identify employees with an Assignment Category of Limbo (PRN) throughout the entire year 2025 or until their termination date in 2025. I… -
Is there an easy way to add the infolets from classic Inventory Management page to Redwood page?We are going through the process of enabling Redwood pages for Inventory Management. We have enabled the Redwood Inventory Management landing page but noticed that the i…
-
Job Offer DFF values not appearing in OTBISummary: We are trying to pull a Job Offer Descriptive Flexfields (DFFs) OTBI report for India, the values are appearing blank. Interestingly, we can see the correct val…
-
OTBI Learning Records Real Time Subject Area: Example reportshttps://community.oracle.com/customerconnect/discussion/647682/learning-records-subject-area Summary: Workforce Learning - Learning Records Real Time Subject Area Provid…Abdul Rauf Mohammad-Oracle 5.6K views 51 comments 21 points Most recent by Abdul Rauf Mohammad-Oracle Learning
-
How to Obtain History of Last Updated Date and Owner for ReportsSummary: How to Obtain History of Last Updated Date and Owner for Reports Content (please ensure you mask any confidential information): Is there a way to obtain a list …
-
OTBI Analysis Error: Subquery contains too many values for the IN predicate.Summary State: HY000. Code: 42029. [nQSError: 42029] Subquery contains too many values for the IN predicate. (HY000)Content Hi, I have a OTBI report which needs to pull … -
How to get ESS job schedule end date for all scheduled ESS JobsSummary: How to get ESS job schedule end date for all scheduled ESS Jobs Content (please ensure you mask any confidential information): Hi Team, Greetings! We have multi…Parag Hiremath 592 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Syntax Error in OTBI AnalysisSummary: Syntax Error in OTBI Analysis Content (please ensure you mask any confidential information): Hi, I'm trying to create a new OTBI Analysis. I selected "Workforce…Barile Alberto 3 views 1 comment 0 points Most recent by Pratap1305-Oracle Reporting and Analytics for HCM
-
Explain Differences in Payroll Balance Core Assignment and Core Relationship RunsSummary: When reporting using Subject Area Payroll - Payroll Balances Real Time, could an expert please explain the differences in the following Base Dimensions: Core As…
-
Notification upon Assigning Expense Report to AuditorContent Hi All, Does anyone know if there's a task notification sent to either BPM or email once a user has an expense report assigned to them for auditing? I don't see …
-
Link between OTL time Entries with Element Entries or Calculation cardsContent Hi All, We enter data in OTL and transfer batch. Then calculation cards and Element entries will be created. We need SQL Query/OTBI link between OTL time entries…
-
Requisition PDF Report With Data Model Not Showing in the email notificationSummary: We have customized the RTF file for Requisition PDF Report With Data Model and can view the customizations in the Purchase Requisitions/My Requisitions/View PDF… -
track the Non catalog request history in Learning Assignment pageSummary: Hi Team, User able to request for the non catalog request and learning team able to edit the assignment and change the non catalog request to the catalog and ac…
-
Currency Conversion in OTBI report from Procurement - Procure to Pay Real time subject areaSummary: We have a custom OTBI report created from Procurement - Procure to Pay Real time subject area. The report currently shows all open POs in different currencies. …Pranita S 98 views 3 comments 0 points Most recent by Judith COLLONGUES Reporting and Analytics for ERP -
Analysis - subject area : “Compensation - Workforce compensation Real Time” -Summary:I’ve created a analysis with the subject area : “Compensation - Workforce compensation Real Time” to retrieve compensation worksheet information. The amount disp…Olivier Guillouf 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Why I am not able to see prompts when I navigate through Reports & AnalysisI created an OTBI report in Accounts Receivable with prompts. When I access the report through Browse Catalog, the prompts appear as expected. However, when I navigate v…
-
Derived Standard Working Hours - SQLHi all, we're looking to add the following field to a SQL built report using BIP. 'Derived Standard Working Hours' (we can see this in Work Relationship - Assignment Det…MikeW 1.5K views 11 comments 0 points Most recent by Alok Suraj-Oracle Reporting and Analytics for HCM
-
Error while downloading BIP Report in Excel FormatSummary: We are getting error while run a BIP report and try to export in Excel and other formats. When we do the same in Interactive mode no error is coming IO Exceptio…Sanglap Kundu 21 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
Catalog object privilege validation failed for userSummary: Catalog object privilege validation failed for user Content (please ensure you mask any confidential information): Have downloaded a seeded report for HCM. When…Junade_Shujaat 23 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Modify New Hire State Report Template for USSummary: We have a requirement to include few extra columns in the delivered New Hire State Report for US. I would like to understand if we are allowed to that? Previous…
-
Security for OTBI Subject Area "Projects - Labor Distribution Costs Analysis Real Time"Summary: We need to expose OTBI queries written against the subject area "Projects - Labor Distribution Costs Analysis Real Time" to a larger population. Right now, it i…
-
Report to compare Supplier encumbrance + spend?Summary: Has anyone had luck creating a report of total encumbrance (PO amount) against supplier + total spend against supplier? I tried utilizing OTBI Purchasing Real t… -
Reporting on SCORM & HACP Learner Interactions in Oracle LearningSummary: Learning departments often want to understand how learners are responding to questions included in their SCORM-based courses, to assess whether there are proble… -
Do we have any subject area for custom role creation start and end dateSummary: Do we have any subject area for custom role creation and end date Content (please ensure you mask any confidential information): Do we have any subject area for… -
Does viewing the Invoice template in the UI require the BI Admin role?Summary: We have a custom role that includes the BI Admin role. We are now limiting user access in OTBI by removing the BI Admin role from the custom role. After removin…
-
Unable to find field "What Influenced You to Apply" in HCM reportingRecruitment (ORC) Reporting Question: We need to include the field “What Influenced You to Apply” in an analysis (along with Candidate Identifier, Candidate Name, and Re…
-
Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134.Summary: Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134. Content (please ensure you mask any confidential information)…Edward Villanueva 1 view 0 comments 0 points Started by Edward Villanueva Reporting and Analytics for ERP
-
Clicked metric is not available for reporting or data extraction in ORC CampaignsSummary of the Issue In Oracle Recruiting Cloud, the “Clicked” metric is visible and functions correctly at the campaign level in the user interface. However, this metri…alfredreyes1809 10 views 0 comments 0 points Started by alfredreyes1809 Reporting and Analytics for HCM