OTBI
Discussion List
-
How to display condition based counts in OTBI pivot reports?Summary How to display condition based counts in OTBI pivot reports?Content Hello All - Looking for your inputs on this pivot report. I have a condition like this (CASE …User_2025-01-25-04-02-13-126 37 views 2 comments 1 point Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM -
UOM of the item is getting defaulted with Primary UOM while creating the Pick Wave Instead of UOM inSummary UOM of the item is getting defaulted with Primary UOM while creating the Pick Wave Instead of UOM in which Item has been received against the POContent Hi, Busin… -
Toggle to include/exclude a column on reportContent I have an analysis that I want to prompt the user to include or exclude the SSN. I would rather do this than to maintain two reports. How would I create a prompt…Annette M 28 views 3 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Demand Supply Inventory ReportSummary Looking for subject area that has all data elements for Demand Supply Inventory ReportContent Requirement: Purpose report is to provide the Demand, Supply and In… -
Unable to generate lot numbers while receiving the POSummary Unable to generate lot numbers while receiving the POContent We have enabled the lot control at item level and created the PO. When trying to receive the PO from… -
Unable to generate lot numbers while receiving the POSummary Unable to generate lot numbers while receiving the POContent We have enabled the lot control at item level and created the PO. When trying to receive the PO from…Dev Thota 49 views 3 comments 2 points Most recent by Kalyanakrishnan Parameswaran-Oracle Manufacturing
-
Embedded analytics in HCM Pages and the new responsive UISummary We have been using embedded OTBI reports in pages for employees and managers in self service but the new UI does not seem to allow for new boxes to be added to e…User_2025-02-04-05-34-39-836 174 views 10 comments 2 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
To count the citizenship of an employee in OTBI ReportSummary An employee having how many citizenship in OTBI ReportContent Suppose Employee A contain 2 nationality, one is American and the other is Australian. So this empl…Soumya Goswami-Oracle 59 views 4 comments 2 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
License and certifications Skill Area Attachments - Where are they stored?Summary Require ability to view attachments employees have added to their License and certifications in OTBIContent Hello, I am trying to view attachments employees have…User_2025-02-04-11-20-13-378 107 views 7 comments 1 point Most recent by User_2025-02-04-11-20-13-378 Reporting and Analytics for HCM
-
How can we exclude the login user from the Headcount in the OTBI AnalysisContent How can we exclude the login user from the Headcount in the OTBI Analysis. We have are requirement, If a manager logs in and execute the report to see the headco…
-
Only able to see Line Mangers in Worker Assignment subject areaSummary When reporting manager's information, I can only see records of Line MangersContent Hi I'm doing a report where I need to pull all the different managers that an…Rogelio H 66 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Balance Sheet in OTBISummary Balance Sheet in OTBIContent I have a requirement to build out a balance sheet specifically in OTBI. Some folks have recommended using the subject area for Gener…User_ZZQJ0 158 views 1 comment 2 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
Access to query in CloudSummary Ability to run sqlsContent Need to know what options exists to run sql queries in cloud. Also wanted to know if there is a way to connect sql developer to cloud?Praseetha Mohandas-Oracle 60 views 6 comments 0 points Most recent by Praseetha Mohandas-Oracle Reporting and Analytics for HCM
-
Create QR code in RTF template for OTBISummary Create QR code in RTF template for OTBIContent I am trying to implement a QR code for the employee number I have followed the documentation: https://docs.oracle.…Cesar Tepetla Corte 104 views 6 comments 0 points Most recent by Ognjen Pavlovic, HCM Product Management-Oracle Reporting and Analytics for HCM -
What is the Limit of records that can be inserted for individual Lookup Type in Manage Standard LooSummary Task : Manage Standard LookupContent Hi all, We wanted to know what is maximum number of records we can create to a Lookup type (Max Lookup codes we can store un… -
In otbi notifications, email is not trigerring properlySummary Manager is getting all employee recordsContent Created analysis by choosing Create Database Query. Now in otbi agent , recipients tab username field chosen from …Soumya Goswami-Oracle 43 views 8 comments 0 points Most recent by Amrit Reporting and Analytics for HCM
-
Fields added to custom RTF don't show and fields removed still showContent Hello All, I have customized a seeded RTF where I added DFFs to the RTF template and removed unwanted fields from the RTF. However, when I print the document fro…PriyaPenugonda-SC 42 views 9 comments 0 points Most recent by PriyaPenugonda-SC Reporting and Analytics for HCM -
Accounts Receivable Reconciliation ReportContent Hello, I am looking to build a reconciliation focusing on the Accounts receivable transactions, I want to show the number of Accounts Receivable transactions tha…Elliot Hall-Walker 53 views 3 comments 0 points Most recent by Elliot Hall-Walker Reporting and Analytics for ERP
-
HR Specialist information- Which subject area contains the informationSummary Is there any Subject Area that can tell who is the HR Representative of an Employee?Content Hi I have the need to create an analysis and include who is the HR re…Rogelio H 49 views 8 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI analysis with date prompt pulling duplicate recordsSummary OTBI analysis with date prompt pulling duplicate recordsContent Hello, I was hoping to get some help with fixing my OTBI Analysis report that is pulling duplicat…User_2025-02-04-15-06-22-759 220 views 7 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Fetch Data from Last run dateSummary Only get updates and creates after the previous run of the reportContent This is something I know can be done in hcm extract but I would like to knoe if at all i…Prateek Parasar - GTUK, ACE Pro 507 views 5 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP -
Prompt Variables Not Being PassedSummary Selections from Prompt variables are not passedContent I have a custom Subject Area/data set derived from a logical SQL query joining the existing subject areas,…
-
DFF in RTF for GoalsContent Hello, I created 4 DFFs in Goal Details page and would like to include them in the RTF. However i don't see them in the xml output to use in while editing the RT…PriyaPenugonda-SC 49 views 13 comments 1 point Most recent by PriyaPenugonda-SC Reporting and Analytics for HCM
-
OTBI reporting on Areas of ResponsibilitySummary OTBI reporting on Areas of ResponsibilityContent I've not seen any recent posts on this so hoping there is some good news out there! Has anyone figured out how t…User_2025-02-04-10-43-02-447 138 views 6 comments 4 points Most recent by User_2025-01-29-02-58-08-021 Reporting and Analytics for HCM
-
Logical SQL Error - OTBISummary When attempting to create a new Analysis using simple Logical SQLContent I am attempting to create a new analysis using the logical SQL below; however, whenever …