OTBI
Discussion List
-
Learning assignment and Due dates updated with some datesSummary: A few learning records with the status of 'No Offering Selected' got updated with the assignment date of Dec 17, 2021 and Due date of Jan 16, 2022 with time sta… -
How to use current system date as a prompt and bring current year value as a column in OTBISummary: Hi Team, I have a requirement to use current system date as a prompt in an OTBI and bring current year as a static value in a OTBI. Please suggest solutions. Th… -
Remove Historical rows from TM OTBI analysisSummary Remove Historical rows from TM OTBI analysisContent Hi team, We have an OTBI analysis for listing out recent talent ratings for all the of the employees created …User_2025-02-10-15-30-45-495 32 views 13 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Attendance Register Report for LearnSummary Attendance Register Report for LearnContent Does anyone have an Attendance Register Report for Learn? To list delegates within a specific ILT Offering / Activity…Ruzwan Akram 72 views 2 comments 0 points Most recent by Esther Hess Reporting and Analytics for HCM
-
Reporting Knowledge Article Deep LinksSummary: Accessing Knowledge Article Deep links via OTBI Content (required): I haven't been able to find a way, or the correct Subject Area/Folder, to possibly report on…JA1 31 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there a way to export a list of all courses within a Topic Community?Summary: Is there a way to export a list of all courses within a Topic Community? Content (required): Version (include the version you are using, if applicable): 21D Cod… -
OTBI Report - GL JournalsSummary: OTBI report for GL Journals - I would like to create a report to allows me to see the Legal Entity relationship between a Balancing Entity and a Related Party? …AVorster-Oracle 21 views 1 comment 0 points Most recent by Anca A-Oracle General Ledger & Intercompany -
Max Effective Date for Each ElementSummary: How to retrieve the max effective date for each Element. Content (required): I am trying to find the max effective date for each of the three Elements (differen…JA1 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Trying to create a calculated item using fields from two subject areasI have created a report using balances and calculation cards. The report will run and return data from both areas but when i try to create a new field using a formula th…Sharon Harper 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Subject Areas not fetching data properlySummary: "Workforce Management - Worker Assignment Real Time" subject area not fetching the data properly. Content (required): I am working in internal test instance, it…Raghavendra M 181 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Trial Balance complete in ErrorSummary: Trial Balance complete in Error Content (required): Trial Balance complete in Error when submitted by a user. Seems as if BI publisher is not link to the user. …
-
OTBI Report view as Transpose RowsSummary: Content (required): Hello Friends, How I can get a Transposed view display for OTBI report (based on subject Area)? For Example: Currently I am getting output a… -
Is it possible to download the BIP output files to the particular folder in Machine?Summary: Is it possible to download the BIP output files to the particular folder in Machine? Suppose when we run any report, is there a way to download the output files…Kovi Harish Kumar 21 views 4 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
What options/ways exist to attach digital certificates from training into Learning?Summary: I have a requirement to attach learners digital certificates into OLM. Content (required): Is there any way to attach learners digital certificates into Oracle …
-
Catalog for Payroll Balances Real timeSummary: Trying to create a report from Payroll Balances Real time SA to match the Balance Results values from SOE with the amount included in the report for the respect…Hem 83 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Can deduction arrears be one an OTBI report.Summary: Deduction arrears on an OTBI report. Content (required): I need to write an OTBI report for deduction arrears. Is that possible? What subject area do I need to …Donna Valentine 21 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
How can we fetch "Non-Union Benefit Eligibility Dates" in OTBI ?Summary: From the attached screenshot we can fetch all the fields under Extra Information in Workforce Management - Person Real Time subject area except Non-Union Benefi…AaronJai 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Capturing the time of activitySummary: Content (required): hi there I am running a report for a classroom course with several offerings. A few of the offerings happen in the same room on the same dat…Bobby Jourdan 11 views 2 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
Need a report that shows everyone is a Closed Life Event StatusSummary: Could someone provide me with the correct criteria that shows everyone who is in a closed Life Event Status. I am using the subject area "Benefits Enrollments R…User_2025-02-11-00-58-38-371 31 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Is it possible to download the BIP output files to the particular folder in Machine?Summary: Is it possible to download the BIP output files to the particular folder in Machine? Suppose when we run any report, is there a way to download the output files…
-
Workforce Learning - Learning Management Real TimeSummary: Can anyone please help me with the table names/SQL that is being used in the Workforce Learning - Learning Management Real Time subject are .we have requirement…minati_behera-Oracle 101 views 2 comments 0 points Most recent by minati_behera-Oracle Reporting and Analytics for HCM
-
Are Multi Row Extensible Flexfield Segments Supported by Order Management in Current Release 21A?Summary Are Multi Row Extensible Flexfield Segments Supported by Order Management in Current Release 21A?Content Hi Team, We have requirement to capture Lot and Serial n…User_2025-01-29-00-27-45-196 53 views 3 comments 0 points Most recent by Mekala Hanu Teja-Oracle Order Management
-
Table for Pension Scheme name stored at PAE at UK calculation CardSummary Table for Pension Scheme name stored at PAE at UK calculation CardContent Hi Experts, I am try to pull the Active Qualifying Scheme for employee stored at PAE UK…
-
OTBI Previous Job History/Records Without Logical SQL or Custom-SQL/BIP - Possible?Summary History records of a personContent Hello, Can anyone please help me with the below scenario? I would like to get previous job changes/history (and few additional… -
Is there a way to display the values selected in the Prompt on the DashboardSummary Is there a way to display the values selected in the Prompt on the DashboardContent I created a dashboard, which contains the prompt and result area. as shown in… -
Maintenance exception subject area.Summary where I could find maintenance exceptions subject area on OTBI?Content Hi I´m doing a Report about production and maintenance times , but it includes some times …