Check below if it help: Create OTBI Reports for Manufacturers and Items

Try the below:Use Column Selection in Pivot Table Settings In OTBI, manually deselect unwanted columns from the Pivot Table Layout. Ensure that only the required columns are included in the dataset. 2. Apply Conditional Formatting to Hide Empty Columns If some columns contain only null values, apply a conditional format to…

Hi Ayala01, Potential Causes of Data Variation: Query Execution Plan Changes Optimizing execution time may have altered the query execution plan, causing different indexing or join strategies to be used. This can lead to variations in how data is fetched, especially if the query involves aggregations or joins. 2. Parallel…

Check if this helps: Use initial-page-number="1" at the Member Level Apply initial-page-number="1" to the outer for-each@section (for members). This ensures that each member starts at page 1. 2. Ensure Continuous Numbering Across Parts Instead of using initial-page-number="auto" in the inner section, try removing it. This…

Check if this helps: Modify the Data Model: Ensure that all columns are explicitly included in the SQL query. Use NVL(column_name, ' ') or COALESCE(column_name, ' ') to replace null values with a placeholder (such as a space or default text). 2. Enable "Include Empty Tags" in BI Publisher Navigate to the Report Properties.…

Hi Giovanni, Check if this helps: FA: SCM: OM: EFF Artifacts Are Not Complete - .....privateVO.xml - Files Are Missing (Doc ID 2429276.1) Creating Custom PVO's on oracle fusion custom tables for BICC jobs — Oracle Analytics How do I make custom PVOs visible in BICC?

DFFs in Oracle applications contain columns named ATTRIBUTEn, where n is a number. These columns store additional information that businesses may need beyond standard fields. If you're working with PO_HEADERS_ALL or PO_LINES_ALL, the DFFs would be associated with these tables. To get the exact schema definition, you might…

Workforce Management - Worker Assignment Real Time:This is the primary subject area to report workers current assignment information. A worker can have multiple active or inactive assignments. This subject area provides details of all the worker assignments, including their start and end dates, assignment type, status…

Thanks for the info!!!

Currently, dashboard filters allow users to select values but may not support sorting directly. Check out below documentation on adding dashboard filters and using dashboard filters: Use Dashboard Filters Add Dashboard Filters

Thanks for the info!!!

Thanks for the info!!!

Hi Ravi, The subject areas Worker Assignment Real Time and Payroll Costing Setup Details Real Time are commonly used for employment and costing details, but they may not always provide the full picture depending on your specific reporting needs. Alternative Subject Areas to Consider: Payroll - Payroll Process Results Real…

Hey Peter: Try the below options: Change the division operation to explicitly use a floating-point number (7.0 instead of 7): sql (CASE WHEN CAST(@{T_Date}{'YYYY-MM-DD'} AS DATE) < "Assignment Event Details"."Effective End Date" THEN CAST(@{T_Date}{'YYYY-MM-DD'} AS DATE) ELSE "Assignment Event Details"."Effective End Date"…

Hi Mark, It looks like "Recruiting – Job Applications Real Time" & "Recruiting – Candidate Job Applications Real Time" is not a listed subject area in Oracle Fusion Cloud, but there is a similar subject area called "Recruiting – Recruiting Real Time". This subject area provides real-time information on the recruiting…

Presentation variables like F_Date can sometimes be stored as text instead of a proper date format, causing issues when filtering or comparing with the Effective Start Date. Convert the Presentation Variable to a Date Format: Use the CAST or TO_DATE function to ensure F_Date is treated as a date: sql…

Hey mark, Check this out:

Thanks for the info!!!

Hey Diego, It looks like to be a permission issue. Verify User Permissions: The user running the report might lack access to required data. Confirm role-based security settings and ensure the user has read access. Please schedule the report directly from BIP application by enabling the diagnostics log option for both…

Hey Mark, OTBI Subject Areas that can help to track candidate responses, use: Recruiting – Job Applications Real Time Provides details on candidate applications, prescreening responses, and statuses. Includes free-text and predefined answer questions. 2. Recruiting – Candidate Job Applications Real Time Tracks candidate…