Oracle Fusion SCM Analytics

Home› Oracle Analytics› Forums› Oracle Fusion Data Intelligence› Oracle Fusion SCM Analytics

Categories

Welcome to the Oracle Analytics Online Forum!

We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.

Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

How to join the ideation management with Items table

Received Response
31
Views
5
Comments
User_1EN5M
User_1EN5M ✭
edited September 8 in Oracle Fusion SCM Analytics

Hi everyone,

I have a customer requirement to create a report that includes the following details:

Idea Number / Relationship
Idea Requestor
Item details

I’m trying to determine the correct joint key between the ACN_IDEA_VL table for the ideation details and the EGP_SYSTEM_ITEMS_B_V table for the item details.

Could anyone guide me on how to link these two tables?

Thanks

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle ✭✭✭✭✭

    @User_1EN5M - Based on the table details provided, it appears that you are using Fusion SCM. Kindly confirm. Thanks.

  • User_1EN5M
    User_1EN5M ✭

    Yes I'm using Fusion SCM

  • Gianni Ceresa
    Gianni Ceresa mod
    edited September 8

    Hi,

    Are you using FDI? If yes, which one between ERP, SCM, HCM, CX? Just to know where to move the question.

    If not, your question being about data of a Fusion application (I guess), you should ask in the forum looking after that application. Publisher is the technical tool where you want to write your query, but doesn't own the source data you have a question about. The forum covering the Fusion application is at https://community.oracle.com/customerconnect .

    edit: as you said (while typing this one) that it is SCM: if you are using FDI SCM say it, otherwise look in the CCC forum for the many SCM categories and ask there your data question.

  • User_1EN5M
    User_1EN5M ✭

    Hi Gianni,

    I'm using FDI SCM module.

  • Gianni Ceresa
    Gianni Ceresa mod

    Moved to the FDI SCM category