Payables and Cash Management - EBS (MOSC)

MOSC Banner

givs an error Ll_Msg_Data - UPDATE_VENDOR_SITE ORA-01403: no data found in Package AP_VENDOR_PUB_PKG

when run this api script

SET SERVEROUTPUT ON

DECLARE
lc_return_status VARCHAR2(2000);
ln_msg_count NUMBER;
ll_msg_data LONG;
Ln_Vendor_Id NUMBER;
Ln_Vendor_site_Id NUMBER;
ln_message_int NUMBER;
Ln_Party_Id NUMBER;
lrec_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
BEGIN
Ln_Vendor_Id := 38228;
Ln_Vendor_site_Id := 2620669;
Lrec_Vendor_site_Rec.vendor_id := 38228;
Lrec_Vendor_site_Rec.vendor_site_id := 2620669;
--Lrec_Vendor_site_Rec.org_id := 204;
--Lrec_Vendor_site_Rec.address_line1 := 'PO Box 00000';
--Lrec_Vendor_site_Rec.address_line2 := 'Building #0';
--Lrec_Vendor_site_Rec.address_line3 := 'Warehouse XXX';

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center