My Oracle Support Banner

FRM-40735: POST_QUERY trigger raised unhandled exception ORA-06502 After Transaction Type Is Updated Using Update API (Doc ID 2265416.1)

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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.