Hi @User_MHPVE, XCC_BALANCES Stores budget balances including consumption and available funds. XCC_BUDGET_DIST_ACCTS Contains distribution account details for budget entries. XCC_CONTROL_BUDGETS Holds control budget definitions. XCC_BUDGET_TRANSACTIONS Captures individual budgetary control transactions. SELECT…

Hi @Luke.Findex , You can by try by using presentation variables in your dashboard prompts. Here's how to set it up so that users select a Display Name, but the system uses the corresponding Person ID behind the scenes to filter multiple analyses—even across different subject areas. Create a Dashboard Prompt Go to New →…

@Amrish_Amradkar, Try the below:Edit the OTBI Dashboard. Add a new section to the dashboard page. Insert a Text object into that section. In the Text object, add the following HTML: Hide the section so it doesn’t interfere with the dashboard layout. <META HTTP-EQUIV="REFRESH" CONTENT="60"> This refreshes the dashboard…

Hi @Ivony Ann Paula Salango, Thanks a lot. Thanks, Riyaz Ali

Hi @Dinesh T , You can use a WHERE clause like this in your BI Publisher SQL: WHERE prb.effective_date BETWEEN TO_DATE(:start_date, 'YYYY-MM-DD') AND TO_DATE(:end_date, 'YYYY-MM-DD') AND ppa.action_status = 'C' -- Only closed payroll actions SELECT prb.balance_value, prb.effective_date, pdb.balance_name, ppa.action_status…

Hi @Jose Angel RuizMen 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

Yes, it is absolutely possible. Please review the below KM note: How To Restrict Access To Custom and Other Folders in Reports and Analytics As All Users Have BI Consumer Role (Doc ID 2764614.1)

Hi @Srinivas_Buddharaju, Try the below and see if it helps:Reinsert the Image as a Supported Format Delete the existing logo/image. Reinsert it using Insert > Picture > From File in Word. Use PNG or JPG format. Save the RTF again and test in BI Publisher. Ensure the Image Is Embedded (Not Linked) In Word, right-click the…

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…