Autoinovoice Does not Populate sales_order_source Correctly for Credit Memos (Doc ID 1069948.1)

Last updated on JUNE 20, 2016

Applies to:

Oracle Receivables - Version 11.5.10.0 to 12 [Release 11.5.10 to 12.0]
Information in this document applies to any platform.
Executable:RAXTRX - Autoinvoice Import Program


Symptoms

Autoinovoice import doesn't populate sales_order_sources correctly for credit memos.

The original transaction is transferred in Receivables through Autoinvoice having all lines with column SALES_ORDER_SOURCE populated as they were in Interface tables.

When the Credit Memo is imported through Autoinvoice for the above transaction, some lines have column SALES_ORDER_SOURCE populated differently than the original transaction and different than the way Interface was populated for this Credit Memo.

Example:

We have trx details in the interface table as follows

INTERFACE_LINE_ATTRIBUTE1 INTERFACE_LINE_ATTRIBUTE2 AMOUNT SALES_ORDER_SOURCE
------------------------- ------------------------- ------ ------------------
091007025603_R_N          1                      748,8 100000300
091007025603_R_N          2                        -680 100000542
091007025603_R_N          3                      -1192 1105
091007025603_R_N          4                              0 100000542

After running auto invoice, Please note that sales_order_source column has not been populated correctly:


INTERFACE_LINE_ATTR1 INTERFACE_LINE_ATTR2 EXTENDED_AMOUNT SALES_ORDER_SOURCE
-------------------- -------------------- --------------- ------------------
091007025603_R_N                 1   748,8 100000300
091007025603_R_N                 2     -680 1105 <=====
091007025603_R_N                 3   -1192 100000542 <=====
091007025603_R_N                 4           0 100000542

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