Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OTBI FOR TRACEABILITY

Received Response
21
Views
4
Comments
Regie Mercado
Regie Mercado Rank 4 - Community Specialist
in Oracle Transactional Business Intelligence

Hello and good day!

Dear Oracle Community friends,

I would like to create an OTBI for traceability using the review completed transactions function. Would you know what subject areas should I use? Hoping to hear from someone knowledgeable in this.

Thanks much and best regards.

Regie

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    edited May 14, 2024 7:08AM

    Hi Regie, Your question is a bit vague. When you say "create at OTBI" assume you mean to create a query from the subject areas to view data in either an analysis in OTBI (blue) or in a data model for a report in OTBI (yellow).

    What do you mean by "using the review completed transactions function"? What is this function? Which business process is it? What role do you use to do it? What is the chapter in the user guide for it? In the navigation menu which work area in which folder do you use? Maybe post a screenshot of this page in the user interface? Then we will know which application so hopefully advise what subject area will query that data?

    I have no idea if this is CX, HCM, Financials, Procurement, Projects, or Supply Chain and Manufacturing or may something across all of them in foundation in common applications. etc. let us know which application.

    To review the subject areas go to your documents.

    https://docs.oracle.com/en/cloud/saas/index.html

    Go to top task "Analyze and Report" for your selected application. Then select "Review XXX Subject Areas"

    For example, in HCM

    Oracle Fusion Cloud HCM

    Subject Areas for Transactional Business Intelligence in HCM

    F92793-01

    24B

    https://www.oracle.com/pls/topic/lookup?ctx=en/cloud/saas/human-resources/24b&id=FAOHB

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    Regie,

    Is this business process?


    Materials Management and Logistics
    Ensure that material is effectively managed, from receipt through consumption, to meet customer demand. The process includes inbound logistics, inventory management, and outbound logistics activities. Successfully manage customer demand in a cost-effective manner by optimizing the flow of material and any associated storage.


    Oracle Fusion Business Process Models: 12 Materials Management and Logistics (Doc ID 1578171.1)

    https://support.oracle.com/

    Task "Review Completed Transactions" in work area "Inventory Management" ?

    Oracle Fusion Cloud SCM
    Using Inventory Management
    F92851-01 24B
    Inventory Transactions
    Overview of Review Completed Transactions
    https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/24b/famml/overview-of-review-completed-transactions.html

    If so, review the subject areas in SCM

    Oracle Fusion Cloud SCM
    Subject Areas for Transactional Business Intelligence in SCM
    F92842-01 24B
    https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/24b/faosm/index.html

  • Regie Mercado
    Regie Mercado Rank 4 - Community Specialist

    Hello and good day!

    Dearest Nathan,

    I appreciate your reply, do you have a sample traceability where I can check and pattern if I will make my own OTBI? Hope to hear from you again.

    Many thanks and best regards.

    Regie

  • Regie Mercado
    Regie Mercado Rank 4 - Community Specialist

    Hello and good day!

    Dearest Nathan,

    I am trying to create an OTBI for materials requirement below, would you know how to create the formula for total column with the same item name. Hope to hear from from your end.

    image.png

    Many thanks and best regards.

    Regie