OTBI
Discussion List
-
How to merge rows in OTBI?Summary: Hello, how can I merge these rows below? There seem to be an extra row under Role/Assignee and Due Date. Thank you Content (please ensure you mask any confident… -
Work Schedule future dated rows not joining correctly OTBISummary: We have a report comparing the work schedule vs the work schedule assignment. Work schedule (Assignment real time) Work Schedule Assignment ("Person Schedule As…
-
How to know and then set the PO Approval limits for all the Approvers in the System?Summary: We are currently using Supervisory Hierarchy for PO Approvals . There is a requirement to find out the PO Approval limits of all the Approvers in the system and…
-
Learning Records Real Time - Questionnaire ResponsesSummary: I have a simple analysis based on the subject area for Learning Records Real Time. For some reason, as soon as I add a section for "Questionnaire Responses" it …
-
Need Help adding a Component DFF to Item Structure ReportSummary: We have Setup a custom Component DFF in item Structure, we need to add the custom dff field in to the Item Structure seeded report. In the data model we are not…
-
Project Manager role to restrict access to purchasing data for own projects onlySummary: Project managers should only be able to view purchase orders, requisitions and AP invoices for the projects that they are assigned to as a project manager. Can …
-
Need Help to Understand SR DocSummary: We have issue, Canceled PR still consumed the project budget. The SR engineer give us the attached doc. But in the doc said that "Using data from the sqls(see A…
-
Securing purchase order-, purchase requisition- and supplier invoice details by projectSince the project commitment and project cost subject areas do not provide all required purchase order/requisition and supplier invoice details, project managers of our … -
How do I get current status of previously terminated employees onto a report?Summary: I have a termination report with all prior terminations on it. However, for rehires, I want it to show that they terminated but I need to know that they are cur…
-
Where is 'Last Updated Date' in OTBI for Licenses and Certifications?I am trying to pull a report for all licensure in our organization. I see every field listed on the licenses and certifications UI except 'Last Updated Date'. Where woul…JohnMayo1 4 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
How to invoke Purchase Order Email Body layout during Communicate Purchasing Document Process runsSummary: How to invoke Purchase Order Email Body layout during Communicate Purchasing Document Process runs, if you have custom layout. I am unable to upload PurchaseOrd…
-
OTBI Report for Payables Distribution SetsSummary: Trying to create OTBI Report of the Distribution Sets along with the details on the account numbers assigned Content (required): Create OTBI Report of Distribut…
-
Divide Incorrect OTBIHi All, I have a LSQL report which returns an incorrect value when dividing. I've tried other operators such as addition and multiplication, and the formula calculates t…Nick Dorfner 11 views 1 comment 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM -
Filter Criteria Changed in OTBI report when i run the schedule processIn OTBI Report ,few DFFs were missing from subject area and also the filter criteria changed to "Assignment Status Type is not equal to / is not in INACTIVE; INACTIVE_PA…Global Support Desk 22 views 2 comments 0 points Most recent by Global Support Desk Reporting and Analytics for HCM
-
Unable to convert our customer outstanding balances to USD for Indian EntitiesSummary: Hi Team, We have requirement to convert customer outstanding balances for India entity to show in USD. In OTBI if you provide option convert outstanding balance…Rajasekhar Reddy Adam 11 views 2 comments 0 points Most recent by Rajasekhar Reddy Adam Receivables & Collections
-
OTBI Analysis Report is not giving Salary Information as expectedWhen we are running the OTBI report, the salary information for the terminated employees is not displaying as expected, and for a few employees, salary details are getti…Paul D 103 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to show the "Not Started" in graph even if its 0 count?Summary I have this graph of Document Status (Not Started, In Progress, Completed). I want to show the "Not Started" even if its 0 count. How can I do it? Content (pleas…
-
Receipts created in spreadsheet are not getting applied to the AR invoices automaticallyI am trying to load receipts from the ADFDI "Create receipts in spreadsheet". I do pass the customer name, account number and reference as transaction number and transac…
-
Using Case Statement on Performance Document StatusSummary: Hello everyone, I need help on my case statement. Can you please check if this is correct. There are errors when I use the statement. I want to only have 3 stat…
-
how to find organization id(Master or any inventory org) value using OTBI or any other waySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
oracle query for Organization Card/social securityHi, I'm looking for a way to get this information from the following image in an Oracle Fusion queryjesus pacheco ortiz 1 view 0 comments 0 points Most recent by jesus pacheco ortiz Reporting and Analytics for HCM
-
Issue with Incorrect 'Burdened Cost in Provider Ledger Currency' Values while using in OTBI ReportHi Team, I am facing an issue with the 'Burdened Cost in Provider Ledger Currency' column while using the 'Filial Segment Value' column in the "Project Costing - Actual …Karthikeyan s-Oracle 1 view 1 comment 0 points Most recent by Dustin Grabowski-Oracle Project Management
-
Customizing Payables Withholding Tax ReportSummary: I am looking to customize the Payables Withholding Tax report by adding another column to it. Whenever the report is moved to a different folder it flags the er…
-
USING SUBSTRING IN CASE STATEMENTSummary: Trying to extract Working Hours from ORC Requisition Internal Description using SUBSTRING in a CASE statement Content (please ensure you mask any confidential i…Richard Kemp-Eyre 21 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Should the License Plate Number field be available within the seeded Expenses subject area?Summary: I cannot find the License Plate Number field within the 'Expenses - Transactions Real-Time' subject area. This is a seeded field which can be enabled by using t…
-
OTBI learning Report issueSummary: I have imported Learning OTBI report from instance to another In Instance 1 the OTBI report for Learning is working fine Instance 2 OTBI is not fetching any dat…
-
No results using subject area "Workforce Management - Worker Assignment Real Time"Summary: Hello, I'm trying to create a learning report showing employee's division, branch, department. I get results I need except from the 3 criteria. I have both HR A…
-
Looking for backend Planning column table nameSummary: Hi Team, We are looking for the back table name for below columns Safety_stock_planning_method , Days of Cover and Category_set_name with catalog and descriptio…LOKESH K MI 1 view 1 comment 0 points Most recent by Thejaswini Kamreddy-Oracle Supply Chain Planning and Collaboration
-
How to rearrange row in OTBI report?Summary: Hello, I need some help. I want to rearrange the performance tasks according to the order below per employee but every time I sort, the entire column sorts. Wor…