OTBI
Discussion List
-
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 511 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 541 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 42 views 11 comments 0 points Most recent by CCannadayCTR Reporting and Analytics for HCM -
Tree Version Start and End DateSummary: Purpose of Tree Version Start and End Date Content (please ensure you mask any confidential information): Can someone please help me to understand the purpose/o…ramesh.sivapalan 71 views 4 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to get similar columns in CST_COSTED_VU_COSTS_V since it is deprecated from 23C?Summary: Hi All, I have developed a query using CST_COSTED_VU_COSTS_V view but since it is deprecated from 23C I need a new table to get the columns. The replacement tab…
-
Anniversary report for specified dates in the NEXT MONTHSummary: Anniversary report for specified dates in the NEXT MONTH Content (please ensure you mask any confidential information): I have an anniversary report using Subje…JHaden3 281 views 9 comments 0 points Most recent by Andreea Herovic Reporting and Analytics for HCM
-
Job requisition approver using OTBISummary: Job requisition approver using OTBI Content (please ensure you mask any confidential information): Hello experts, we would like to build an OTBI analysis specif…Oriana L. 61 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Learning Calendar: In Monthly Calendar ViewSummary: Hi, have anyone prepared and implemented Learning Calendar in Monthly Calendar view. If so, could you share the report layout. Content (required): Version (incl…
-
Table details for My Public Info-->About Me SectionSummary Table details for My Public Info-->About Me SectionContent Hi All, Could you please help me with the table/Column details for employee 'About me' Section. I am a…nitin Sharma 111 views 10 comments 0 points Most recent by Amee Patel Reporting and Analytics for HCM
-
Sample Manager Level OTBI reportSummary: Content (please ensure you mask any confidential information): Hello experts, do you have an example of OTBI report retrieving for an employee the entire manage…Valerio Curzi 52 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
ISO Format for the positive pay templateSummary ISO Format for the positive pay templateContent Hello All, We got a requirement for the positive pay in the ISO format but as of now we have only an etext seeded…Koteswararao Yenikepalli 184 views 6 comments 1 point Most recent by Ruthwij Reporting and Analytics for ERP -
Report Data PurgingSummary: How often your organisation request Oracle to purge the report job history? Content (required): We have reviewed the report job history and have noticed there a…Sejal R 81 views 2 comments 1 point Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
Overtime Report for Direct and Indirect EmployeesHi all, I'm looking to build an overtime report that can be used by mangers to see their direct and indirect reporting lines claims, etc I've usually used the 'Assignmen…
-
How to automatically Create Asset for Non-Serialized ItemSummary: We are looking to auto create Assets for Non-Serialized Item after receiving the RMA Line Content (please ensure you mask any confidential information): We have…
-
Subject Area Access for OTBI ReportingI am trying to create a report of all our Department levels and the hierarchy. I am using the Workforce Management - Work Relationship Real Time subject area. I don't se…
-
How we can get Journal approver/assigned detail in OTBISummary: We do have a business requirement to create an OTBI report which provides below below-mentioned details. 1# Basic Journal header information (which we can get f…YogeshJain 101 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Option to get Payment UTR number on Separate Remittance AdviceSummary: Hi Experts, Is there any way to get UTR number, received from bank through MT940, to be visible in the Separate Remittance Advice sent to supplier? Content (ple…singhankitj1 121 views 2 comments 0 points Most recent by singhankitj1 Payables, Payments & Cash Management
-
I cant add the customized layout in maintenance work orderSummary: Customer wants to add a customized layout that has the logo and other details, The technical consultant changed the Data model with the new logo however the see… -
Grade null for Job requisition OTBISummary: Grade null for Job requisition OTBI Content (please ensure you mask any confidential information): Hello experts, we are building an OTBI report with "Recruitin…