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!

Cannot complete AR Transaction

Discussion in 'Oracle Financials' started by yingsras, May 2, 2012.

  1. yingsras

    yingsras Forum Advisor

    Messages:
    155
    Likes Received:
    16
    Trophy Points:
    280
    Location:
    Bangkok, Thailand
    Hi everyone,

    I created an Transaction but cannot complete it. Got the error said "APP-AR-42536: This transaction is associated with at least one invalid or end-date GL account. Please correct the account."
    Then I checked at the Account Combination at GL and found that some accounts in Transaction are disabled. So, I enabled them and clear cache. And back to the Transaction again to re-complete.
    But I still got the same error as before. I don't know now where the problem is, because I already enabled all account that this transaction use.
    Can you please advise?

    Thanks,
     
  2. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    pls upload the error message
     
  3. yingsras

    yingsras Forum Advisor

    Messages:
    155
    Likes Received:
    16
    Trophy Points:
    280
    Location:
    Bangkok, Thailand
    Hi Ramji,

    Thanks for your help.
    The error message is
    APP-AR-42536: This transaction is associated with at least one invalid or end-date GL account. Please correct the account.

    But I already search on metalink id and followed but issue still happening.

    Now I'm logging on the SR, will update here after got the solution.

    Thanks,
    Ying
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    yingsras likes this.
  5. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Try Unfreezing and Freezing the accounting flexfield and see if it makes any difference.
    cheers
    Ramji
     
    yingsras likes this.
  6. yingsras

    yingsras Forum Advisor

    Messages:
    155
    Likes Received:
    16
    Trophy Points:
    280
    Location:
    Bangkok, Thailand
    Hello Ramji,

    I already tried to freeze and unfreeze the accounting flexfield but nothing changed.
    Then I disable all cross validation rules and try again it works.
    So I think I need to review the cross validation rules because this is the upgraded application and database and add more segments in COA.

    Thanks,
    Ying
     
  7. I just have same problem, and i try to check in distribution account one by one, the result is my distribution account has not compelete. so i has completed the account and try again, and it was success to complete and apply the receipt. :)

    Thanks,
    Listiany
     
    Amr Mohsen and yingsras like this.
  8. Amr Mohsen

    Amr Mohsen Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Cairo, Egypt
    the same here it was distribution lines not completed yet