My Oracle Support Banner

Transactions and Credit Memos from Order Management Are Generating With Zero Dollar Tax Rows and Incorrect Event_id (Doc ID 2384206.1)

Last updated on OCTOBER 17, 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

Transactions and Credit Memos from Order Management generate with corrupt INDIA GST TAX lines in ra_cust_trx_line_gl_dist_all table. 

a) percent, amount and acctd_amount generate as 0

b) gl_date and 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 LINE 100  
2 TAX 7 N

 

 

RA_CUST_TRX_LINE_GL_DIST_ALL
CUST_TRX_LINE_GL_DIST_ID CUSTOMER_TRX_LINE_ID PERCENT AMOUNT GL_DATE ACCTD_AMOUNT ACCOUNT_CLASS ACCOUNT_SET_FLAG EVENT_ID
10   100 107 02-APR-2018 107 REC N 1122
11 1 100 100 02-APR-2018 100 REV N 1122
12 2 0 0 01-APR-2018 0 TAX N 1123

Cause

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
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


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