OTBI
Discussion List
-
OTBI analysis report output does not show the values selected in the prompts when scheduledHi, I currently have the prompt fields as a Static Text element in the results. Running the report directly shows the selected prompt values normally, but does not appea… -
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 481 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 92 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… -
Which privilege gives access to employee abstract role view own data in OTBI reportSummary: Currently employee not able to view their own data in OTBI analysis with custom employee role. But when I used the seeded employee abstract role it gives too ac…Aditya Jena 12 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
AP invoice specialist cannot access to OTBI analysisSummary: Hi Guru, We have following two roles for our AP users, The users who is assigned specialist role where not able to see any record from our AP analysis report 1)… -
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 -
List of UI Labels effected with User Interface Text tool - renaming of labelsCustomer needs a list of effected UI labels (on pages/modules) when using the User Interface Text tool for renaming labels in Fusion environment. Is there SQL for me to …Sharne Thysse 21 views 5 comments 3 points Most recent by Andjela Kankaras Reporting and Analytics for ERP -
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 11 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 34 views 2 comments 3 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… -
Oracle table name to fetch all Supplier Profile Change Request DetailsSummary: We have requirement to build report with below columns. 1. Supplier name 2. Supplier account number. 3. Date of account update- Initiated 4. Account update- Dat… -
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 64 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… -
Print Expense Report - Failed to load errorSummary: Content (required): Hi, I have tried to get the Expense Report output by using the "Print" option on the actions of the Expense Report. However, the error "Fail… -
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… -
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… -
Where does the payment acknowledgement email come from and how to customize it?Summary: We recently set up a payment acknowledgment with the bank and have the payment file register with document detail email once the disbursement and acknowledgment…Nikki Reich 2 views 2 comments 0 points Most recent by Nikki Reich Payables, Payments & Cash Management -
How to get order details from the charts on OM Redwood page?Summary: We have created a visualization chart on the Order management Redwood page. Now when we click on the charts on the classic page, we are able to see the details …