Oracle EBS: AR transaction number的跳號要由20改為1

修改ARPLBSUB.pls ($AR_TOP/patch/115/sql)
PACKAGE: ARP_BATCH_SOURCE
Procedure: create_trx_sequence


原程式:
l_sql_stmt := 'creat
e sequence '||l_sequence_name||
' minvalue 1 maxvalue 99999999999999999999 start with '||
to_char(P_last_number + 1)||' cache 20';

改為:

l_sql_stmt := 'create sequence '||l_sequence_name||
' minvalue 1 maxvalue 99999999999999999999 start with '||
to_char(P_last_number + 1)||' nocache ';


再recompile package.


Ref:
1.How To Create Automatic Transaction Numbering Sequence for Transaction Batch Source Always with Nocache option? (Doc ID 428561.1)