Send an email (with attachement) using Oracle PLSQL
Send an email (with attachement) using Oracle PL/SQL create or replace procedure SEND_EMAIL_WITH_TXT_ATTACH ( PVA_SENDER varchar2, PVA_RECEIVER varchar2, PVA_SUBJECT varchar2, PVA_MESSAGE [...]
Checking The performance & Advantage of using BULK COLLECT
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; [...]
How to Expose Custom PL/SQL API as a REST Webservice?
How 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 [...]
Procedure to Upload Purchase Quotations
PROCEDURE 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; [...]
Smart Flash in Oracle Exadata
Smart 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 [...]
Smart Scans in Oracle Exadata
Smart 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 [...]
overstating the PO value and needs to be removed _Issue1
overstating-the-po-value-and-needs-to-be-removed-_issue1
Service Contract line price Adjustment Issue while modified the prices user manually.
Use the okc_price_adjustment_pub.create_price_adjustment API with appropriate input values to effect the adjusted prices manually.
Service Contract Header amount total field is not affected while user manually update the price or quantity in line level.
Use the oks_auth_util_pvt.check_update_amounts API to refresh the header amount after the line level modifications.
