Receivables - EBS (MOSC)

MOSC Banner

TCA API to create customer with error

edited Dec 2, 2013 8:05PM in Receivables - EBS (MOSC) 14 commentsAnswered
Hi there,

I need help, I have created the script to use the hz_cust_accout_v2pub.create_cust_account to create customer, and I am facing the error

'Column party number must have a value' after executing the script.  Please advise me.  Thanks.

this is the script I created to test,

set serveroutput on size 1000000

declare
  l_user_id        number         :=0;
  l_resp_id        number         :=0;
  l_application_id number         :=0;
  l_err_msg        varchar2(500)  :=null;
  l_log            varchar2(2000) :=null;
  l_output_rec     varchar2(2000) :=null;
  l_process       varchar2(100) :=null;
  l_statement      varchar2(100) :=null;
  l_error_flag     boolean;
  l_total_rec      number:=0;

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