APP-SQLAP-10000: ORA-00001, Cannot create supplier

纵横四海

一个参考资料

Dear sir,

I'm having problem with error as below. Cannot create new supplier due to this error.

APP-SQLAP-10000: ORA-00001: unique constraint
(PO.PO_VENDORS_U1) violated occurred in
AP_VENDORS_PKG.INSERT_ROW <-APXVDMVD
with parameters (ROWID=, VENDOR_ID=1095)
while performing the following operation:
Insert in PO_VENDORS.


Action:

Reset the value of minimum value of sequence P)_VENDORS_S maximum value of vendor_id from
po_vendors table

1) Get value of following query":

select max(vendor_id) from po_vendors


If the value returned by this query is X

2) Get value of following query:

select PO_VENDORS_S.nextval from dual

If the value returned from this query is Y

3) Check X>Y+1 If yes then

drop sequence Po_Vendors_S;

create sequence Po_Vendors_S minvalue <replace this by X>;




The issue still not solved. Is there anything else that we can do to solve this issue?

Thank you
mish

纵横四海

Hi Mish,

http://www.dba-oracle.com/sf_ora_00001_uni...nt_violated.htm

MetaLink offers information regarding trace files and ORA-00001applying to version 11.5.9 on all platforms. Here, it is commonly found that ORA-0001will be thrown when an item is being imported. Though ORA-00001 does not appear in the log file, neither is ORA-0001 appearing in MTL_INTERFACES_ERRORS, when the import complete the table is shown as failing upon enable INCOIN. ORA-0001 is shown in MTL_INTERFACES_ERRORS as err=1 ie unique constraint violated.

This signifies ORA-00001 because of an orphan record in the MTL_REVISIONS_INTERFACE table, perhaps because of an import program that has been run in the past. ORA-0001 is an issue here because upon inserting a new record in MTL_SYSTEM_ITEMS_INTERFACE the import inserts the record in MTL_REVISIONS_INTERFACE before to attempts passing the record to MTL_ITEM_REVISIONS_B via the MTL_REVISIONS_INTERFACE. Because SELECT via MTL_REVISIONS_INTERFACE fetch one or more records, due to orphan records, the INSERT fails, and ORA-0001 is thrown.

MetaLink advises that upon truncating MTL_REVISIONS_INTERFACE will take care of ORA-00001by using the instructions below:

Create table backup_<tarno> as select * from MTL_REVISIONS_INTERFACE
Truncate table MTL_REVISIONS_INTERFACE
Resubmit item for item import