Hi @Arun P_Kumar , Please check the below URL: Including User Information Stored in System Variables in Your Report Data Thanks, Riyaz Ali

Hi Prateek, Check below URL for more details: Creating a Business Intelligence Cloud Extract Thanks, Riyaz Ali

Hi Milan, Check below docs as it might be helpful: Getting Started Guide for Administrators Commercial Measurement Usage Metrics For BIP, Check below: How To Configure And Use Audit In BI Publisher For Fusion SaaS Cloud Customers? (Doc ID 2059102.1) Thanks, Riyaz Ali

Hi @skhan , Please review the below KM note: Incorrect Costs Displayed Using "Project Costing-Actual Cost Real time" OTBI Analysis (Doc ID 2711557.1) You could also try posting it in the product specific analytics forum and there are better chances of getting the right guidance. Thanks, Riyaz Ali

Please reviw the below KM note: Project Costing - Actual Costs Real Time is not Displaying the Person Data (Doc ID 2454069.1) Please make the changes to the data roles as below. Navigate to the Setup and Maintenance work area and click Search. On the Search page, search for the Manage Data Role and Security Profiles task.…

Hi @skhan, If 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

Hi @skhan , Try Recalculating Margin % at Grand Total Level:You need to create a separate calculated column for the grand total margin % using this logic: Create a new measure column: sql (SUM("Margin") / SUM("Revenue")) * 100 Place this column in a narrative view or in a separate section of the dashboard. Hide the…

Please check the below: Unable To Embed Hyperlink Within Text in an RTF Template (Doc ID 2336537.1)

ORA-00942: Table or View Does Not Exist: The table/view name is incorrect or doesn’t exist in your schema. You don’t have SELECT privileges on it. Use this query to check if the object exists: SELECT owner, object_name, object_type FROM all_objects WHERE object_name LIKE '%WIS_WORK_DEFINITIONS%' AND object_type IN…

Hi , You can try creating a analysis in OTBI using the Manufacturing – Work Order Performance Real Time subject area. Columns to Include: Work Order Number Work Order Description Work Order Creation Date Scheduled Start Date Work Center Name (this is the key column to filter for NULL) Filters to Apply Work Center Name → is…

Hi, Try this: SELECT wd.WORK_DEFINITION_HEADER_NAME AS work_definition_code, wdn.WORK_DEFINITION_NAME AS work_definition_name, wd.WORK_DEFINITION_TYPE, wd.INACTIVE_DATE AS end_date, op.OPERATION_SEQ_NUMBER, op.OPERATION_TYPE, op.OPERATION_NAME, op.DESCRIPTION AS operation_description, wc.WORK_CENTER_NAME,…

Hi Sudheer, “Line Quantity” This is often the most reliable column for PO line quantity. If it’s not visible in your current subject area, try switching to: Procurement – Purchase Orders Real Time Procurement – Purchasing Agreements Real Time (if you're working with blanket POs) “Quantity Ordered” or “Quantity” These may…

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')) )?>