Total Pageviews

Wednesday, 7 June 2023

EBS : API to run Process Transaction in Oracle Apps : Oracle Apps

API to run Process Transaction in Oracle Apps

 This request will pick data from MTL Transaction Interface Table and insert into Standard Table. Below code is used to submit this request from backend.

v_out :=

                                 inv_txn_manager_pub.process_transactions

                                                              (p_api_version           => 1.0,

                                                               p_init_msg_list         => fnd_api.g_true,

                                                               p_commit                => fnd_api.g_true,

                                                               p_validation_level      => fnd_api.g_valid_level_full,

                                                               x_return_status         => v_return_status,

                                                               x_msg_count             => v_msg_count,

                                                               x_msg_data              => v_msg_data,

                                                               x_trans_count           => v_trans_count,

                                                               p_table                 => 1,

                                                               p_header_id             => r_txn_rec.transaction_header_id

                                                              );

 

No comments:

Post a Comment

FUSION: Purchasing Query

  1) ---------CPA to PO Amount---------- select poh.segment1, (select sum(nvl(cpol.quantity,1)* cpol.unit_price) from po_headers_all cpoh,po...