In Oracle database if you find message => JBO-28030: Could not insert row into table PS_TXN, please fix error with :
Last Sequence :
CREATE SEQUENCE PS_TXN_SEQ MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE;
For good performance in oracle need tunning your database. Can use Gather your schema database for the example :
Gather Schema :
BEGIN
SYS.DBMS_STATS.GATHER_SCHEMA_STATS (
OwnName => 'DIARYCODING_DB'
,Granularity => 'DEFAULT'
,Options => 'GATHER'
,Gather_Temp => FALSE
,Estimate_Percent => 0
,Degree => 4
,Cascade => FALSE
,No_Invalidate => FALSE);
END;
For good performance in oracle need tunning your database. Can use Build Table for the example :
Build Table :
BEGIN
SYS.DBMS_STATS.GATHER_TABLE_STATS (
OwnName => 'DIARYCODING_DB'
,TabName => 'TRANSACTION'
,Estimate_Percent => 0
,Degree => 4
,Cascade => FALSE
,No_Invalidate => FALSE);
END;