Unable To Create AME Rule For Service Contracts Approval (R12) (Doc ID 1345686.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Oracle Approvals Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


When attempting to perform a AME real time transaction test using AME test Workbench for a Service Contracts Internal Approval transaction, the following error occurs.

1. 'An Invalid Setup has been detected for the current Transaction Type in Approvals Management. Please Contact your System Administrator. '

2. Also AME Exception log shows the following:

LOG_ID PACKAGE_NAME ROUTINE_NAME TRANSACTION_ID APPLICATION_ID EXCEPTION_NUMBER EXCEPTION_STRING
752454 ame_engine getTestTransApprovers 2543784 -414 -1400 2011:04:26:15:34:28ORA-01400: cannot insert NULL into ("HR"."AME_TEMP_TRANSACTIONS"."TEMP_TRANSACTIONS_ID")
752455 ame_test_utility_pkg getApprovers 2543784 -414 -1400 2011:04:26:15:34:28ORA-01400: cannot insert NULL into ("HR"."AME_TEMP_TRANSACTIONS"."TEMP_TRANSACTIONS_ID")



OTHER IMPORTANT INFORMATION


1. This error only occurs in the instance where AME_TEMP_TRANSACTIONS.TEMP_TRANSACTIONS_ID is defined as NOT NULL.

2. In the eTRM it shows AME_TEMP_TRANSACTIONS.TEMP_TRANSACTIONS_ID as a NOT NULL column.

3. Error does not occur after
ALTER TABLE ame_temp_transactions MODIFY (temp_transactions_id NULL);

4. File Version:
/* $Header: ameeengi.pkh 120.7.12010000.3 2009/10/15 07:30:18 prasashe ship $ */
/* $Header: ameeengi.pkb 120.35.12010000.12 2010/02/23 15:05:22 prasashe ship $ */

5. Running getAllApprovers.sql generates approver.

Steps to Reproduce: 
The issue can be reproduced at will with the following steps:


1. Test a Service Contracts Internal Approval transaction using AME Test Workbench
2. Shows Error.

 

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