OTBI
Discussion List
-
Table for BPM - specifically CONFIGURATIONSContent We are looking for tables to be able to look at the workflow rule configuration. For example, we want to be able to create a report that will tell us things like… -
Can you customize Learning Certifications Report and add to specific courses + specializations?Summary: Hi All, We are trying to leverage the 21D functionality that enables learning completion certifications to be printed and displayed by users. The question is th… -
How can give condition Sysdate betwee effective start date and effective end date in OTBI analysisSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Anup Karmankar 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Receivables Aging by General Ledger Account ReportSummary: We are trying to develop a new custom aging report as to ease the reconciliation and make some custom column but we are not able to match the report with the st…
-
link between FND_SESSIONS table to country and stateSummary: link between FND_SESSIONS table to country and state Content (please ensure you mask any confidential information): By using FND_SESSIONS table, we can get the …
-
Learning Incident - Learning Item Owner No Longer in the CompanyHello! If the course owner/creator is no longer with the company (terminated or resigned), who would receive the notification if the course created by them is reported? …
-
Looking for System Usage MetricsSummary Reporting on who/when/how/what users are accessing in HCMContent Need to report on system usage and adoption rates for our HCM system with a focus on Employee an…Becky Stalsby 230 views 13 comments 6 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Enrollment effective end date meaningSummary: Enrollment effective end date meaning Content (please ensure you mask any confidential information): Hello experts, I've created a report with the Learning Reco…Oriana L. 11 views 3 comments 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Performance Documents Competency Assessment TasksSummary: Looking for the Performance Documents Competency Assessment Tasks assessee and assessor data Content (please ensure you mask any confidential information): Hell…
-
how to report learners in waitlist otbiSummary: how to report learners in waitlist otbi Content (please ensure you mask any confidential information): Hello experts, we would like to create an OTBI analysis t…
-
Adding Days to DayNameI am trying to calculate the end of a weekly cycle. I have a column with day names and another column with the number of days to add. For example, adding 3 days to Monda… -
How to fetch SourceRef values loaded via hdl?Summary: We are loading some source reference values while loading allocated checklist to employees. However I am not sure how to fetch this values in an OTBI and BI rep… -
Path to the Instructor Feedback Dashboard in the Demo POD?If I navigate to the mentioned path, there is no Instructor Feedback Dashboard. where can I download the Instructor Feedback Dashboard Path #{EndPointProvider.externalEn…
-
How to set in OTBI report the difference between a variable (an input parameter) and a fieldSummary: How to set in OTBI report the difference between a variable (an input parameter) and a field Content (please ensure you mask any confidential information): Hi, …Barile Alberto 101 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
We need fetech the status of Exist survey report how can i get in OTBI May I know subject area?Summary: Hi Team, We need fetech the status of Exist survey report how can i get in OTBI May I know subject area? Thanks, ajay Content (please ensure you mask any confid…AjayKumar Maddipati 21 views 5 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
Fetch competency catalog from subject area "Workforce profiles – Library objects Real time”Summary: Hi experts, we're trying to fetch the whole competency catalog using an OTBI analysis in the subject area "Workforce profiles – Library objects Real time". The …Oliviero Riva 21 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Query to Retrieve All Privileges and Roles for All RolesSummary: We want to know the query/tables that will allow us to retrieve all Roles details including the assigned Functional and Aggregate Privileges Content (required):…Aahiri_Sarma 19.7K views 22 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
GL Revaluation sources - report to show the invoices/payment (sub-ledger) transactionsSummary: Hello All, We have a requirement where business wants to verify the source transactions (AP invoices/payments) that are considered for the revaluation process d…Subhasish-OC 21 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
OCI: Infrastructure utilization statsHello Team, Please guide on how to generate the following reports Infrastructure utilization stats Including for the peak times - store opening and closing We want to ma…Wale Odusanya 11 views 1 comment 0 points Most recent by Alexandru Dicu-Oracle Fusion Applications Administration
-
Transpose rows to columns for RatingsSummary: I want to show the ratings of two specific performance document section names in columns. I named the header like the section name. I used a "CASE WHEN" stateme…
-
R13: Project Portfolio Management Cloud OTBI: Subject Areas to Database Tables Mapping SpreadsheetSummary The spreadsheet provides a mapping of the BI Subject Area columns to source database tables and columns. It also has the View Object (VO) names for each column. …Noelle Bartlam-Oracle 6.6K views 24 comments 5 points Most recent by Prosenjeet Bit Reporting and Analytics for ERP
-
Purchase Orders Number and Requester NameSummary: What subject area to be used to create a report showing PO number and the requester name from the PO line. Content (please ensure you mask any confidential info…Ahmed Maher Kadeh 174 views 2 comments 0 points Most recent by Ahmed Maher Kadeh Reporting and Analytics for SCM -
Is it possible to create an OTBI report that will show payment details by payment date and employee?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Chris West 41 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Rows repeating with different values though it's not available in the Front end under Customer SiteSummary: Hi, We have developed an OTBI report using Receivables - Customer Real Time and Receivables - Customer Account Site Tax Profile Real Time and it is repeating a …Rahul Kumar Gupta.-Oracle 21 views 2 comments 1 point Most recent by Daniel S.-Oracle Receivables & Collections -
Multiple Values in PIVOT tableSummary How to have multiple values in Pivot tableContent Hi I want to have a pivot table where i want to show the Competencies in measure with competency type as Column…Jagdish Varadraj 55 views 3 comments 0 points Most recent by Krishna_Vellela525 Reporting and Analytics for HCM -
Requisition Line DFF segments not populating in the Purchase Requisition PDF reportRequisition Line (DFF) not populating in the Purchase Requisition PDF Report layout (without datamodel report) We are using investment segment number under attribute19 a…
-
Does anyone have the SQL tables that define the BPM Journal Approval Workflows?Summary: We're trying to track the setting within the Journal Approval Workflow that disallows the JE creator from being an approver to support SOX audit controls Conten…Patrick Bonahoom 82 views 5 comments 0 points Most recent by Patrick Bonahoom General Ledger & Intercompany -
Upload mt942 file format importing bank statements in Oracle Fusion??Summary: Upload mt942 file format importing bank statements in Oracle Fusion Simple question If we can to upload this file format MT942 ??? Now we need to implment the 2…Christian Leon 134 views 2 comments 0 points Most recent by Christian Leon Payables, Payments & Cash Management