Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Problem: ORA-20001: The approval group XXHR_EIT_APPROVER_GROUP had no members, and the ALLOW_EMPTY_APPROVAL_GROUPS attribute has the value 'false'.
Set Allow Empty Approval group to False, create an approval group and ensure that the same is null, on the review page system errors out and shows AME_400229_HAN_APR_NO_MEM message , however you can still submit the transaction, which then errors out and send notification to SYSADMIN for resolution and all this time till the resolution is done, the transaction is shown pending.
System should not allow the transaction to be submitted in its first place.
Symptoms:
Set Allow Empty Approval group to False, create an approval group and ensure that the same is null, on the review page system errors out and shows AME_400229_HAN_APR_NO_MEM message, however you can still submit the transaction, which then errors out and send notification to SYSADMIN for resolution and all this time till the resolution is done, the transaction is shown pending.
SSHR transaction errors out with the message and show that there are no approvers in the list, and yet if the transaction is submitted, it goes into a state of error and sends a notification to SYSADMIN for resolution. System should not allow the users to submit the transaction.
Log files:
**** Errored Activities
Activity RESULT Error Name
--------------------------------------------- --------------- ------------------------------
Error Message
------------------------------------------------------------------------------------------------------------------------------------
Error Stack
------------------------------------------------------------------------------------------------------------------------------------
HR_IS_FINAL_APPROVER_FCT #EXCEPTION -20001
ORA-20001: The approval group XXHR_EIT_APPROVER_GROUP had no members, and the ALLOW_EMPTY_APPROVAL_GROUPS attribute has the value 'false'.
AME_AG_CHAIN_HANDLER.getFirstApprover(127123)
AME_ENGINE.processActionType(127124)
AME_ENGINE.processRules(127125)
AME_ENGINE.updateTransactionState(127126)
AME_ENGINE.getNextApprovers(127127)
AME_API2.getNextApprovers4(127128)
Wf_Engine_Util.Function_Call(hr_approval_ss.isfinalapprover, HRSSA, 28045, 183045, RUN)
*** Error Process Activity Statuses
Begin Date Activity Status RESULT User NID Status
------------------ --------------------------------------------- -------- --------------- ------------ -------- --------
22-SEP-10 13:42:43 ROOT/HR_STANDARD_ERROR_PRC COMPLETE ERROR
22-SEP-10 13:42:43 HR_STANDARD_ERROR_PRC/START COMPLETE #NULL
22-SEP-10 13:42:43 HR_STANDARD_ERROR_PRC/HR_SYSTEM_ERROR_NTF COMPLETE #NULL SYSADMIN 5593637 OPEN
22-SEP-10 13:42:44 HR_STANDARD_ERROR_PRC/END-3 COMPLETE #NULL
*** Error Process Activity Statuses History
Solution:
What you see is the intended behavior of the system.
When users see an error on the review page, they need to report the error to the system administrator to get the error fixed.
The system does not disable the submit button in any case.
If users go ahead and submit the transaction, the transaction will error out and willbe pending till the error is fixed.
Once the error is fixed, you can either retry the same transaction as the workflow administrator or purge and redo the transaction.
Please set user expectation accordingly.
Enhancement Request ER 6530831 - SUBMIT BUTTON SHOULD NOT BE ACTIVE FOR TRANSACTION WHEN SYSTEM ERRORS has been created
This is the usage of ALLOW_EMPTY_APPROVAL_GROUPS attribute.
Attribute Purpose:
The ALLOW_EMPTY_APPROVAL_GROUPS attribute takes a Boolean value of either True or False, to control if existing Approval Groups are allowed to have no assigned members at run time.
Settings Result - FALSE:
Setting the value as FALSE results in AME raising an Exception message if there are no member assignments at point of run-time. The most common occurrence of such a situation is when the Approval Group is generated dynamically with an SQL criteria used to retrieve members, which returns no rows.
Settings Results - TRUE:
Setting the value as TRUE results in AME allowing an Approval Group to then have no members at run-time without an exception raised.
Action Types:
There are three predefined action types (types listed below) that use approval groups, one for each sub-list in an item's Approver List. All three Approval Group Action Types REQUIRE that the attribute ALLOW_EMPTY_APPROVAL_GROUPS be set to either TRUE or FALSE. This attribute can not be left NULL for any of the following Action Types:
• Approver-Group Chain of Authority
(Treats the Approval Group as a Chain of Authority)
• Pre-Chain of Authority
(Inserts approver groups before the authority sub-list of an item's approver list.)
• Post-Chain Authority
(Inserts approver groups after the authority sub-list of an item's approver list.)
Navigation Path:
• Select "Approvals Management Application Administrator"
• Select "Approvals"
• Select "Purchase Requisition Approval Transaction Attributes"
• Select Header Level Attribute "ALLOW_EMPTY_APPROVAL_GROUPS"
• Set to either True or False
• Select "Save"
Please refer to MyOracleSupport
Note: 368280.1 - How Can The Version Of AME Be Determined?
Support needs a solid background on your AME patching level.
If your installation is patched to AME.B or higher, Please Review the document attached to
Note.434567.1 - Approvals Management Responsibilities and Setups in AME.B
Please run the AME Setup Report.
MyOracleSupport Note: 287255.1 - Approvals Management Reporting Utility Support
Tool
Download the most recent version of the script from the note and upload the
results to this Service Request (SR).
Upload the Exception Log.
* Post AME.B: this is an option in the UI
Pre-AME.B:
run the following script:
SELECT max(log_id)
FROM ame_exceptions_log;
Make note of the Log Id returned.
Recreate the issue
Run the following script:
SELECT *
FROM ame_exceptions_log
WHERE log_id max log_id recorded previously
ORDER BY log_id desc;
References:
Enhancement Request ER 6530831 - SUBMIT BUTTON SHOULD NOT BE ACTIVE FOR TRANSACTION WHEN SYSTEM ERRORS.
No comments:
Post a Comment