Payables and Cash Management - EBS (MOSC)

MOSC Banner

ORA-00001: unique constraint (APPS.AP_HISTORY_INVOICES_U2) violated

edited Jan 29, 2019 4:02AM in Payables and Cash Management - EBS (MOSC) 1 commentAnswered

While Purging the Parables related data in the 12.1.3 version, we are facing this issue.

Why it is failing for APPS.AP_HISTORY_INVOICES_U2, if Duplicates are there it needs to be failed for AP.AP_HISTORY_INVOICES_U2, But we do not see duplicates on this table.

INSERT INTO AP.ap_history_invoices_all

      (invoice_id,

       vendor_id,

       vendor_site_code,

       invoice_num,

       invoice_date,

       invoice_amount,

       batch_name,

       purge_name,

       doc_sequence_id,

       doc_sequence_value,

       org_id)

       SELECT  api.invoice_id,

               api.vendor_id,

               v.vendor_site_code,

               api.invoice_num,

               api.invoice_date,

               api.invoice_amount,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center