- goal: How You Can Reset The Sequence Number For The REQUEST_ID
- fact: Oracle Application Object Library
fix:
A-Please ensure that you have a current system backup prior to performing this
process.
1-Log in to SQLPLUS as apps/'apps password'.(If it doesn't work Use with SYSTEM user from DB node)
2-SQL> drop sequence fnd_concurrent_requests_s;
3-SQL> create sequence fnd_concurrent_requests_s
start with xxxx;
4-Check the sequences again.
SQL> select max(request_id) from fnd_concurrent_requests;
from system.dual;
B-The value from step 4 should be bigger than value from step 3.
No comments:
Post a Comment