OTBI
Discussion List
-
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 11 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 21 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 91 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 2 views 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…
-
Create OTBI analysis for Procurement Contracts based on Logged In userSummary Want to Create OTBI analysis for Procurement Contracts based on Logged In user Content (please ensure you mask any confidential information): We need to create a…