AR_S_00056 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 JULY 18, 2024
Applies to:
Oracle Receivables - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
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:
| CUSTOMER_TRX_LINE_ID | LINE_TYPE | EXTENDED_AMOUNT | AUTOTAX |
| 1 | LINE | 100 | |
| 2 | TAX | 7 | N |
| 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-20XX | 107 | REC | N | 1122 | |
| 11 | 1 | 100 | 100 | 02-APR-20XX | 100 | REV | N | 1122 |
| 12 | 2 | 0 | 0 | 01-APR-20XX | 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 |