@Sunil Nukala2, Certain special characters can cause issues when syncing data in OTBI (Oracle Transactional Business Intelligence), leading to missing or improperly displayed values. Here are some characters that may disrupt data visibility: Characters to Avoid in OTBI Data Sync:Backslash () → Often ignored or…

Thanks for the info!!!

Thanks for the info!!!!

Hi Sunil, Cheeck below: AR print commercial documents bursting — Cloud Customer Connect

Hi Dhanashree, Check the below doc: CST_WORK_ORDER_COSTS Cost Accounting for Manufacturing Work Orders Costing - Work Order Costs Real Time

Hi Karlyn, Try the below: Font Differences Between Environments Check if the RTF template uses a different font in Production. Some fonts handle decimal points differently, causing unexpected formatting issues. 2.Locale & Number Formatting Settings Verify if regional settings (e.g., number formats) differ between Test and…

Hi Sneha, You can group duplicate headers into a single header in your RTF template using BI Publisher’s for-each-group function. Since you cannot modify the data model, the best approach is to group the headers based on the common field (some info: X1). Solution: Using for-each-group in RTF Template Modify your RTF…

Hi Amit, Steps to Restrict Access to a Custom BIP Folder:Create a Custom Role for Restricted Access Navigate to Tools → Security Console in Oracle Fusion. Go to Roles and click Create Role. Assign the role to specific users who should have access. 2. Modify Folder Permissions in BI Catalog Go to Reports and Analytics →…

Hi Ivony, It looks like you're running into duplication issues due to the way OTBI handles subject area joins. Since left joins aren't natively supported, here are some alternative approaches to refine your report: Using Filters to Reduce Duplication: If your report is pulling duplicate rows, check whether the filters are…

Thanks for the info!!!

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…