OTBI
Discussion List
-
SQL query to get position in performance documentSummary: SQL query to get position in performance document Content (please ensure you mask any confidential information): Could you please advise on the SQL query needed… -
While selecting Level XX values in FDI or OTBI it is populating cumulating values of preceding valueWhen we select Level 29 value in OTBI /FDI it shows 29 th level values and If we select Level 28 values it cumulates and shows previous values namely level 29 values als…Tanguturi Ajay kumar 1 view 0 comments 0 points Started by Tanguturi Ajay kumar General Ledger & Intercompany
-
OTBI: How do I use a non fact column in the Column Filter.Summary OTBI: How do I use a non fact column in the Column Filter.Content Hi, I have a requirement where i need to use a non-fact column which is Standard Working Hours … -
What is the recommended way to extract item data in bulk from Fusion Cloud(PDH) by External SystemSummary: What is the recommended way for an external system to extract item data in bulk from Oracle Fusion Product Data Hub (PDH) to be used with OIC. Content (please e…
-
OTBI Report to fetch List of Line ManagersSummary: OTBI Report to fetch a List of Line Managers who have at least one direct report and the direct reports(Employees) should be Salaried. Content (required): For t…Thulasi Ram 485 views 7 comments 0 points Most recent by Aditi Sehgal Reporting and Analytics for HCM -
How to report on comments for Checklist QuestionnaireSummary: In OTBI, Workforce Management - Checklist Real Time, I am trying to find the column that shows what comments were made in the "Comments" field in the questionna…S. Johnson 91 views 13 comments 1 point Most recent by Alissa O'Sullivan Reporting and Analytics for HCM
-
When using Journals real time subject area the amount for a journal is getting doubledSummary: When I add the Journal Batch details folder columns, especially the 'Created By' field to the OTBI analysis, the amount gets doubled for the journal. This is ha…
-
How to get the user role and security related information for an employee in the OTBI reportSummary: We have a requirement to get the user role and the security policy information associated for the employees in the Oracle Learning Cloud. Could you please sugge…
-
Sickness balances by proration periodSummary: I am trying to export the person number, minimum date and maximum date for all staff who between September 24 and March 26 had received "Statutory Sick Pay" whi…Kameron Withak 11 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
ORC report to show the most progressed candidate phase for every open requisitionHello - We want to create a report to provide recruiters a list of all open requisitions and the phase of the most progressed candidate for the respective requisition. W…Sanket Jayade 11 views 4 comments 0 points Most recent by Sanket Jayade Reporting and Analytics for HCM -
Tracking User Role Assignments in Oracle Fusion: Standard Reports and Audit Log CapabilitiesSummary: In Oracle Fusion Applications (not limited to Sales Cloud), is there a standard way or report available to retrieve a list of all users along with their assigne… -
Which table stores vacation rules on bpm worklistSummary: Which table stores vacation rules on bpm worklist Content (please ensure you mask any confidential information): Hello all, Can you help please to extract the B…Osama Mohamed 13 views 0 comments 0 points Started by Osama Mohamed Reporting & Analytics for Fusion Service
-
Learning record measures - incomplete count - includes exempted statusSummary: It appears that the Learning record measures - incomplete count parameter is incorrectly counting learning items in "exempted" status. This doesn't seem accurat… -
Asset Addition Status column in Ap Invoice DistributionsSummary: Content (please ensure you mask any confidential information): In the AP Transactions subject area in OTBI, there are various columns related to Fixed Assets in…BrianGledhill 1 view 1 comment 0 points Most recent by Md_Anees-Oracle Payables, Payments & Cash Management -
IRIS 1099 reportingHello, I am wondering if Oracle has any 1099 csv reporting (Updated US 1099 Media Report) or supplier module enhancements in the pipeline to address the following: The I…Parker DiNardo 134 views 2 comments 4 points Most recent by Dhaval Patel-Oracle Payables, Payments & Cash Management
-
Approver Name of a transaction with OTBISummary: Create an OTBI report with Transaction details, the initiator and approver Content (please ensure you mask any confidential information): Hello experts, is it p… -
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…usr_a.nv 96 views 20 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Can we add another Incomplete infolet in Procurement > Purchase Orders > Overview pageSummary: The Manager would like to view all the incomplete orders of the team Content (please ensure you mask any confidential information): Currently in the current inf…
-
Access to invoice imageI have a requirement to be able to navigate straight to an document image in WebCenter Content via a report or spreadsheet without needing to go via the functional workb…Daniel Ryan 11 views 0 comments 0 points Started by Daniel Ryan Payables, Payments & Cash Management
-
Change button colors in Redwood notifcationSummary: Is it possible to change colors of black action buttons in redwood approval notification? Content (please ensure you mask any confidential information): Version…
-
custom Supplier pdf not being attached to Supplier Invitation email for NegotiationsWe have created a custom Supplier pdf template, saved in the Custom folder in OTBI, but when we invite a Supplier to participate in the Negotiation, the custom template …
-
Document Sequence category Expense Report vs Payment Request (Document Sequence Category Name)Summary: I am configuring the "Document Sequence" for the Expenses module. Under the Assigment section, I see two categories : "Expense Report Invoices" and "Payment Req…
-
Is View Display Error / Timeout issue related to missing BI Admin role?Summary: Multiple user encounter View Display Error when running Dashboard Report. Most of the reports results with errror. We confirm that they have access in the repor…
-
Assignment Changes on Employment HistoryContent Our organization is working to transition to utilizing the Quick Actions verse Person Management. One feature we use is the “view history” and then "export" on t…Kayla Malecki 310 views 14 comments 3 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
OTBI Conditionl FormatingI’m facing an issue while building a formula in OTBI (Subject Area: General Ledger - Journals Real Time). Requirement: I want to calculate a value that combines: Journal…Abdulrahman Mostafa 11 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
OTBI New Calculated Measure Formula for Age at End of the Month from report run dateI need a formula that would provide me with the dependents age as of the end of the month from the report run date. If the report is scheduled to run on the 1st day of t…Jennifer_Wright 1 view 3 comments 0 points Most recent by Jennifer_Wright Reporting and Analytics for HCM
-
Bursting sending one consolidated email instead of multiple emailsSummary: Needs to send one email to Manager with consolidated notifications of all the employees instead of sending one notification for each employees. Content (please …
-
Infolet Section says Refresh to Load after LoginSummary Infolet Section does not load Infolets by DefaultContent We are on 19C and on news feed. I have enabled HCM infolets and infact made couple of infolets. But What…Prateek Parasar - GTUK, ACE Pro 117 views 16 comments 6 points Most recent by User_ORRJ4 Reporting and Analytics for HCM -
Need PVO name to fetch additional attributes from Assignment DFFSummary:We have additional attributes populated in Assignments and they are visible in Fusion OTBI BIP table per_all_assignments_f can you please let us know from which …Sunil Gunturu-Oracle 11 views 3 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM