My Oracle Support Banner

Debit Claim Settlement With Ap Debit Creates Accounting With Negative Amount (Doc ID 795879.1)

Last updated on JULY 17, 2020

Applies to:

Oracle Trade Management - Version 11.5 and later
Information in this document applies to any platform.
Information in this document applies to any platform.
Reviewed for relevancy on 24 Sep 2009


A Debit Claim is settled with Settlement Method 'AP Debit'
On checking ozf_ae_lines table, the entry is

Dr Ven_clearing -ve amount
Cr Accrual_liability -ve amount

The amounts in above entry should not be -ve.

This is a similar issue solved by <Patch 7426186> (ozfvglib.pls
120.15.12000000.8) See Support <Note 745040.1>

checked the prefious fix for the same customer present
in ozfvglib.pls 120.15.12000000.14 and this is the code that manage the fix :

IF (upper(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL' AND
p_gl_rec.event_type_code = 'SETTLE_BY_OTHER'
+ AND p_gl_rec.adjustment_type = 'N') THEN+
+ x_ae_line_tbl(i).entered_dr := (l_amount_tbl(i).entered_dr)*-1;+
+ x_ae_line_tbl(i).entered_cr := (l_amount_tbl(i).entered_cr)*-1;+
+ x_ae_line_tbl(i).accounted_dr := (l_amount_tbl(i).accounted_dr)*-1;+
+ x_ae_line_tbl(i).accounted_cr := (l_amount_tbl(i).accounted_cr)*-1;+
+ x_ae_line_tbl(i).entered_dr := l_amount_tbl(i).entered_dr;+
+ x_ae_line_tbl(i).entered_cr := l_amount_tbl(i).entered_cr;+
+ x_ae_line_tbl(i).accounted_dr := l_amount_tbl(i).accounted_dr;+
+ x_ae_line_tbl(i).accounted_cr := l_amount_tbl(i).accounted_cr;+
+ END IF;+

Discussing with DEV the condition to negate the amounts has the
following clause:

IF (upper(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL'
AND p_gl_rec.event_type_code = 'SETTLE_BY_OTHER'
AND p_gl_rec.adjustment_type = 'N') THEN

will be executed only when the custom settlement method is used.
Whereas in below case the settlement Method used is 'AP Debit.

So this is skip for this case.

This issue was found testing 1-off for patch 7491702.R12.OZF.A but
this is not related to this issue.

As per DEV update reverted all the files for patch 7491702 on dev instance:

ozfacreb.pls 120.36.12000000.15
ozfactgb.pls 120.0.12000000.2
ozfactgs.pls 120.0
ozfvglib.pls 120.15.12000000.13

i.e. all versions are one less than that in patch 7491702.R12.OZF.A. Then did
the testcase. We still get the following:
Dr Ven_clearing -ve amount.
Cr Accrual_liability -ve amount.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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