The Procurement - Requisitions Real Time subject area does not seem to expose the Current Approver Name directly. Using Transaction Console The Transaction Console in Oracle Fusion allows you to view the current approver for requisitions. You can manually check the approval status there, but it may not be available for…

Hi skhan, Review the below doc: Lot Management

Hi Ivony, Looks like you're trying to retrieve both contacts associated with an account and those without an account in OTBI, but the left join isn't working as expected. This is a common challenge when working across multiple subject areas in OTBI. Check the Below: Understanding OTBI Subject Area Joins: OTBI does not…

Thanks for the info!!!

Thanks for the info!!!

Congratulations!!!!

Thanks for the info!!!!

Please check below:

Hey Kevin, Please check "Procurement - Requisitions Real Time" Procurement - Requisitions Real Time

@Nalsoft Pvt Ltd Check the below KM note: Fusion OTBI - Fixed Assets - Assets Transactions Real Time Subject Area is Not Returning Data (Doc ID 2352443.1) Review the below doc and make sure to have proper Job/Duty roles assigned to the user: Job Roles:Asset Accountant Asset Accounting Manager Duty Roles:Fixed Asset…

Hi Wilson, Try creating a report from : Procurement - Requisitions Real Time subject Area Add Columns:Requisition Number Requisition Status Current Approver Name Approval Status Filter by Pending Approvals to show only requisitions awaiting action.…

Check this: About Charts How to Dipslay Total at the Top of Stacked Vertical Bar Chart — Oracle Analytics

Check this , If it helps: View Reporting Roles and Permissions

Review the below KM notes as it might be helpful: Fusion BI Publisher - Time Zones Display - Best Practices of Coding (Doc ID 2256176.1) Fusion BIP: How to get user preferred timezone in BIP reports (Doc ID 2425942.1) Set Default Time Zone For All Users in Fusion Applications (Doc ID 1630493.1) Legal Entity Time Zone -vs-…

Hi @User_I895I, Below steps are the minimum set of steps required , to access data through cross subject area analysis Please make sure that columns from a CONFORMED Dimension are included in the analysis (= a dimension common to both subject areas ) Include at least one Fact / Measure column from each subject area - In…

Try formatting using <?if:condition?> ... <?end if?> statements. You can wrap the column in an if statement to exclude it when values are null: xml <?if: COLUMN_NAME != ''?> <Column> <?COLUMN_NAME?> </Column> <?end if?> Check this: Use Conditional Formatting Ensure Hidden Columns stay Hidden in all Report Formats — Oracle…

Instead of just display:none, try applying conditional formatting to the entire column, including the header. See if it helps:set a condition like ifnull(column_name, '') to hide both the data and the header.

Hi Hylton, Use Conditional Formatting in Column Properties Navigate to Column Properties in OTBI. Under the Conditional Format tab, set a rule to hide columns when they contain null values. Set Properties for Columns

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…