Errors Saving Online Receipts Post Upgrading Database - rvtptcontrol failed: RVTPT-054: ORA-01086: ORA-07445: APP-FND-00204
Last updated on OCTOBER 09, 2017
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
On 12.1.3 instance, Online Receipts Fail with the following error messages:
RVTPT-054: ORA-01086: savepoint 'START_TRX' never established in this session or
Cause: A SQL error has occurred in RVTPT. The SQL error is &LSQL_ERR.
Action: Take note of both this error number and the actions you were t
RVTII-060: Subroutine INV_TXN_MANAGER_PUB.process_Transactions() returned error
Cause: Subroutine INV_TXN_MANAGER_PUB.process_Transactions() returned an internal error.
Action: Note this error number and the actions you a
RVTVT-065: Subroutine afdname() returned error
Cause: Subroutine afdname() returned an internal error
Trace file shows several instances of error below:
1. Ensure profile option RCV: Processing Mode is set as 'ONLINE'
2. Navigate to Inventory > Transactions > Receiving > Receipts
3. Query expected receipts for the document in question
4. Enter Receipts details and save
5. Error occurs
Use Immediate mode for RCV: Processing Mode
Oracle database upgrade from 22.214.171.124 to 126.96.36.199
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms