OTBI
Discussion List
-
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 13 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 12 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 858 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 31 views 2 comments 1 point Most recent by Lakshmi Kanchi Reporting and Analytics for ERP
-
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 126 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 33 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 154 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 61 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
display column based on promptSummary: I want to add a prompt (Yes/No) to display a column. I'd settle for a prompt that forks to two different results tables as well. Content (please ensure you mask… -
when the employee has signed the contractSummary: Hi experts, we have the following requirements: for all the employees it is necessary to retrieve info such as their person number and when they've signed the e…Oriana L. 13 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Management Levels on OTBISummary: We have Management Levels defined on Job definitions. (Screen shot attached). For a person we would need to capture the management levels against the job on the…Vibha Pandey - Oracle 63 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI REPORT FOR TRACEABILITYHello and good day! Dear Oracle friends, If I will create an OTBI for Traceability, what are the possible subject areas and data fields I need? Hope to hear from the com… -
Missing column in Subject Area for ReservationsSummary: Missing column (Subinventory) in Subject Area for Reservations Content (please ensure you mask any confidential information): I am trying to create a report, ba…IdK1992 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Invoice ReportSummary: Is there any report which can drill down PO details (Department, cost Centre, receipt number and shipment number) which have been matched with invoice lines. Co…Najumah Bibi Abdool Rahman 2 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Learning Management Real Time RemovalSummary: Will it be removed or not anymore? Content (required): There were news way back 21A about the removal of the Learning Management Real Time Subject Area. Is it s…
-
Report display incorrect in dashboardSummary Report output on dashboard shows fewer rows of data than expectedContent I'm having some irregularities when trying to run an OTBI Analysis embedded in a dashboa…E McDonald 55 views 9 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Index Match formular for OTBIHi all, I am after some help on a formular that works similar to an index match formula in MS Excel I'm after the Legal Employer value of Managers using the manager pers…Tina T 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
ERP Report Sharing CentreSummary LocationContent Hi All, The HCM report sharing centre (https://cloudcustomerconnect.oracle.com/resources/5c46181001/summary) is a hive of activity, but the ERP o…Mark_Daynes 160 views 6 comments 2 points Most recent by DennisOliver Reporting and Analytics for ERP -
Does oracle provided any learners reporting dashboardSummary:Does oracle provided any learners reporting dashboard ? Do we have any standard dashboard on oracle learners reporting? Content (please ensure you mask any confi…
-
Which table stores the output data of the Print Receivables Transactions Email Delivery: InvoicesHi Everyone, Can anyone point me the table which stores the output of the Print Receivables Transactions ESS job especially the child ESS job - Print Receivables Transac…A Vigneshwar 551 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
In which subject area I can find Site details to create an OTBI report?I need the following fields in my OTBI report related to site to know their subscription status: 1) Oracle Fusion Site Name 2) Oracle Fusion Site Number 3) Oracle Fusion…Vishal Thakur 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service