1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Transaction Number is not showing in xla_transaction_entities table

Discussion in 'Oracle Apps Technical' started by jagadekara, Jun 20, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All Good morning...

    I have a GL Report which is giving output.

    I am getting transaction number as 1060024

    But when I ran the same query in SQL Developer I am not getting that transaction number.

    I don't know why?

    They used xla_transaction_entities table to display transaction_number.

    So what is the reason?
     
  2. rajenb

    rajenb Forum Expert

    Messages:
    361
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    Hi Jagadekara,

    I think this is a case of Oracle EBS R12's use of VPD (Virtual Private Database) to restrict access to data (instead of using views and synonyms).

    Try to select from "xla.xla_transaction_entities" instead of "xla_transaction_entities".
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Thanks Rajen,

    I got it.

    It is in xla.xla_transaction_entities table.

    note Why are there differences in SELECT * FROM XLA_TRANSACTION_ENTITIES and SELECT * FROM XLA.XLA_TRANSACTION_ENTITIES ? [ID 946314.1].