EGL9.2: Upon Clicking a Journal on Pending Approval or Monitor Approvals - Getting "Invalid parameter 1 for function CreateRecord (2,116)" (Doc ID 2709198.1)

Last updated on JULY 25, 2023

Applies to:

Symptoms

On : 9.2 Image22, Approvals

Deleted Journal still appears in Approval list if it was resubmitted for approval by a user having AWE admin role. When attempting to open such a journal, the following error occurs on Pending Approvals Page:

Steps to Replicate:

1. Enable Journal approval and set up AWE process definition for journal approval to work.
2. Enter a journal, edit and submit for approval.
3. Log in as approver and deny the journal.
4. Set up workflow default for the AWE administrator to enable resubmit.
5. Log in as AWE administrator and resubmit the denied journal.
6. Log in as approver and check if the journal is available in approver's list. Do not perform any action.
7. Log in as requester and delete the journal from General Ledger -> Journals -> Journal Entry -> Create/Update Journals
8. Log in as approver and check if the journal is available in approver's list. Click on the Journal.

- OR -

8. Log in as approver and check if the journal is available on Monitor Approvals. Click on the Journal.

Please note: A similar issue was reported for journals that were deleted via GL Workcenter -> Mass Delete.  This is fixed under a different bug. Information on this can be found in this document:

After a Journal Approval is Denied and then Deleting the Journal from GL WorkCenter -> Mass Delete Journals, User Gets Error: "Invalid Parameter 1 for function CreateRecord" When Clicking on Approval in Approval Workflow (Approval Should Not Exist) (<Document ID 2823418.1>)

Changes

Cause

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