Journal Approval Limits Ignored Where DR And CR Amounts Are Negative - Notifications Routed Incorrectly (Doc ID 2750264.1)

Last updated on FEBRUARY 08, 2021

Applies to:

Symptoms

Journal Approval Limits Ignored Where DR And CR Amounts Are Negative - Notifications Routed Incorrectly


Journal Approval limits have been setup where the Asst. Controller has a $1 limit defined.

However, Asst. Controller was able to approve a journal entry where the DR and CR amounts are negative 2.00 (DR = -2.00 and CR = -2.00).

Everything works fine when the DR and CR amounts are positive (DR = 2.00 and CR = 2.00).

Users want journals to "Go Up Management Chain" , where JE has negative DR and or CR amounts, until the approval request reaches a supervisor with sufficient approval limit.

However, the first supervisor (Asst. Controller) with only a $1 approval limit is able to approve the journal batch with negative line amounts every time.

The user tested using "Go Direct" as well, but the approval request still went to this first supervisor (Asst. Controller) who only has a $1 approval limit, and journal was approved.

The test case journal batch has a net absolute amount of $2.00, bigger than $1.00 approval limit.

Both example batches return 2 for both the negative DR and CR and the positive DR and CR example.

SELECT max(abs(nvl(JEL.accounted_dr, 0) - nvl(JEL.accounted_cr, 0)))
FROM GL_JE_LINES JEL,
GL_JE_HEADERS JEH
WHERE JEH.je_batch_id = &batch_id
AND JEH.je_header_id = JEL.je_header_id
AND JEH.currency_code != 'STAT';

There is no delegation or transfer of authority involved here at all.

Neither the preparer or supervisor have workflow administrator role, only the System Administrator has this role.

The users expect the approvals to validate as per the net absolute line amounts.

Having negative DR and CR amounts should not affect Journal Approval in any way, but it is.

The Asst. Controller is even able to approve a journal batch with a much larger max net absolute amount when DR and CR amounts are negative.

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.