Credit Memos from Order Management Are Generating With Zero Dollar Tax Rows and Incorrect Event_id

(Doc ID 2384206.1)

Last updated on APRIL 10, 2018

Applies to:

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

Symptoms

On : 12.1.3 version, Posting/Reconciliation Data

Credit Memos from Order Management generate with corrupt TAX lines in ra_cust_trx_line_gl_dist_all table. 

a) percent, amount and acctd_amount generate as 0

b) event_id for the TAX rows <> REC event_id

NOTE: The associated TAX rows in ra_customer_trx_lines_all generate correctly as well as rows in ar_receivable_applications_all and ar_payment_schedules_all tables.


Example:

 

RA_CUSTOMER_TRX_LINES_ALL
CUSTOMER_TRX_LINE_ID LINE_TYPE EXTENDED_AMOUNT AUTOTAX
1 REV 100  
2 TAX 7 N

 

 

RA_CUST_TRX_LINE_GL_DIST_ALL
CUST_TRX_LINE_GL_DIST_ID CUSTOMER_TRX_LINE_ID PERCENT AMOUNT ACCTD_AMOUNT ACCOUNT_CLASS ACCOUNT_SET_FLAG EVENT_ID
10   100 107 107 REC N 1123
11 1 100 100 100 REV N 1123
12 2 0 0 0 TAX N 1122

Changes

 

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