The issue is almost certainly tied to missing duty roles or data security policies in your custom role. The PO Supplier role likely includes duty roles such as: Supplier Master Data Duty View Supplier Profile Duty View Supplier Site Duty Supplier Transaction Analysis Duty Use the “User and Role Access Audit Report” Go to…

Instead of referencing subtemplates via full URLs, upload them to the BI Publisher Catalog and reference them by Catalog path, like this: <?import:xdoxsl:///Shared/Custom/SubTemplates/YourSubTemplate.rtf?> Try this:-->Upload the subtemplate to a shared folder in both environments (e.g., /Shared/Custom/SubTemplates/). -->In…

Hi User_44NR6, The ACIOA5LN error in OTBI typically indicates an assertion failure related to dashboard prompts or filters. It often appears when: ->A dashboard prompt is misconfigured or corrupted. ->There’s a mismatch between code values and display values in a prompt (e.g., a value expected by the report is missing or…

Hi User_44NR6, The ACIOA5LN error in OTBI typically indicates an assertion failure related to dashboard prompts or filters. It often appears when: ->A dashboard prompt is misconfigured or corrupted. ->There’s a mismatch between code values and display values in a prompt (e.g., a value expected by the report is missing or…

Great initiative!!!

Hi Ivony, If my response has answered your question or assisted you with your concern, please click"yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Thanks, Riyaz Ali

The issue is that to_number() isn't supported directly inside xdoxslt:set_variable() in some cases, especially when nested inside xdoxslt:if(). Try this: <?xdoxslt:set_variable($_XDOCTX, 'prevMonth', xdoxslt:if(substring(Date___local_ID669, 6, 2) = '01', '12', xdoxslt:if(substring(Date___local_ID669, 6, 2) = '02', '01',…

Try this for Previous Month Calculation: <?xdoxslt:set_variable($_XDOCTX, 'prevMonth', xdoxslt:if(substring(Date___local_ID669, 6, 2) = '01', '12', xdoxslt:format_number(to_number(substring(Date___local_ID669, 6, 2)) - 1, '00')) )?>

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!!!!