RVohra

@Sophiya , thanks for your question. Appreciate if you can provide additional details since there is no table like scm_supply_headers in fusion. You might be able to find below details useful for you case… DOO_HEADERS_ALL DOO orchestration headers High-level orchestration of fulfillment DOO_LINES_ALL DOO orchestration…

in How can we relate DOO_headers or with fulfill table with requisition/po/with receipt for BIP report Comment by RVohra Jan 2, 2026 10:46PM

Nice one, also liked the video. Thanks for sharing.

in Transportation: Logistics Risk Analytics Comment by RVohra Jan 2, 2026 10:17PM

While waiting for your idea to be reviewed by Product Team, I would suggest you read this blog, Oracle Analytics team has done tremendous job by adding new AI profiling capabilities for insight generation, and an expanded list of data modelling sources supported, It has many new features to explore. Hope it helps!

in Enable Sankey Diagrams with Support for Multiple Values in Oracle DV Comment by RVohra Jan 2, 2026 10:06PM

Upvoted!

in Enhancement Request: Dynamic Column Display Based on Checkbox Selection in Table Visualization Comment by RVohra Jan 2, 2026 9:55PM

It will definitely enhance the usability for business users who extensively use OAC.

in Enhancement Request: Dynamic Column Display Based on Checkbox Selection in Table Visualization Comment by RVohra Jan 2, 2026 9:54PM

Additionally, please check for Requisition UDFs (DFFs or EFFs), for each segment - "BI Enabled" is checked. Hope it helps!

in In my TEE zone, requisitions exist, but some user-defined field (UDF) values are not being pulled in Comment by RVohra Jan 2, 2026 9:46PM

Absolutely agree with SteveF about "TEE zone", appreciate a context. In the meantime, I am assuming it is something to do with Purchasing, so you might want to consider putting the question in SCM customer connect forum as well.

in In my TEE zone, requisitions exist, but some user-defined field (UDF) values are not being pulled in Comment by RVohra Jan 2, 2026 9:42PM

I believe Oracle does NOT deliver seeded OTBI KPI analyses for Purchasing KPIs out-of-the-box. Can you try building a custom OTBI analyses that return a single KPI value (metric card style) using Procurement subject areas (e.g., Procurement – Purchasing Real Time). Save them in Shared Folders e.g. /Shared Folders/Custom/……

in Redwood Purchasing Landing Page - Seeded KPIs and OTBI Analyses Availability Comment by RVohra Jan 2, 2026 9:24PM

Hi @User_UA8ST, I would advise you to post this question in Pricing — Cloud Customer Connect Thanks

in How to edit groovy script and test in Pricing algorithm? Comment by RVohra Dec 29, 2025 8:20AM

Hi @User_OJ47U It is currently not possible to restrict access to the tables. There is currently an idea https://cloudcustomerconnect.oracle.com/posts/9c82838cd2 Users having BI admin or BI author roles can query all the tables in Fusion schema from data model. It is not possible to restrict specific tables from BI…

in Is there a way to allow SCM user to have access of creating data model using SCM tables? Comment by RVohra Dec 29, 2025 8:17AM

As per Oracle Doc, create a bursting workbook email schedule to deliver data visualizations to recipients if the data visualizations contain confidential data that is accessed by specific application roles and user groups configured in Oracle Analytics. Each recipient receives a customized data visualization based on their…

in Fusion SCM workbook new schedule option in FDI not displaying Comment by RVohra Dec 29, 2025 8:12AM

As per my knowledge, FRS (Financial Reporting Studio) reports do not have a built-in "Auto-Increment" checkbox for the Accounting Period parameter like some standard ESS jobs do. However, you can achieve this exact functionality by using the Batch Scheduler in combination with the Current POV (Point of View) function.…

in Is there any we can increment the parameters of scheduled FRS report Comment by RVohra Dec 29, 2025 7:49AM

There could be many reasons for this error, please check following: Ensure the database instance hosting the DAC repository is actually UP and OPEN. Log in to the DAC server host and run tnsping <TNS_ALIAS> or telnet <DB_HOST> <PORT> to ensure the network path is open. Check if the DAC repository database user (e.g.,…

in DAC services are going down with below error. Comment by RVohra Dec 29, 2025 7:37AM

Please explore following PJF tables: PJF_PROJECTS_ALL_B PJF_PROJ_ELEMENTS_B PJF_PROJ_ELEMENTS_TL

in Project Execution Management - Operational Milestones Comment by RVohra Dec 29, 2025 6:44AM

As per my understanding, operational (non-transactional) project tasks / milestones are NOT supported for reporting in OTBI or FDI as of 25D. Only financially relevant plan lines (cost/revenue enabled) are exposed to OTBI PPM subject areas and the FDI DW_PROJECT_PLAN_LINE_DETAIL_CF fact.

in Project Execution Management - Operational Milestones Comment by RVohra Dec 29, 2025 6:40AM

Hi @kubrail, As per oracle documentation, you must add your KPIs and visualizations to the library using the Visualization Configurations page before they can be used on the Redwood Purchasing Landing Page. Here is the primary Oracle Help Center note that explains how the Visualization Configurations page works for…

in Redwood Purchasing Landing Page - Seeded KPIs and OTBI Analyses Availability Comment by RVohra Dec 29, 2025 6:28AM

It could be something like below … SELECT papf.person_number AS "EmpNumber", ppnf.display_name AS "EmpName", par.responsibility_name AS "RespName", flv.meaning AS "RepRole", prep_names.display_name AS "RepName" FROM per_all_people_f papf JOIN per_person_names_f ppnf ON papf.person_id = ppnf.person_id AND ppnf.name_type =…

in Need Employee Human resources Representative and HR Business Partner Comment by RVohra Dec 29, 2025 6:19AM

Hi @jsmithA , Here are the few key tables that can help you to get the HR Rep and HR BP per_all_people_f per_person_names_f per_asg_responsibilities Hope it helps!

in Need Employee Human resources Representative and HR Business Partner Comment by RVohra Dec 29, 2025 6:16AM

Thanks, SteveF for sharing extensive list of articles, appreciate it.

in Custom SSO with /analytics redirects to standard login page Comment by RVohra Dec 24, 2025 10:31PM

I am not sure if it is supported but it will be interesting to see if it is possible, please share if you are able to come up with a solution. thanks

in How to use current date in a parameter Comment by RVohra Dec 24, 2025 10:24PM

Welcome to the Oracle Analytics and AI Community

RVohra Mod

Comments