Troubleshooting Asset Tracking Pending Transactions
By LuciaC-Oracle on Jan 10, 2014
If you use Oracle Asset Tracking then you'll know that sometimes transactions can get stuck in Pending status. Why does that happen? When Oracle Asset Tracking creates a transaction that has a financial, asset-related impact, the transaction is stored in transactional table with an Oracle Install Base status of 'Pending'. Later, concurrent programs read the transaction log and process all the transactions in sequence; each transaction goes through a number of processes. If any of these processes fail, then the transaction status remains at the Pending stage.
A new comprehensive troubleshooting note has been written to help you identify root pending transactions, process pending transactions and check your installation. Take a look at 'Guidelines For Processing Pending Transactions in Oracle Asset Tracking' (Doc ID 1608224.1) for all the details.
If you have any comments on this note, maybe you have improvement suggestions or have some issue when trying out the suggested steps, remember that you can post your questions or comments to the My Oracle Support Install Base community.