OTBI
Discussion List
-
how to use listagg function in rtf template?Summary: Requirement to display a value (output of for loop) in a single row in RTF template, as of now its displaying each value in each row. Needs to be handled in RTF…Thanigainathan R 426 views 4 comments 0 points Most recent by Thanigainathan R Reporting and Analytics for ERP -
User Role Memberships Report - possible location in OTBI?Apart from the scheduled process, the report can be seen. Is it also possible to locate this in OTBI?
-
Inactive User Report - Is it possible to see this in OTBI?Inactive User Report - Apart from the scheduled process, the report can be seen. Is it also possible to see this in OTBI? If yes, where is the path name?
-
Reporting only role - OTBISummary: Content (please ensure you mask any confidential information): Are there any ootb reporting roles which just grant access to the OTBI layer and restrict all oth…Clare Murtagh 13 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
SQL to find the link between Intercompany transaction in AR and AP ?Summary: SQL to find the link between Intercompany transaction in AR and AP ? Content (please ensure you mask any confidential information): Hello I have the following S…Cesar Saveedra 551 views 2 comments 0 points Most recent by Gabriela Patrascu-Oracle General Ledger & Intercompany
-
Goal Status Overview Real Time is not reporting Review Period NameSummary: Created a OTBI Report using the Subject area "Workforce Goals - Goal Status Overview Real Time". but not getting the data for "Review Period Name" and we have a…
-
SQL for Approved requisitions not generating PO'sSummary: SQL for Approved requisitions not generating PO's Content (please ensure you mask any confidential information): Hello Will you please share with me any SQL to …Cesar Saveedra 42 views 3 comments 0 points Most recent by Ivan Pena-Oracle Self Service Procurement
-
HCM OTBI Workshop Session 1https://www.youtube.com/watch?v=KFTr7R06MdU https://us.v-cdn.net/6034893/uploads/40Q8JNXQTXWQ/workshop-q-26a.docx Summary: This following link allows you to download the…Raghavendra Raghunath-Oracle 4.5K views 33 comments 24 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM -
Approve Purchase Order from OTBI Action LinkSummary: Since 24A, the PO link within approval notifications is navigating to a blank page. As a workaround, we created an OTBI report that pulls all pending approval o… -
Functional area for allocated to prepare OTBI ReportIs anyone aware of the functional area where we can find the quantity allocated.Umesh Nayak 11 views 1 comment 0 points Most recent by Anand DN-Oracle Reporting & Analytics for Fusion Service
-
Microsoft Plugin we need for pulling dashboard analysis into pptCould you please assist in Pulling dashboard analysis Screenshots into Power point. Do we have plugins to handle this. Thank you..Raju Reddy 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Can see all results in Me tab with Admin. accessSummary: Trying to get an OTBI report on the Me Tab that doesn't give me all users Content (please ensure you mask any confidential information): Hi All I'm trying to re… -
Is there a way to join a "Workforce Management - Areas of Responsibility" SA with "Recruiting RT"Summary: Is there a way to join a "Workforce Management - Areas of Responsibility" SA with "Recruiting - Recruiting Real Time" SA to get proposed representatives for the…Volodymyr Faranosov 11 views 2 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Joining Two Standard Subject AreasHi team, We are joining two subject areas "Costing - Receipt Accounting Real Time" and "Costing - Landed Costs Real Time". Bu not getting data. Can anybody help me under…
-
cant find the role assigned date in Security Audit Real Time subject areaSummary: The ask is through the Security Audit Real Time subject we can't find the role assigned date since it has the role details we can't get the role assigned date d…sunas 51 views 8 comments 0 points Most recent by Rambabu Laveti-Support-Oracle Reporting and Analytics for HCM
-
OTBI report is taking too much timeSummary: Unable to run Time Card Status Report Content (please ensure you mask any confidential information): We devloped custome OTL report. When we are running for one…
-
SQL QUERY for Inventory Pending TransactionsSummary: Does anyone have a sql to query pending inventory transactions? Content (please ensure you mask any confidential information): When there are many inventory org…Adriana Rivera 510 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Inventory Management -
Oracle Fusion table information for getting Electronic signature related detailsSummary: In the Out of the Box Quality report "Electronic Record for Quality Inspection Disposition" there is a section that shows electronic record signature history. T…
-
Define a global function in BI reportsDear All, Is there a way to define a global function in BI reports to use it across all reports? For instance, NLS_NUMERIC_CHARACTERS?George Mattar 31 views 2 comments 0 points Most recent by Alex Kaleas Reporting and Analytics for ERP
-
Following 24A Change, has the Learn OTBI absence subject area changedSummary: An existing Learn report no longer works after release 24A. One column does not work and when we remove this column, the report does work. Content (please ensur… -
payroll report with gross pay showing element entry deductionsSummary: I need to create a report (OTIBI or BIP) that shows a person name, person number, pay period, pay period week, gross pay (for the pay period), add-in bonuses, (…
-
Seeded Termination Report in HCMSummary: Good morning everyone, Does anyone know if there is a seeded termination report in Oracle HCM. Also, is there a best practice for verifying inactive employees? …Daniel McMillian 81 views 8 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Print Receivables Transactions ESSjob errors when scheduled and works fine when ran on ad-hoc basis.When the Print Receivables transactions ESS job is schedules for more than one run, it doesnt pick any record and ends in Error. When it is submitted for a single run or…
-
Create Security Report in OTBI with details of roles both past and present with dates and statusI tried submitting this question in the HCM Report Sharing Center that was discussed during yesterdays HCM Customer Connect but was getting an access denied error so pos…
-
Process to add GL Segments in OTBI which are not inbuildHi, I would like to add GL Segments in OTBI other than the below-mentioned Segment Labels. I have gone through some oracle documents which doesn't worked to me.…Varalakshmi 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Expense Notification Banner for Global TransferSummary: Expense Notification Banner for Global Transfer Content (required): Background - Post Global Transfer, employees are unable to submit expenses for the previous … -
List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fSummary List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fusionContent Hi, Is there any way to get the list of all the …Aman Vasishtha-Oracle 543 views 2 comments 0 points Most recent by Bill McLarty55-Oracle Reporting and Analytics for ERP
-
OTBI Leave of Absence Report - No Absence ModuleSummary: Hello, We are trying to use the Assignment Event SA to build a report that will reflect all of the employees who are currently still on Leave of Absence and hav…CCannadayCTR 41 views 11 comments 0 points Most recent by CCannadayCTR Reporting and Analytics for HCM