OTBI
Discussion List
-
Invoice NotificationSummary: Is there an option to enable notification to requestor when invoice is uploaded to the supplier portal. Content (please ensure you mask any confidential informa… -
Get current and future termination EE records in OTBIHi, We are trying to build a demographic file that should pull the data of EEs as of system date and also future terminations in next 7 days. I have tried using the pref…
-
Report of everyone who reported to a terminated managerUsing OTBI, how can I pull a historical listing of all employees who had a specific manager in their management matrix over a specified date range?Mark Petereit 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Analysis on section comments and development goalsHi, I'm trying to build a report that displays for each performance document, the manager section rating for a specific section and the development goal name and success…Catherine Abi Samra 11 views 0 comments 0 points Started by Catherine Abi Samra Reporting and Analytics for HCM -
Does anyone know how to pull this address (Manage Locations) in OTBI?Summary: How to pull address (Manage Locations) in OTBI? Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…
-
Rehire recommendation details are inconsistent in OTBI reportSummary: Need help with fetching data for Rehire Recommendation for terminated employees Content (please ensure you mask any confidential information): Hi, We have an OT…Sai.V 121 views 22 comments 0 points Most recent by Rahul.Yarlagadda-Oracle Reporting and Analytics for HCM
-
How to add background color BIP excel template row wise in HCMHi Folks, May I know how to set the row background colour in the Excel template? Thanks Prakash JayavelPrakash Jayavel 41 views 1 comment 1 point Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Numbers format purchase order standard report issueDear All, The format of numbers in the purchase order BI standard report are not displayed correctly, because the NLS_NUMERIC_CHARACTERS setting is not configured at the…George Mattar 11 views 2 comments 0 points Most recent by George Mattar Reporting and Analytics for SCM
-
Depreciation Projection Report in Oracle Fusion CloudSummary Depreciation Projection Report in Oracle Fusion Cloud in Fixed AssetsContent Hi Friends, In Oracle Fusion, is there any report to project depreciation, similar t… -
OTBI parameter issueSummary: Hi Experts, I need some assistance. I'm working on the Talent Profile Report and wanted to capture all the details in one report. I picked up multiple values by…
-
SQL Query to get Value Set ListSummary SQL Query to get Value Set ListContent Hi Team, Could you share me any BI/SQL query to fetch the all list of Value sets using in HCM Instance like Dependent, Ind…User_2025-01-29-00-33-34-534 3.6K views 4 comments 0 points Most recent by Swarna Mahadevan Reporting and Analytics for HCM -
Scheduling delegate active list to ILT course to instructorSummary: We host several ILT courses. Is there a way the delegate list for each course date can be scheduled to be automatically emailed to the instructor so we dont hav…
-
what is the information get by Payment History Posted Status-OTBIIt's confusing what is the right criteria we should used to view the accounting status of payment. Could you confirm whether the criteria for viewing the accounting stat…Anne Nicole 11 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management -
Filter query using NVL not workingSummary Unable to save query when trying to use the NVL command with a logical sqlContent Hi All, I hope someone is able to help me with an issue that I am having. I hav…User_2025-02-04-08-51-08-912 96 views 10 comments 0 points Most recent by Tharuka Reporting and Analytics for HCM
-
Recruiting OTBI Performance issueSummary: Hi Expert, I need your assistance. I'm trying to combine two subject areas 'Recruiting - Recruiting Real Time' and 'Recruiting - Recruiting Event Real Time' and…
-
Most recent date paidSummary: I have an OTBI report that runs every other Thursday pulling earnings. The Effective Date field uses the below advanced SQL filter to pull only the current date…
-
how to create ORC otbi hires based on nationalitySummary: We have requirement to create otbi report for hired list based on nationality in ORC module. Content (please ensure you mask any confidential information): Vers…
-
Filter command field greyed outSummary: Need inputs to enter value in the Filter Command in the FTP delivery option Content (please ensure you mask any confidential information): In the FTP delivery o…Visu 11 views 3 comments 1 point Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
How to report on workers with termination date in last two monthsSummary: Content (required): I'd be grateful for some help with a filter on an OTBI report. The report is quite basic, showing employee name, person number, position, lo…Leanne W 841 views 7 comments 0 points Most recent by anusha chunduru Reporting and Analytics for HCM
-
How to populate tax rate name under Receivables-Transactions Real time subject area in an OTBIWe built an OTBI report with the subject area - Receivables-Transactions Real time. We do not see an option to select the tax rate name/code such as GST, HST etc. Only t…Lakshmi Kanchi 27 views 2 comments 1 point Most recent by Lakshmi Kanchi Reporting and Analytics for ERP
-
Table name of language Level in skill and qualification sectionSummary: Does anyone know the table name of the language Level table name in the skill and qualification section? Currently, I'm using attached BI query to fetch the oth…
-
Employee / Employer Pension Contribution Report for a specific durationSummary Employee / Employer Pension Contribution Report for a specific durationContent Hi, May I check if anyone has any OTBI / BIP report for Employee / Employer Pensio… -
In OTBI, how to set the filters to fetch data between the last 5 years to the current year?I'd like to create an analysis to fetch employees hired from the last 5 years up to this year based on "Worker"."Enterprise Hire Date". How to set the filters within the…Welsey 121 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Users with Purchase Analysis role have access to Supplier Subject areaSummary: Business wants users to have access to Procurement - Purchasing Real time subject area in OTBI. But granting the Purchase Analysis duty role enables access to S…
-
Requirement to Refresh OTBI Report at regular intervalsSummary: Is it possible to refresh an OTBI Report at regular intervals so that it does not require intervention from the operator? Content (please ensure you mask any co…
-
-
Hi Guys query is returning DATA_DS, please help me where i went wrong int he query.Summary: My Query: select per.person_number, per_name.FULL_NAME PER_ABSENCE_ENTRY_ID , abs.absence_type_id, apae.APPROVAL_STATUS_CD,abs.name absence_type,to_char(apae.st…
-
Do we have usage reports for Document of Records categoriesSummary: Are there any reports that summarises number of documents loaded against document categories. Content (please ensure you mask any confidential information): Ver…Chandan Patel 31 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM -
Position Costing with Incumbent ReportSummary: Does anyone have a report that includes both Position costing, with position number, and the position incumbent. We don't have the skills on the team to build a…Jenna Savage 155 views 9 comments 0 points Most recent by Jenna Savage Reporting and Analytics for HCM -
Need help for getting Average cost of an item column in OTBI Subject areaHello experts, I need some quick help in for my OTBI Analysis which is for supply chain module. I want to calculate the Sum of Debits and Credits in Inventory. For that …NIKHIL M Y 63 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM