OTBI
Discussion List
-
OTBI Report for collaboration messaging historySummary: User requires an OTBI report scheduled on a daily basis for the errored out Purchase Orders and Invoices to keep him notified. Can you please suggest the subjec…Sumiran Maheswari 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Excel Report Errorummary: Hi experts, we are trying to upload a ready excel file as a Report, but we continue to receive the following error message when trying to view it. We have alread…Marlon Castillo Maliglig 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
What role is required to Grant only Reports and Analytics Catalog in Oracle Cloud ?Summary: We have a requirement from Business. Business wants to Run only the OTBI Reports from Cloud. So, What role is required to Grant only Reports and Analytics Catal…
-
Freezing of Headers in a Pivot TableSummary: We have this analysis showing multiple records. Is there a way to freeze the pivot table header view in this dashboard? We have checked Oracle documentations an…Kelvin Jamil Reyes 21 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
SQL IF Statement for FiltersSummary: I am attempting to create an OTBI report that has both work and personal/home email for new hires. For the work email I have that information from the Worker As…
-
Multi Select field in UI returning Lookup Code in OTBISummary: We have this field in Sales UI having an FCL multi select in Division custom field. We have tried to add DESCRIPTOR_IDOF in this field however it is showing bla…Kelvin Jamil Reyes 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to handle the data which has a new line in it in LOV/BI Reports.Summary:User has mistakenly entered new line in a column, where data type CLOB is text, for that the LOV value is populated in 2 line and the report parameter is not han…Sura Yashaswini 12 views 3 comments 0 points Most recent by Sura Yashaswini Reporting and Analytics for HCM
-
OTBI: manager with at least a direct report both based in the same countryHi everyone, Our customer has the following requirement: To retrieve the list of the manager L1 located in italy with at least a direct report Both manager and direct re…Alessandra T. 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Pivot Table limits numbers of rowsHi, I have an OTBI report for Total Comp Deferred Cash Payments year wise. This is a simple report from subject area - Payroll - Element Entries History Real time. We ar…Arnabb 51 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Which column in Fulfillment Lines Real Time is the same as fulfillment lines status in the screen?Summary: Which column in Order Management - Fulfillment Lines Real Time is the same as fulfillment lines status in the screen? When I selected "Fulfilment Line Status Na…
-
Facing an Error when changing the ware house in the Order Fulfillment Lines. How to resolve this?Selected shipping method is not available. Already added the required Inventory org to the Shipment method. Still error is populating. How to solve this? -
Storing Historical Pricing ChangesSummary: Looking for all options for storing and referencing historical pricing changes in the Pricing Administration Application? Content (please ensure you mask any co…
-
How to report on Directly Assigned detail in AOR TemplateSummary: I'm looking to report on the Directly Assigned detail in an AOR Template Content (please ensure you mask any confidential information): I've looked in all the A…
-
Absence Accrual BalancesContent Hi - I have a report that shows the absence accruals for each of our plans and it works great for those that are calendar year Plan Period Type. It shows me the …Prudence K 355 views 27 comments 4 points Most recent by Shameer Shaik Reporting and Analytics for HCM -
Courses within Specialisation - reportingSummary: This is a 2 part question about Course WITHIN Specialisations. We have noticed that when we set up specialisations, the reports don't pick up the courses which …
-
Line Manager Dashboard custom with Manager Name HeadcountSummary: Hello, I made a custom OTBI dashboard from the vanila Line Manager Dashboard. In that dashboard we added one prompt Manager Name that is prompted. So when we se…Ilzura Ismailhodjaeva 61 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Inventory Accrual ReportSummary: The Finance Department has no data on inventory accruals to as certain as to whether accrued inventory are being offset and balanced. Is there any seeded report…
-
How to report on Burden Cost by Burden Cost Code when burden is applied on same expenditure?Summary: Burden amounts by cost code are available when you navigate to Manage Project Costs > select any transaction with burdens, then Select > Actions > View Burden C…
-
Columns from View Billing Extension Event Details page not found in the backend tablesNeed backend tables or reference code for the below listed columns. Navigation: Navigator >> Contract Management >> Revenue >> Task >> Manage events >> query a contract …
-
Notification to be sent to the maintenance manager to start the work orderHello, can we create a report where we have the start date and system's date, we scheduled every 1 hour for example, and if the system's is very near to the start date b… -
Compensation OTBI Best PracticesSummary Technical brief discussing compensation related OTBI best practices Content Document 2571003.1 - Compensation OTBI Best Practices (July 2019)Gail Langendorf-Oracle 151 views 2 comments 8 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Transaction Tax Registration NumberSummary: Does anyone know if there is a column in OTBI that reports the Transaction Tax Registration Number? I have checked the Subject Area to Database Mappings via the…