OTBI
Discussion List
-
Exclude Bank Holidays from Absence Days calculationSummary: Bank holidays are counted in the absence days calculation for a sickness absence but should be excluded Content (required): We have a number of sickness absence…Dawn Cawston - CPS 111 views 22 comments 2 points Most recent by Dawn Cawston - CPS Workforce Management -
How to Create a Grand Total Column in OTBI ReportSummary: We created a Payment advise report using the Payables Subject area, but the customer wants us to create a Grand Total column to Sum up all the columns, please h…Chukwuemeka Aniukwu 1.1K views 5 comments 0 points Most recent by Estefanía Payables, Payments & Cash Management -
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 ResponsesThere was an error rendering this rich post.
-
Requesting details on FDIHi Team, We are planning to implement FDI module ( Reporting ); and I am unable to get much details on FDI on CCC as well as on HelpCenter. Can you kindly assist on the … -
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: https://us.v-cdn.net/6034893/uploads/8WUK9TXNSQP3/howtofixbcissue-updated1.docx We have issue, Canceled PR still consumed the project budget. The SR engineer gi…
-
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 1 view 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 12 views 1 comment 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM -
Employee with Bank Account but no Payment Method ReportSummary: I have a report that picks up all employees that do not have a bank account and a payment method active, but how do I pick up employees that have a bank account… -
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 12 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 93 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 Started 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…