SET SERVEROUTPUT ON DECLARE TYPE t_bulk_collect_test_tab IS TABLE OF bulk_collect_test%ROWTYPE; l_tab t_bulk_collect_test_tab; CURSOR c_data IS SELECT * FROM bulk_collect_test; l_start NUMBER; BEGIN — Time a regular cursor for loop. l_start…
Read MoreHow to Expose Custom PL/SQL API as a REST Webservice? Oracle E-Business Suite Integrated SOA Gateway (ISG) provides an infrastructure to deploy, consume, and administer Oracle E-Business Suite web services.…
Read MorePROCEDURE load_purchase_quotation as lv_currency_code fnd_currencies_vl.currency_code%type; lv_verify_flag varchar2 (1); lv_error_message varchar2 (5000); ln_vendor_id po_vendors.vendor_id%type; ln_vendor_site_id po_vendor_sites_all.vendor_site_id%type; ln_ship_to_locn_id hr_locations.location_id%type; ln_bill_to_locn_id hr_locations.location_id%type; ln_inventory_item_id mtl_system_items_b.inventory_item_id%type; lv_legacy_quotenum varchar2 (30); ln_batch_id number (3); ln_term_id number; lv_freight_code…
Read MoreSmart Flash in Oracle Exadata In the realm of data management and high-performance computing, Oracle Exadata has established itself as a powerhouse, delivering exceptional capabilities for both online transaction processing…
Read MoreSmart Scans in Oracle Exadata In the ever-evolving landscape of data management and analytics, businesses are continually searching for ways to extract more value from their data while optimizing performance…
Read Moreoverstating-the-po-value-and-needs-to-be-removed-_issue1
Read MoreUse the okc_price_adjustment_pub.create_price_adjustment API with appropriate input values to effect the adjusted prices manually.
Read MoreUse the oks_auth_util_pvt.check_update_amounts API to refresh the header amount after the line level modifications.
Read MoreParameter p_billing_sch needs to be passed as E instead of T to the API Create_Bill_Schedule API.
Read More