Account alias receiving transaction processing, account alias Transaction Processing

Account alias receiving transaction processing, account alias Transaction Processing
Zookeeper

-- Account alias reception
SELECT mtl_material_transactions_s.nextval
INTO l_mtl_txn_itf_rec.transaction_interface_id
FROM dual;
L_mtl_txn_itf_rec.transaction_header_id: = l_mtl_txn_itf_rec.transaction_interface_id;
L_mtl_txn_itf_rec.transaction_mode: = 3;
L_mtl_txn_itf_rec.process_flag: = 1;
L_mtl_txn_itf_rec.transaction_type_id: = 41;
L_mtl_txn_itf_rec.transaction_source_id: = I. disposition_id;
L_mtl_txn_itf_rec.organization_id: = I. organization_id;
L_mtl_txn_itf_rec.inventory_item_id: = I. n_inventory_item_id; -- l_mtl_txn_int_rec.inventory_item_id;
L_mtl_txn_itf_rec.subinventory_code: = I. n_subinventory_code; -- l_mtl_txn_int_rec.subinventory_code;
L_mtl_txn_itf_rec.locator_id: = I. n_locator_id; -- l_mtl_txn_int_rec.locator_id;
L_mtl_txn_itf_rec.transaction_quantity: = I. n_onhand_quantity; -- l_mtl_txn_int_rec.transaction_quantity;
L_mtl_txn_itf_rec.transaction_uom: = I. uom_code; -- l_mtl_txn_int_rec.uom_code;
L_mtl_txn_itf_rec.transaction_date: = nvl (I. transaction_date, SYSDATE); -- l_mtl_txn_int_rec.onhand_creation_date/* g_date */

/* L_mtl_txn_itf_rec.source_header_id: = null; -- l_mtl_txn_itf_rec.transaction_header_id;
L_mtl_txn_itf_rec.source_line_id: = null; -- l_mtl_txn_itf_rec.transaction_header_id;
L_mtl_txn_itf_rec.source_code: = null; -- 'cux _ wms_mtl_txn_in ';*/

-- Who Column
L_mtl_txn_itf_rec.last_update_date: = SYSDATE;
L_mtl_txn_itf_rec.last_updated_by: = g_user_id;
L_mtl_txn_itf_rec.creation_date: = SYSDATE;
L_mtl_txn_itf_rec.created_by: = g_user_id;
L_mtl_txn_itf_rec.last_update_login: = g_login_id;

L_mtl_txn_itf_rec.source_code: = p_source_code;
L_mtl_txn_itf_rec.source_header_id: = p_source_line_id;
L_mtl_txn_itf_rec.source_line_id: = p_source_line_id;
Insert into mtl_transactions_interface VALUES l_mtl_txn_itf_rec;

-- Batch
L_mtl_txn_lot_rec.transaction_interface_id: = l_mtl_txn_itf_rec.transaction_header_id;
L_mtl_txn_lot_rec.lot_number: = I. n_lot_number;
L_mtl_txn_lot_rec.transaction_quantity: = I. n_onhand_quantity;
L_mtl_txn_lot_rec.last_update_date: = SYSDATE;
L_mtl_txn_lot_rec.last_updated_by: = g_user_id;
L_mtl_txn_lot_rec.creation_date: = SYSDATE;
L_mtl_txn_lot_rec.created_by: = g_user_id;
L_mtl_txn_lot_rec.last_update_login: = g_login_id;
Insert into mtl_transaction_lots_interface VALUES l_mtl_txn_lot_rec;

-- Account alias receiving Transaction Processing
X_retval: = inv_txn_manager_pub.process_transactions (p_api_version => 1,
P_init_msg_list => fnd_api.g_true,
P_commit => fnd_api.g_false, -- not commit
P_validation_level => fnd_api.g_valid_level_full,
X_return_status => l_return_status,
X_msg_count => l_msg_count,
X_msg_data => l_msg_data,
X_trans_count => x_trans_count,
P_table => 1,
P_header_id => l_mtl_txn_itf_rec.transaction_interface_id );

IF x_retval <> 0 THEN
SELECT mti. error_explanation
INTO l_error_explanation
FROM mtl_transactions_interface mti
WHERE 1 = 1
AND mti. transaction_interface_id =
L_mtl_txn_itf_rec.transaction_interface_id
AND rownum = 1;
X_msg_data: = 'error in inv_txn_manager_pub.process_transactions: '|
'Transaction header id: '|
L_mtl_txn_itf_rec.transaction_interface_id | '. Receiving failed.' |
Rochelle _ explanation;
RAISE transaction_error;
End if;

What is the relationship between account combinations and aliases?

The account combination is an intuitive expression of the COA structure, and the account alias is another name for this account combination for identification. For example, you need to specify an account combination to process miscellaneous transactions that are input into the inventory. However, it is difficult for the database administrator to understand the accounting account structure, in this case, it is easier to select an account alias (for example, name it inventory shortage). At this time, an account combination is used to generate entries behind this account alias.

How to set the postal account alias

Hello, if you are referring to the personal online banking account alias settings, you can log on to the online banking, click Security Center-account settings-account alias to modify the account alias; the account alias is set when you append an online banking account.