OTBI
Discussion List
-
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 113 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 51 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 103 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 123 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… -
HDL Template to update assignment recordsSummary: Hi All, I may request a data loader to update all the assignment records simultaneously too since I just received ALL the statuses for 100% of the population to…
-
Is there an updated HCM OTBI Subject Area to Table Mapping document that can be shared?Summary: Looking for the current HCM Reports - OTBI Subject Area to Table Mapping? I have release 12 and wondering if there is a current one. Content (please ensure you …Jose Guerra 101 views 2 comments 0 points Most recent by Jose Guerra Reporting and Analytics for HCM -
HR_Action table in Workforce Trends subject areaSummary: The 23R4_HCM_Semantic_Model_Lineage spreadsheet contains HR_Action table that I am unable to find in R13_23A_HCM_OTBI_Database_Mapping_with_ViewObjexts document… -
The 'termination category' stopped working in OTBI in 24ASummary: The 'termination category' field in the 'workforce management - work relationship real time' subject has stopped working for me in OTBI. I created a report in m… -
Build reports for questionnaire templatesSummary: We have built evaluation, pre-enrolment forms. We can view individual learner response. How do I build a report to show this. I've never built a report before, … -
Inventory OTBI Report is working for some users and giving error for otherSummary: I have created OTBI report under the following subject areas (Receiving – Receipts Real Time) and (Receiving – Transactions Real Time). Using Sandbox page integ… -
What table columns from Quality management can be used to join Maintenance table in oracle fusion?Summary: We have a requirement to build a custom BIP report Content (please ensure you mask any confidential information): what column from Quality management table of Q… -
Manager Self Service ReportingQuestion: For MSS, did you enable self service dashboard reporting via OTBI? How did you reference trend analysis? Thank you.Clare Murtagh 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Expense Authorization along with expense report matched in Expense module reportSummary: Expense Authorization along with expense report matched in Expense module report Content (required): Expense Authorization along with expense report matched in … -
Resource budget in different currenciesI have an OTBI analysis that needs to view the resource in different currencies - as the project budget allows- , but I can't get the amount in resource currency or even… -
Fusion 20C: Custom CM Dashboard not visible to some users?Summary Fusion 20C: Custom CM Dashboard not visible to some users? Cash Manager already assigned but still not able to access the dashboard.Content Hi Experts, Fusion 20…User_87I2Y 62 views 2 comments 2 points Most recent by Georgina Catchpowle Payables, Payments & Cash Management -
OTBI report to be accessed by differing security profilesWe have a dashboard which needs to be accessed by Line Manager, HR and Individuals. Is this possible to segregate this access in OTBI or will we need to create multiple …Clare Murtagh 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
HCM OTBI: OTBI Report Calculations IssueHi, I am facing an issue in OTBI which involves calculations. Please see the below example Column 1: SUM(Distinct TIMESTAMPDIFF(sql_tsi_month, "Worker"."Person Start Dat…Chaitra Lakshmi Krishna 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM