Supplier Management

Get Involved. Join the Conversation.

Topic

    Madhu G
    Need Audit tables list in Oracle cloud
    Topic posted June 17, 2019 by Madhu GRed Ribbon: 250+ Points, tagged Approvals/Notifications, Audit, Financials, Fusion, Payables, Security, Setup, Supplier Creation, Supplier Profile Management, Supplier Registration, White Paper 
    61 Views, 8 Comments
    Title:
    Need Audit tables list in Oracle cloud
    Summary:
    Enabled Audit feature for Supplier header and supplier sites
    Content:

    Hi,

    Need help in Audit tables list for Oracle cloud, as per the requirement we enabled the audit feature for supplier model for few columns like Supplier name, Supplier site, IBAN etc.

     

    We need to see in which table these history will be saved, I am unable to get the Audit table names, Please help.

    Comment

     

    • Niamath Jeddy

      Madhu,

      Below support note will help:

      What Are The Tables Where The Audit Information Is Kept? (Doc ID 1923367.1)

      There are shadow tables for example, POZ_SUPPLIERS_ is shadow for POZ_SUPPLIERS.

      Regards,

      Niamath

      • Madhu G

        Hi,

        After research and your suggestions I have done below Mapping, But still unable to find for few. Could you please help on the mapping.

        POZ_SUPPLIERS_PII_ --
        Supplier Name                 : Not Found
        Supplier Alternate Name  : Not Found
        Tax Registration Number  : Not Found
        Taxpayer ID (for 1099)       : POZ_SUPPLIERS_PII_ -----> Income_tax_id

        POZ_SUPPLIER_SITES_ALL_M_ 
        Address Details   : Not Found
        Pay Group =    POZ_SUPPLIER_SITES_ALL_M_  -------->Pay_Group_lookup_code
        Payment Terms = POZ_SUPPLIER_SITES_ALL_M_-------->terms_id

        Bank Name  : Not Found

        Bank Branch Number: Not Found

        Bank Account Number: Not Found

        IBAN Number: Not Found

        Please help if possible, we are specifically looking for the audit table where we can see the Column which changed and updated_by as well for the above fields in Suppliers.

         

        Thanks,

        Madhu

        • Aishwarya Pawar

          Hi Madhu,

          Assuming you are looking for Supplier Name, Supplier Alternate Name from POZ_SUPPLIERS_  correct?

          Let me check internally and get back.

          Thanks,

          Aishwarya

    • Aishwarya Pawar

      To add to Naimath 's comment, more details about tables are available here:

      https://docs.oracle.com/en/cloud/saas/procurement/19b/oedmp/supplier-model.html#pozsuppliers-17868

      • Madhu G

        Hi Aishwarya,

        As explained above, I am unable to get mapping for above fields, If possible please help me on above.

         

        Thanks,

        Madhu

    • Smruthi Alladi

      Hi,

      Please find the table/column details for the above fields below.

      Supplier Name                 : hz_organization_profiles_ -> ORGANIZATION_NAME
      Supplier Alternate Name  : hz_addtnl_party_names_ -> party_name where party_name_type='PHONETIC'
      Tax Registration Number  : zx_party_tax_profile_ --> REP_REGISTRATION_NUMBER

      POZ_SUPPLIER_SITES_ALL_M_
      Address Details   : hz_party_sites table has address details

      Bank Name  : iby_ext_bank_accounts_ --> BANK_ID
      to get bank  name - select bank_name from CE_BANKS_V  where bank_party_id=<bank_id>

      Bank Branch Number: iby_ext_bank_accounts_ --> BRANCH_ID
      to get branch name - select bank_branch_name from CE_BANK_BRANCHES_V  where branch_party_id=<branch_id>

      Bank Account Number: iby_ext_bank_accounts_ --> BANK_ACCOUNT_NUM

      IBAN Number: iby_ext_bank_accounts_ --> IBAN

      Please let us know if you need any other details.

      Thanks,

      Smruthi

      • Madhu G

        Hi Smruthi,

        Really appreciate your help, Yes all the supplier level tables worked. But the only issue here is  iby_ext_bank_accounts_ is holding only current update value. But for Audit purpose we really need a table where it will store the history of the updates like POZ_SUPPLIER_SITES_ALL_M_ does. It will have all the versions of the updates.

        Please help me in this scenerio if possible. I am lacking Bank Name,Bank Branch Number,Bank Account Number,IBAN Number.

        Meaning if I changed the Bank name from A to B, The expectation is the Audit table should hold both details of A and B. But iby_ext_bank_accounts_ is holding only Latest update details like Bank Name id B now.

        I hope you understood my issue.

        Thanks,

        Madhu.

    • Smruthi Alladi

      Hi Madhu,

       iby_ext_bank_accounts_ table also stores history of updates similar to POZ_SUPPLIER_SITES_ALL_M_. A row will be created for each update in the table.

      Could you let me know the steps followed to check this. Also let me know the query used to check the data in the table.

      Thanks,

      Smruthi