Skip to content
  • Register

    • Oracle Transactional Business Intelligence

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

    Welcome!

    Sign in to share your experience and connect with the community.
    Log In
    Register

    Quick Links

    Categories

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

    Error joining subledger and general ledger

    Received Response
    32
    Views
    6
    Comments
    Rank 2 - Community Beginner
    in Oracle Transactional Business Intelligence

    Hello,

    I am trying to create a report that joins the subject areas Subledger Accounting: Journals Real Time and General Ledger: Journals Real Time. It works fine up to the point I add the a supplier DFF from the Journals Real Time subject area. The error message is as follows —

    Details: ADFException-3007: The View Object "FscmTopModelAM.FinGlAccountsCodeComboAM.CodeCombinationPVO" is used as the destination of more than one View Link. (HY000)

    Is there a way to resolve this issue?

    Thanks,

    Walter

    Tagged:

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Log In
    Register

    Answers

    • Rank 8 - Analytics Strategist

      Error joining subledger and general ledger

      Walter Gess

      Hi @Walter Gess,

      Welcome to the Oracle Analytics Community.

      Quick question: Have you taken at least one measure from each of the subject area?

      Thank you.

    • Rank 2 - Community Beginner

      I am new to OTBI so am not sure what specific fields would be defined as a "measure." However, I am using fields from both subject areas and I only get an error when I attempt to use the supplier DFF from the GL journals subject area.

    • Rank 5 - Community Champion

      please add a measure column from the subject areas that will resolve this issue

    • Rank 8 - Analytics Strategist
      Walter Gess

      Hi @Walter Gess,

      By definition a measure is a value applied to dimensions, such as a count of users, Invoice Amount, Journal Total Entered Credit, Journal Line Accounted Amount CR etc.

      In OTBI SAs if an attribute is colored as Golden, those are normally measures. here's an example from the GL Journals SA.

      image.png

      Hope this help.

      Thank you.

    • Rank 6 - Analytics Lead

      One suggestion I have had success with, is to use both subject areas in a complex/union query. Filter SL accounting subject area where sources are SL applications, and similar filter GL subject area not to include SL source applications (filter on journal source).

      Then you can independently build as necessary. So for example AP coming in from subledger you can add in something like invoice #/id in the design on SL side, then on GL side just use a formula that brings back a blank value (use double apostrophe). ''

      image.png

    • Rank 2 - Community Beginner

      Thank you @Bhaskar Konar for the guidance on measures. I did make sure that both subject areas included measures. Unfortunately, that did not resolve the issue as I am still receiving the same error message. Still working to see if I can resolve this. Thanks again.

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Log In
    Register