OTBI
Discussion List
-
Is there any subject area with the Planned Delivery Date on the shipment?Summary: We have to create a report on the shipments and need the Planned Delivery Date that appears in the shipment. We cant seem to find it. Content (required): Versio…IIGC 31 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM -
In OTBI Report Date is not displaying correctly as per the date mentioned in front endSummary: In OTBI Report Date is not displaying correctly as per the date mentioned in front end Content (please ensure you mask any confidential information): Subject Ar…Manisha Shrivastava 21 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Building a custom report for pay ratesSummary Client is using the newly released salary basis based on rates of pay. There are no OTBI subject areas and need to create a new data model.Content The tables hol…User_2025-01-28-05-08-05-606 71 views 2 comments 0 points Most recent by Rajesh Jupudi -Oracle Reporting and Analytics for HCM -
Extract a list of custom reports in HCM from OTBI and BI PublisherSummary: Is it possible to extract a list of custom reports created in OTBI and BI Publisher, including: The subject areas and folders used, and the fields in them and o…Paul Morrissey 71 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Move Dashboard Page to a subpageSummary: Hi, I have created a dashboard with multiple Subpages under one Dashboard page. When i rename the Subpage names (In Dashboard Properties), somehow its convertin…Sudheer YN 203 views 8 comments 0 points Most recent by Dianne Barnhouse Reporting and Analytics for SCM
-
Using a parameter & variable to represent POD name for deeplinksSummary: It is great we can use deeplinks in OTBI but it would be helpful if a variable could be used to populate the current pod name. Otherwise we need to hard code it…
-
Extract run Failing after adding new FastFormulaSummary: Extract is failing after adding new rule to get the correct parking tier based upon employee salary Content (please ensure you mask any confidential information…GauravGupta39 21 views 4 comments 0 points Most recent by GauravGupta39 Reporting and Analytics for HCM
-
Mass upload invoices via spreadsheetSummary: Mass upload invoices via spreadsheet Content (please ensure you mask any confidential information): Is there a template available to mass upload invoices at onc…CraigX 31 views 4 comments 0 points Most recent by Alex D-Oracle Payables, Payments & Cash Management
-
AP Inquiry RoleSummary: I don't want to give ap manager role access to one of the user what privilege's I need to give to the user so that user can see the payables dashboard report (O…Pooja_123 31 views 4 comments 0 points Most recent by Pooja_123 Payables, Payments & Cash Management
-
HCM Reporting/Extracts usage recommendationsSummary Out of plane vanilla sustainable reporting ideas for HCMContent Disclaimer: following post expresses personal opinion of author based on many years and many rele…Valeriy Gorbunov-80491 76 views 8 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Where can I find release notes regarding OTBI and BI Publisher for HCM?Hello, I am looking for Release Notes or What's New regarding OTBI and BI Publisher for HCM Cloud. Could you please help me find where they are? Kind regards AliceAlice Gouzy 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Candidate date of birth and gender are not pulled from OTBI reportSummary: Hi, I have used Recruiting-real time subject area ans used "person date of birth", "person gender" columns to fetch the candidate date of birth and gender. Howe…Aruna Aounti -Oracle 356 views 7 comments 0 points Most recent by PranitSawant Reporting and Analytics for HCM
-
Unable to delete draft supplier registrations using REST APISummary: Unable to delete draft supplier registrations using REST API Content (please ensure you mask any confidential information): We have a requirement to delete exte…
-
Do we really need the ESS Administrator Role to run the Approval Groups Report ESS Job?Summary: We figured out two levels of security are required to run the "Approval Groups Report": Enable the user to Submit the Scheduled Process /oracle/apps/ess/financi…Thomas De Leeuw 63 views 2 comments 1 point Most recent by Thomas De Leeuw Reporting and Analytics for ERP
-
OTBI Analysis Agent - Enable to see Email ToSummary OTBI Analysis Agent - Enable to see Email ToContent The OTBI Analysis Agent when send's the extract based on the analysis, the recipients list is not showing in …User_2025-02-03-21-08-45-135 64 views 4 comments 0 points Most recent by Liwen Chiu Reporting and Analytics for ERP
-
Error when trying to add an analysis inside a datamodelI am trying to add an analysis inside a datamodel created through subject area, but when I click on view to see the information the application takes a long time and at …SERGIO BARRETO 121 views 12 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
Project Management Infolet blankSummary: Project Management Infolet blank Content (please ensure you mask any confidential information): Why is PM infolets blank as reflected below Can additional infol…
-
Edit item description on sales order or create the sales order without selecting a item codeSummary: Is there a way to Edit item description on sales order same like we have option on PO level or is there a way to create the sales order without selecting a item… -
Which table store user password and Password expiration DateSummary: Hi , Please let us know Which table stores the user password and Password expiration Date under User definition. Navigation : Tools-> Security Console-> User At…
-
ORA-00932: inconsistent datatypes: expected DATE got NUMBER in SQL data model per KM 2888420.1Summary: When trying to use the SQL provided in KM Fusion CST: SQL Running Behind Analyze Standard Purchase Cost Variances (Doc ID 2888420.1) i am getting an error in th…Maria Angelica Mendoza 235 views 1 comment 0 points Most recent by Manikandan S R-Support Oracle-Oracle Costing -
Standard Costing reportsSummary: Hi Team, Do we have a place where we can get the list of all standard reports that exists in costing today . say it as a repository where I can have the excel t…
-
OTBI report - functional managersSummary: I would like to create a report that could give me a list of functional managers by employee - OTBI reports. Content (please ensure you mask any confidential in…Jacqueline GRANDIN 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report of edited termination datesSummary: To assist with researching retroactive payroll scenarios, we would like to report on employees who have edited/corrected termination dates. We would like to sho…awheel09 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to obtain a drill down OTBI bar chartSummary: How to obtain a drill down OTBI bar chart Content (please ensure you mask any confidential information): Hi, we created a dashboard based on a OTBI Report. The …Barile Alberto 31 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to use an EFF in a case statement in OTBI?Summary: I am working on a report trying to calculate days between LOA End Date and the Estimated RTW Date (EFF) in the system. The case statement is producing an error,…
-
Issue with formatting totals in OTBI Analysis TableSummary: I have a simple analysis coming out of the Benefits - Enrollments Real Time Subject Area. I have set the Department Name as a Table Selection. I have formatted …Jason Snipes 21 views 7 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM