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!

Find Bank account numbers history

Discussion in 'Oracle HRMS & Payroll' started by kartheekbk, Nov 20, 2014.

  1. kartheekbk

    kartheekbk Active Member

    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    80
    Hi Forum,

    is there any way to find employee's previous bank account number history in oracle apps ? (either from application or from DB)

    for example,
    I have created one employee and assigned one bank ac. on Jan,2012. and again updated the bank ac. on Jan,2013, and now again updated bank ac. on Jan, 2014.

    Now I want to find what are all the current and previous bank account assigned to this employee.


    Hope you understood my requirement.

    Please advise.


    Regards,
    Kartheek B
     
  2. rajenb

    rajenb Forum Expert

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

    From application side, alter your effective date to dates prior to the changes and query.

    From DB side, query the "pay_personal_payment_methods_f" table for the assignment_id.
     
    kartheekbk likes this.
  3. kartheekbk

    kartheekbk Active Member

    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    80
    unfortunately we dont have any records in the "pay_personal_payment_methods_f table.

    Thanks Rajen.
     
  4. rajenb

    rajenb Forum Expert

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

    This is the standard table where Employee's payment methods are stored.

    Can you tell us where exactly in Oracle apps you are storing these information ?

    By where, I mean, in which Responsibility / Navigation path, Menu/form/screen ...
    And if possible, please provide screen shots.

    Thanks.