Receivables - EBS (MOSC)

MOSC Banner

Hz_Cust_Account_Site_V2pub.update_cust_site_use - Error updating Primary SalesRep ID

edited Sep 10, 2013 8:35AM in Receivables - EBS (MOSC) 3 commentsAnswered
I get the following error when I use  the same object version number that is for the site_use_id:
API Message: 1.The following SQL error occurred: 
ORA-01403: no data found.
When I use object version number + 1 for the site_use_id, I get the error:
API Message: 1.The following SQL error occurred: 
ORA-01403: no data found.

I am on R12.1.3. Running this as a concurrent program.

Code is given below:
============
PROCEDURE update_salesrep(P_RETCODE    OUT NUMBER,
                       P_ERRBUFF    OUT VARCHAR2
                      ) AS

  
p_order_header_rec      OE_Order_PUB.Header_Val_Rec_Type;
v_cust_site_use_rec     Hz_Cust_Account_Site_V2pub.CUST_SITE_USE_REC_TYPE;

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