Receivables - EBS (MOSC)

MOSC Banner

Update Customer site Use record gives error using hz_cust_account_site_v2pub.update_cust_site_use AP

edited Apr 25, 2011 12:43AM in Receivables - EBS (MOSC) 1 commentAnswered
Hi,

Please help me resolve this error.

Input data:

SQL> SELECT site_use_id, object_version_number
  2    FROM hz_cust_site_uses
  3   where site_use_id = 28982
  4  ;
 
     SITE_USE_ID OBJECT_VERSION_NUMBER
---------------- ---------------------
           28982                     1 The PL/SQL code is given below. DECLARE
      r_bill_cust_site_use             hz_cust_account_site_v2pub.cust_site_use_rec_type;
      vv_return_status                 VARCHAR2(2000);
      vn_msg_count                     NUMBER;
      vv_msg_data                      VARCHAR2(2000);
      vn_version                       NUMBER := 1;
        
BEGIN
      FND_GLOBAL.APPS_INITIALIZE (1922, 50767, 222);
      MO_GLOBAL.INIT ('AR');
      mo_global.set_policy_context ('S', 84);
     
      r_bill_cust_site_use.site_use_id := 28982;
      r_bill_cust_site_use.location := '0010';

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