Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    Juan David Cantillo Hincapie
    Employee Info in Payment from Expenses
    Topic posted October 21, 2019 by Juan David Cantillo HincapieBlue Ribbon: 750+ Points, tagged Expenses, Financials, Payables, Reports 
    18 Views, 1 Comment
    Title:
    Employee Info in Payment from Expenses
    Summary:
    How to obtain the employee National ID in payments from Expenses
    Content:

    How can I get the Employee National ID, Person Number or Security Number in payments originating in expenses?

    Business case
    --------------------------------------
    In creating the files from {IBY_TRXN_DOCUMENTS table (.Document) XML attribute}, that are sent to make payments at the banks, the banks need the employee identification, but this does not appear in the IBY_TRXN_DOCUMENTS table, how can it be obtained? Or which other attribute in employee I can use for this.

    Version:
    19C (11.13.19.07.0)

    Comment

     

    • Kondaiah Mandadi

      Hi,

      In the case of employee expense reimbursements, Payments fetch the National identifier the funds disbursement extract under the following structure -

      -<Payee>

      <PartyInternalID>300100026992452</PartyInternalID>

      <PartyNumber>CDRM_69221</PartyNumber>

      <Name>IBY1 ONE</Name>

      <TaxRegistrationNumber/>

      <LegalEntityRegistrationNumber>991788867</LegalEntityRegistrationNumber>

      . . . . . 

      Recently, we have also addressed an ER - https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=29851448 through which, we are also fetching the National Identifier type.  This will be available in 20A.

      Kondaiah