OTBI
Discussion List
-
BI Publisher - Object_version_number column in gl_je_headers tableDear All, After creating a journal manually, the object_version_number in gl_je_headers is set directly to the value 3. Can anyone tell me what the purpose of this colum…George Mattar 11 views 1 comment 0 points Most recent by Uddipta Bhaumik-Oracle General Ledger & Intercompany -
How should I find the full names of the people in the approvers column in the fa_fusion_soainfra.WFTHello, I use the APPROVERS column in the fa_fusion_soainfra.WFTASK table in my report, but the username is included there. I need approvers display name information. Can…Cansel Karasoy 32 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
No Results for Supply Chain Rollup Costed BOM ReportSummary: We are not seeing any results for the new subject area, Costing - Supply Chain Cost Rollup Real Time, that supplies results to the Supply Chain Rollup Costed BO…
-
pivot table/ stacked graphSummary: Hi all, I have created an analysis and used a pivot table to generate the stacked graph. Does anyone know if we can move the totals to the top so that it is not…
-
SUPPLIER BALANCE AGING - SQL QUERY NEEDEDSummary: We have a customer requirment to customize the supplier balance aging to increase the aging buckets than the standard one. So we want the sql query for the unpa…Yara Ibrahim-Oracle 424 views 2 comments 0 points Most recent by Sean Rogers Payables, Payments & Cash Management
-
How to set a As-Of Date Prompt in a Dashboard PromptSummary: How to set a As-Of Date Prompt in a Dashboard Prompt Content (please ensure you mask any confidential information): Hi, we created a dashboard. This dashboard h…Barile Alberto 91 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need inputs to display Payroll Run Results based on JobSummary: Need inputs to display Payroll Run Results based on Job Content (please ensure you mask any confidential information): We need to display Payroll Run Results da…Visu 21 views 9 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Is there a Workforce Management - Position Event Real Time Subject Area?Summary: There is currently a Subject Area for Workforce Management - Position Real Time selectable when creating an Analysis in OTBI. This Subject Area shows the max ef…Gloria Brewster 31 views 4 comments 2 points Most recent by Gloria Brewster Reporting and Analytics for ERP -
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 11 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 53 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 354 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