Knowledgebase
(10)OPERA (24)Downloads (1)Call Escalation Procedure (9)Vision for Opera (11)Material Control (3)E-Invoicing (FATOORAH) (1)Opera Reports (1)Opera Backup Office Interface OPERA Cloud (1)SolutionIP (14)Micros (2)Simphony VAT (3)Suite 8 (78)Sun Systems
SEARCH
Knowledgebase:
Duplicate records deletion from Opera BO
Posted by Syed Qutubuddin, Last modified by Kaize Ahamed on 06 August 2019 03:54 PM

 

Go to Opera--> Utilities Opera SQL

SELECT * FROM BOF$INT_SETUP WHERE BOF_TRX_CODE='xxxx'


(after finding the duplicate ones note down their BOF_SETUP_ID which is extra)

Then DELETE command as follows:

DELETE BOF_TRX_CODE ='xxxx' where BOF_SETUP_ID='yyyy'

after COMMITT successful use the first SELECT query to see if duplicae exists or not.

 

 

example : DELETE BOF_TRX_CODE ='xxxx' where BOF_SETUP_ID='yyyy'


example : DELETE from BOF$_INT_SETUP where BOF_TRX_CODE ='4507' and BOF_INT_SETUP_ID='446'

 

 

(0 vote(s))
Helpful
Not helpful