Error in Calling Api csi_t_txn_details_grp.create_transaction_dtls for the Orders With More Than One Line

(Doc ID 2328756.1)

Last updated on NOVEMBER 15, 2017

Applies to:

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

Goal

1. Getting the following error in calling csi_t_txn_details_grp.create_transaction_dtls with orders with2 lines. First line work well and second line throws the following error
The item (ID: XXX) on the source (ID: YYY of OE_ORDER_LINES_ALL) and the item (ID: ZZZ) on the transaction line detail does not match.


2. Does the sequence need to be generated to pass the line id or below initialization is good.

We are using the commands below to get the values for transaction_line_id and TXN_line_detail_id.
  l_line_dtl_tbl(v_line_cnt).transaction_line_id := fnd_api.g_miss_num;
  l_line_dtl_tbl(v_line_cnt).txn_line_detail_id := fnd_api.g_miss_num;

Need to know which sequences to use to get the below fields while create IB transaction for an item.
transaction_line_id
txn_line_detail_id
txn_party_detail_id
txn_account_detail_id
ip_account_id
 

Solution

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