2023-04-14

[Oracle]How to Data Fix Sequences Define or Assigments Error

--Step1、Query Data
SELECT FDS.DB_SEQUENCE_NAME, FDS.DOC_SEQUENCE_ID, FDS.NAME
  FROM FND_DOCUMENT_SEQUENCES FDS
 WHERE 1 = 1
   AND FDS.NAME = 'Want to Delete Data'

--Use Step1 DB_SEQUENCE_NAME
DROP SEQUENCE APPLSYS.XXXX; --其餘省略

--Use Step1 DOC_SEQUENCE_ID
DELETE FND_DOC_SEQUENCE_ASSIGNMENTS FDSA
 WHERE FDSA.DOC_SEQUENCE_ID = XXXX

--Use Step1 NAME
DELETE FND_DOCUMENT_SEQUENCES A
 WHERE 1 = 1
   AND A.NAME = 'XXXX'

沒有留言:

張貼留言