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.

Symptoms

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 .


ERROR
-----------------------
FRM-40735: POST_QUERY trigger raised unhandled exception ORA-06502.


BUSINESS IMPACT
-----------------------
Due to this issue users cannot use the API as published to change the Transaction Type on the contract.

Cause

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