Reporting and Analytics for ERP

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 BI Publisher, Fusion Financial reporting, Reports 
    171 Views, 7 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

     

    • Sudhakara Rao Kovuru

      Hello,

      Please try below tables for audit details for Supplier Model

      POZ_SUPPLIERS_
      POZ_SUPPLIERS_PII_
      POZ_SUPPLIER_CONTACTS_
      POZ_SUPPLIER_MERGE_REQUESTS_
      POZ_SUPPLIER_SITES_ALL_M_

       

      Thanks,

      -Sudha.

       

      • Madhu G

        Thank you Sudha for the help, it worked. Now we will do some test cases where we supposed to see the updates in Audit tables.

        Additionally, I just have one question. Do we have any incompatible option in Cloud as we do normally in Concurrent requests in Oracle ERP. The issue is we are getting duplicate records due to 2nd time Program is started running while the first program is completing. Please let me know if you have any clue in this regards.

         

        Thanks,

        Madhu.

        • Sudhakara Rao Kovuru

          Hi Madhu G,

          Yes we can do for single job by making false of Allow multiple pending submissions option but not for job sets.

          Please go through the below note and let me know if you have any questions?

          ESS Jobs: Setting Self Incompatibility for Custom Jobs and JobSets for Cloud Users (Doc ID 2304614.1)

          Thanks,

          -Sudha

    • Madhu Babu Vitta

      Hi,

      Audit (Shadow) tables generally have same name as original seeded table name and then ending with underscore "_".

      Ex - POZ_SUPPLIERS_

      ---Audit Tables..
      1)FND_AUDIT_WEBAPP_AM 
        This table contains seeded information on what AMs are available in a given webapp for Auditing.
      2)FND_AUDIT_ATTRIBUTES 
        This table will store the attributes enabled for Auditing.
      3)FND_AUDIT_USER_TABLE_ACCESS 
        This table stores the audit history on when a base table was last updated by a particular user. 
      There will be only 1 row per user and table.

      Thanks,

      Madhu

    • 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

      • Sudhakara Rao Kovuru

        Hi Madhu,

        Please try below tables

        -- Bank Details
        IBY_EXTERNAL_PAYEES_ALL_ 
        IBY_EXT_BANK_ACCOUNTS_
        IBY_EXT_PARTY_PMT_MTHDS_

        --Supplier Details
        POZ_SUPPLIERS_ 
        POZ_SUPPLIER_SITES_ALL_M_

        Thanks,

        -Sudha.