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!

change the code combinations, plz tell me the effected tables in all modules

Discussion in 'Oracle Financials' started by gkpgidnan, Aug 19, 2009.

  1. gkpgidnan

    gkpgidnan Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    Hi Everbody,

    What i mean to say actually i have changed the code combinations in GL.
    For example..

    111.1234.234.4567.6567(old)
    111.001234.0234.4567.06567 (new)
    i have update this code combination,...

    I want to know the effected tables in all modules which is related to code combination.

    can you please help me some one...

    Thanks,
    GKP
     
  2. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    Hello GKP and welcome to the forum.

    My question to you is very obvious. Where have you changed this account? In the backend?

    If you have indeed updated this GL Account, why? You should just enter and effective To Date and create a new account.
     
  3. mimi_miao

    mimi_miao Active Member

    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    80
    if you changed it directly from the table and the segments you have entered has no set-up then it will either cause an error to your GL or no transactions will be entered in that account.
     
  4. gkpgidnan

    gkpgidnan Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    Hi,
    Greetiung, Nice to get you reply.
    I have to change the back end side.,

    we are not going to create new account, becauese so much of transactions are happend based on their code combination, i have to increase the segment values..

    So i want to know the all effeted tables in various moduels like AP,AR,GL,FA,PA,INV and PO for changing the Code combinations(Segments values..)


    Thanks,
    Srini


     
  5. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    hi, apps does not store the accounting code in all tables in all modules but a Code combination ID (CCID). What you are desiring "may" simply be achieved by updating the account segment values in the Flexfiled-->Validation-->Values