OTBI
Discussion List
-
Detecting Managers in OBTISummary: We would like to detect new managers within OBTI. We would like to identify the date that an employee becomes a manager. We have two examples: An original emplo… -
How to make bold font in a custom formulaSummary: Using subject area WFM Worker Assignment Real Time, field Worker/Address Line 4. Is there a way to modify this formula to show 'MISSING' in bold red text? CASE …
-
BI report does not open in android devicesWe have a third party payroll integration and we have a report so that payroll outputs can be pulled from self service. When this report is opened from the mobile applic…Ömer Vardar 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
I was trying to create a report to pull employees, excluding the managersHow to pull employees using OTBI and to exclude managers who are also an employee. please share ideas thanks.Joliver Caangay 21 views 2 comments 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM
-
What is the impact of not Assign Financial Categories to the Natural AccountsOne of the prerequisites for implenting a reporting tool such as OTBI and FDI , is to assign financail categories to the natural accounts. What is the impact on not doin…
-
unable to get the assignment details for pending worker from checklist real time subject areaHello Team, while running the report from checklist real time subject area the orgainzation hierarchy levels are showing null and also all the attributes for assignment …Shivam Naugraiya 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Offering Course Not Showing in OTBI If No Learners Are EnrolledGood Day, I have a specific offering course in fusion application where still no learners are enrolled. I can see this in fusion but when creating an analysis using Work…
-
Tables/View for Item and Asset Category to PO categoriesSummary: Tables/View for Item and Asset Category to PO categories Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to y…
-
Tasks related to the subject area "Product Management - Item Catalog Category Hierarchy Real Time"?Summary: Tasks related to the subject area "Product Management - Item Catalog Category Hierarchy Real Time"? Content (please ensure you mask any confidential information…
-
Oracle query to get values on 9 box grid for a person in HCM fusion talent review meeting reportOracle query to get values on 9 box grid for a person in HCM fusion talent review meeting reportDeepeeka Nath 91 views 4 comments 0 points Most recent by Neno Kolonich Reporting and Analytics for HCM
-
Supplier Address Level Tax Classification CodeSummary: We are trying to determine the Tax classification code field at Supplier Address level in OTBI analysis Content (please ensure you mask any confidential informa…Jithendra_MG 21 views 2 comments 0 points Most recent by Jithendra_MG Reporting and Analytics for SCM -
Journey's comments section data is missing in OTBI reportJourney's comments section data is missing in OTBI report Step 1 - We have created a journey. Employee will be able to use the Journey. Employee is able to enter the com…Challa Ramya-Oracle 11 views 2 comments 0 points Most recent by Diana Mitrovski Reporting and Analytics for HCM
-
Unable to calculate ATT and ATR in On hand reportHi Team, We are not able to calculate/ find the details of Available to Transact and Available to Reserve field in the On Hand Balance Report. The OTBI Report also do no…
-
MISC code in OTBISummary: Is it possible to get the MISC code in OTBI? We need to build a report for 1099 since Oracle's 1099 capability is severely limited. Content (please ensure you m…Alex Glose 11 views 4 comments 0 points Most recent by James McBride Reporting and Analytics for ERP -
Custom Role to Run FRS Reports in OTBIHello, Is there a custom ERP Self Service role that can be created to allow users to be able to view and run FRS reports in OTBI? Or does it have to be a full ERP licens…Erik Nicholson1234 11 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
OTBI Analysis Columns displayed by prompt valuesHi Experts, We have a balance report that works well. However, we would like to display in it some context based assignment DFF's. We would like to keep 1 report for eac… -
Absence Calendar Direct Reports Current Month not returning any valueHi Experts, When we are running the report "Absence Calendar Direct Reports Current Month" from Line manager Dashboard, It is coming as empty. I have checked then backen…Nivya Mathire 81 views 8 comments 0 points Most recent by Gunasagar Thimmapuram-Oracle Reporting and Analytics for HCM -
Query to get all approval transactions pending with terminated line managersSummary: How to get all approval transactions pending with terminated line mangers. I need a query to get all details including approver's person number/username. Conten…Smitashree Pradhan 317 views 3 comments 0 points Most recent by Aditya Jena Reporting and Analytics for HCM
-
Currency field of a Requisition that is in "Procurement - Requisitions Real Time" subject area?Hi Experts, We are trying to come up with a report from the subject area of "Procurement - Requisitions Real Time", while I cannot find the correct currency code that is…
-
How to create a custom Smart List Analysis/visualization to use in Redwood DashboardSummary: Hi, we need to create a custom Smart List analysis/visualization to use in the Redwood Dashboard. Content (please ensure you mask any confidential information):…Max Prestes 31 views 5 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
R13 How to generate a Trial Balance Report from OTBISummary R13 How to generate a Trial Balance from OTBContent R13 How to generate a Trial Balance from OTBIHello : I was wondering if you can share with me any document ho…gabriel kinovisques-163562 400 views 9 comments 0 points Most recent by Sachi Patel Reporting and Analytics for ERP
-
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i…Ayoub AFRASS 931 views 5 comments 0 points Most recent by Juan Pablo Gonzales Reporting and Analytics for HCM -
How to Bulk Transfer Cost with Standard FeatureSummary: Hi We want to transfer project cost from many project to another many project. How to do this with bulk transfer cost (standard feature)? Please help us Thank y…
-
Impact of changing analysis criteria for an already assigned InitiativeSummary: We have an OTBI analysis for an active inititiave that uses financial department numbers as the criteria. We have a request to remove several departments number…