Total Pageviews

Showing posts with label EBS : API : INV. Show all posts
Showing posts with label EBS : API : INV. Show all posts

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

                                                              );

 

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...