Hi @Terri Norris , Please check below as it might be helpful: How do I set up a role with read-only access? How to create read only role for the time and labor manager — Cloud Customer Connect Read Only/View Only Job Roles - Benefits and Payroll — Cloud Customer Connect Payroll Manager Restricted View Only Role — Cloud…

Hi User_CYBWX, It looks like your xdofx condition is not filtering correctly, which is why all dates are being returned instead of only those matching the month. You can try below and check: Ensure Proper Data Type Handling The to_char() function extracts the month as a string, but sometimes XML data types can cause…

Please check the below as it might be helpful: Payables Invoices - Transactions Real Time How to apply "Group By" Condition on a column - in OTBI Analyis? — Cloud Customer Connect OTBI Analysis - Invoices paid by date paid — Cloud Customer Connect

Please check the below: Suppress Null Values in Views How to suppress rows and columns with 0 value on a pivot table? — Oracle Analytics

REST webservices of BI Publisher are currently not available for consumption in Fusion Application. There are no plans to include REST APIs in Fusion Applications.

@Omran Zeaiter You can try the below: 1.Extract the OTBI Report SQL Open the OTBI report and navigate to Advanced. Copy the Logical SQL or Physical SQL used in the report. 2. Create a New BIP Data Model Go to Reports and Analytics → Browse Catalog. Click New → Data Model and select SQL Query as the data source. Paste the…

Check the below as it might be helpful: Fixed Assets- Asset Balance Real Time and GL Segments — Cloud Customer Connect Account Combinations / Segments used for Cost and Reserve Accounts for Asset Transfer Journals (Doc ID 2474141.1) Fixed Assets - Asset Balances Real Time

Check this: OTBI Usage and Performance Subject Areas Reference

Thanks for the info!!!!

@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…