Errors Saving Online Receipts Post Upgrading Database - rvtptcontrol failed: RVTPT-054: ORA-01086: ORA-07445: APP-FND-00204
(Doc ID 2105480.1)
Last updated on DECEMBER 22, 2023
Applies to:
Oracle Inventory Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
On 12.1.3 instance, Online Receipts Fail with the following error messages:
rvtptcontrol failed:
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
Or
Trace file shows several instances of error below:
Steps:
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
WORKAROUND:
--------------
Use Immediate mode for RCV: Processing Mode
Changes
Oracle database upgrade from 11.2.0.3 to 12.1.0.2
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |