FRM-40735: POST_QUERY trigger raised unhandled exception ORA-06502 After Transaction Type Is Updated Using Update API
Last updated on MAY 12, 2017
Applies to:Oracle Service Contracts - Version 12.2.4 and later
Information in this document applies to any platform.
When attempting to open a Service Contract that had been updated using the API oks_import_header_pub.update_contract_header to change the transaction type of the contract, the following error occurs.
Note that in the table oks_k_headers_b, the inv_trx_type field is populated with transaction type name for the particular contract which is updated using API. For all other records we can see corresponding cust_trx_type_id populated .
FRM-40735: POST_QUERY trigger raised unhandled exception ORA-06502.
Due to this issue users cannot use the API as published to change the Transaction Type on the contract.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms