OTBI
Discussion List
-
OTBI Termination Date Filter Syntax QuerySummary: Hiya, I am trying to filter out any records where the Termination Date is before the current date. If the termination date is after the current date then the re…Kevin Robertson 21 views 2 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Possibility to download the subject areas field in OTBISummary: Possibility to download the subject areas field in OTBI Content (please ensure you mask any confidential information): Hi experts, does anyone know if it is pos… -
Payments approval details not available in BPM history tablesSummary: Hi Team, There are approval rules setup to handle the 2 level approvals of payment process requests. However the payment approval data is not getting stored in …Shashank Shekhar 67 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
How to restrict items (Inventory) in requisition / PO Lines?Summary How to restrict items (Inventory) in requisition / PO Lines?Content Hi all, In Requisition / PO line-entry all inventory items are coming, We need to restrict so… -
Do release updates affect the seetings in the Custom BI Webcat Reporting Duty Role?Summary: We want to limit the access to seeded reports as described here How to Revoke User Access to Seeded OTBI Content in Oracle HCM Cloud | by Manoj Gupta | Medium, …Sa_De_Or 1 view 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Workforce Structures > Job Detail Screen - Can You Report a History of Changes?Summary: Is there a way to write an OTBI report that shows old and new values, field name and date of change entered on the Job Detail screen (Workforce Structures/Job D…
-
How do I source: profile item id for spreadsheet loaderI'm trying to build a spreadsheet loader to load license and certifications specifically Responsible Manager which sits in Responsible Person Region in Skills and Qualif…
-
List for all OTBI subject areas/dimensions (as of 23C)Summary: Does anyone have a complete list of all OTBI subject areas/dimensions for creating ad hoc queries? Content (required): Version (include the version you are usin… -
SQL query to get CPP Exempt and EI Exempt status from Tax Crdit InformationSummary: SQL query to get CPP Exempt and EI Exempt status from Tax Crdit Information Content (please ensure you mask any confidential information): Need SQL query to get…
-
unable to get data for the following fields(Quote Price,RFQ Number,Line Awarded,Lines responded) ?Hi ALL, We have a requirement for the fields(Quote Price,RFQ Number,Line Awarded,Lines responded) in OTBI report. we tried with the following subject area but no date is…Prathyusha pari 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Pass BI Results to OTBI Analysis(please ensure you mask any confidential information): Is it possible to pass BI report results to an OTBI dashboard prompt and bind that to an OTBI Analysis column if t…
-
How to build queries on custom measuresSummary: I need to build queries to create reports those search for custom measures data I could create data set to search for dynamic tables (Query 1) and measures (Que…Carlos Benassi 91 views 6 comments 1 point Most recent by ChallaPavan Supply Chain Planning and Collaboration -
Need to find Entry Grade against Position in OTBISummary: Position Entry Grade reporting in OTBI Content (please ensure you mask any confidential information): Having issues with posting that I believe may be due to mi…Stephen Prentice 81 views 6 comments 0 points Most recent by Stephen Prentice Reporting and Analytics for HCM
-
Query to get the rollover balance of Annual Absence Plan on January-1-2024Summary: Hi Guys, i have i have scenario, Plan A and Plan B. Plan A is Base plan and Plan B is target Plan where rollover is being transferred. for example Plan A has 20…
-
Schedule report to run based on Last Run DateSummary: Is there a way to schedule a report to run starting from last run date? Content (please ensure you mask any confidential information): Version (include the vers…THawkins_LGI 31 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
MAX last modified date in Dev Goal Count Report returning blank fieldSummary: I am trying to create a report that will pull the entire employee population along with their Development Goal Counts and the most recent date they made a modif…Vis Perera 32 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
In which table is the information about who rejected the notifications with rejected status?Hi, I would like to access the information on who and on what date the rejected leave notifications were rejected in the system. I would appreciate it if you could share… -
'Range Values' in calculation factor from element definition pageHello Experts, I have requirement to get all details of calculation factor , Please check below image to identify requirement. Thanks.Rajdeep Chavda 31 views 2 comments 0 points Most recent by Chai-Oracle Reporting and Analytics for HCM
-
Translation in PAY_MESSAGE_LINESTeam, We have a requirement to display the payroll error message name and message text. We are using PAY_MESSAGE_LINES to get the details. But this table has only Englis…
-
Is there a report or query to see changes for employees Loans status before payroll runsHello All, Is there a report or query to see changes to employees Loans status before payroll runs, for example if they refinance , new etc? Thanks, Version 23CGail Wilmoth 21 views 2 comments 0 points Most recent by Chai-Oracle Reporting and Analytics for HCM -
seeded report for Standard costHi, Is there any seeded report Standard cost rollup with each element wise cost. Standard cost price variance report for items.
-
Custom OTBI report using UNION and getting errorUsing UNION to create a custom OTBI report and am getting this error: "Result field position x, has metadata type of integer, but the actual result data type is varchar.…vidyaxkarnam 72 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Project Costing - Actual Costs Real TimeIs anyone using this data analysis (standalone without joining to another) and pulling in Cost Management information? If so, are you finding that the amounts are duplic…
-
Reference number in system transactionsSummary: Could we change the reference in system transactions for bank reconcilliation? The reference column and transaction number is populating same data. Could this b…Dhevina 61 views 8 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
Report for item cost with trade operationsSummary: We need to have like a precosting and final costing report. Precosting is that before receiving we need to know what is the price that the item will cost us wit…
-
How to exclude weekends and holidays from calculation in OTBI Report?Hi We have a requirement to not include weekends and holidays in calculation for one of the metrics in OTBI report. Kindly suggest some steps to archive Thank you Prathy…Prathyusha pari 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to sort characters numerically in OTBI?I'd like to order these custom values in OTBI numerically. However, this is how my current values sorted: The requirement is to sort them like this: 0-0.5 0.5-1 1-3 3-5 …
-
Payroll Balances Real Time not returning zero valuesContent We are using the folder Payroll balances Real Time to bring back for a payroll run those people who have zero gross pay, however, although in the person results …