Home » Applications » Oracle Fusion Apps & E-Business Suite » Error When create new emplyee
Error When create new emplyee [message #564582] Sun, 26 August 2012 03:38 Go to next message
malalwadi
Messages: 9
Registered: May 2012
Location: suadi
Junior Member
Dear all

when i used api to create new employee, i founded this error : ORA-20001: HR_FLEX_VALUE_MISSING: N, COLUMN, ATTRIBUTE18, N, PROMPT, Department>


Declare
 p_validate                           boolean  
;p_hire_date                          date
;p_business_group_id                  number
;p_last_name                          varchar2(2000)
;p_sex                                varchar2(2000)
;p_person_type_id                     number   
;p_per_comments                       varchar2(2000) 
;p_date_employee_data_verified        date     
;p_date_of_birth                      date     
;p_email_address                      varchar2(2000) 

;p_employee_number                varchar2(2000)

;p_expense_check_send_to_addres       varchar2(2000) 
;p_first_name                         varchar2(2000) 
;p_known_as                           varchar2(2000) 
;p_marital_status                     varchar2(2000) 
;p_middle_names                       varchar2(2000) 
;p_nationality                        varchar2(2000) 
;p_national_identifier                varchar2(2000) 
;p_previous_last_name                 varchar2(2000) 
;p_registered_disabled_flag           varchar2(2000) 
;p_title                              varchar2(2000) 
;p_vendor_id                          number   
;p_work_telephone                     varchar2(2000) 
;p_attribute_category                 varchar2(2000) 
;p_attribute1                         varchar2(2000) 
;p_attribute2                         varchar2(2000) 
;p_attribute3                         varchar2(2000) 
;p_attribute4                         varchar2(2000) 
;p_attribute5                         varchar2(2000) 
;p_attribute6                         varchar2(2000) 
;p_attribute7                         varchar2(2000) 
;p_attribute8                         varchar2(2000) 
;p_attribute9                         varchar2(2000) 
;p_attribute10                        varchar2(2000) 
;p_attribute11                        varchar2(2000) 
;p_attribute12                        varchar2(2000) 
;p_attribute13                        varchar2(2000) 
;p_attribute14                        varchar2(2000) 
;p_attribute15                        varchar2(2000) 
;p_attribute16                        varchar2(2000) 
;p_attribute17                        varchar2(2000) 
;p_attribute18                        varchar2(2000) 
;p_attribute19                        varchar2(2000) 
;p_attribute20                        varchar2(2000) 
;p_attribute21                        varchar2(2000) 
;p_attribute22                        varchar2(2000) 
;p_attribute23                        varchar2(2000) 
;p_attribute24                        varchar2(2000) 
;p_attribute25                        varchar2(2000) 
;p_attribute26                        varchar2(2000) 
;p_attribute27                        varchar2(2000) 
;p_attribute28                        varchar2(2000) 
;p_attribute29                        varchar2(2000) 
;p_attribute30                        varchar2(2000) 
;p_per_information_category           varchar2(2000) 
;p_per_information1                   varchar2(2000) 
;p_per_information2                   varchar2(2000) 
;p_per_information3                   varchar2(2000) 
;p_per_information4                   varchar2(2000) 
;p_per_information5                   varchar2(2000) 
;p_per_information6                   varchar2(2000) 
;p_per_information7                   varchar2(2000) 
;p_per_information8                   varchar2(2000) 
;p_per_information9                   varchar2(2000) 
;p_per_information10                  varchar2(2000) 
;p_per_information11                  varchar2(2000) 
;p_per_information12                  varchar2(2000) 
;p_per_information13                  varchar2(2000) 
;p_per_information14                  varchar2(2000) 
;p_per_information15                  varchar2(2000) 
;p_per_information16                  varchar2(2000) 
;p_per_information17                  varchar2(2000) 
;p_per_information18                  varchar2(2000) 
;p_per_information19                  varchar2(2000) 
;p_per_information20                  varchar2(2000) 
;p_per_information21                  varchar2(2000) 
;p_per_information22                  varchar2(2000) 
;p_per_information23                  varchar2(2000) 
;p_per_information24                  varchar2(2000) 
;p_per_information25                  varchar2(2000) 
;p_per_information26                  varchar2(2000) 
;p_per_information27                  varchar2(2000) 
;p_per_information28                  varchar2(2000) 
;p_per_information29                  varchar2(2000) 
;p_per_information30                  varchar2(2000) 
;p_date_of_death                      date     
;p_background_check_status            varchar2(2000) 
;p_background_date_check              date     
;p_blood_type                         varchar2(2000) 
;p_correspondence_language            varchar2(2000) 
;p_fast_path_employee                 varchar2(2000) 
;p_fte_capacity                       number   
;p_honors                             varchar2(2000) 
;p_internal_location                  varchar2(2000) 
;p_last_medical_test_by               varchar2(2000) 
;p_last_medical_test_date             date     
;p_mailstop                           varchar2(2000) 
;p_office_number                      varchar2(2000) 
;p_on_military_service                varchar2(2000) 
;p_pre_name_adjunct                   varchar2(2000) 
;p_rehire_recommendation             varchar2(2000) 
;p_projected_start_date               date     
;p_resume_exists                      varchar2(2000) 
;p_resume_last_updated                date     
;p_second_passport_exists             varchar2(2000) 
;p_student_status                     varchar2(2000) 
;p_work_schedule                      varchar2(2000) 
;p_suffix                             varchar2(2000) 
;p_benefit_group_id                   number   
;p_receipt_of_death_cert_date         date     
;p_coord_ben_med_pln_no               varchar2(2000) 
;p_coord_ben_no_cvg_flag              varchar2(2000) 
;p_coord_ben_med_ext_er               varchar2(2000) 
;p_coord_ben_med_pl_name              varchar2(2000) 
;p_coord_ben_med_insr_crr_name        varchar2(2000) 
;p_coord_ben_med_insr_crr_ident       varchar2(2000) 
;p_coord_ben_med_cvg_strt_dt          date 
;p_coord_ben_med_cvg_end_dt           date 
;p_uses_tobacco_flag                  varchar2(2000) 
;p_dpdnt_adoption_date                date     
;p_dpdnt_vlntry_svce_flag             varchar2(2000) 
;p_original_date_of_hire              date     
;p_adjusted_svc_date                  date     
;p_town_of_birth                      varchar2(2000) 
;p_region_of_birth                    varchar2(2000) 
;p_country_of_birth                   varchar2(2000) 
;p_global_person_id                   varchar2(2000) 
;p_party_id                           number 
--********************************Output****************************
;p_person_id                         number
;p_assignment_id                     number
;p_per_object_version_number         number
;p_asg_object_version_number         number
;p_per_effective_start_date          date
;p_per_effective_end_date            date
;p_full_name                          varchar2(2000)
;p_per_comment_id                    number
;p_assignment_sequence               number
;p_assignment_number                 varchar2(2000)
;p_name_combination_warning          boolean  
;p_assign_payroll_warning            boolean  
;p_orig_hire_warning                 boolean ;
Begin
Hr_Employee_Api.Create_Employee(

  p_hire_date                     =>Sysdate
  ,p_business_group_id             =>5148
  ,p_last_name                     =>'malik'
  ,p_sex                           =>'M'
   ,p_person_type_id               =>3045
   ,p_date_of_birth                =>'01-Jan-1980'
   ,p_employee_number                =>p_employee_number
   ,p_person_id                       =>       p_person_id                                       
  , p_assignment_id                     =>     p_assignment_id                            
,  p_per_object_version_number       =>    p_per_object_version_number 
   ,p_asg_object_version_number       =>       p_asg_object_version_number    
   ,p_per_effective_start_date        =>       p_per_effective_start_date     
   ,p_per_effective_end_date           =>      p_per_effective_end_date       
   ,p_full_name                        =>      p_full_name                                
   ,p_per_comment_id                   =>      p_per_comment_id                       
   ,p_assignment_sequence               =>     p_assignment_sequence                 
   ,p_assignment_number                  =>    p_assignment_number                   
   ,p_name_combination_warning          =>     p_name_combination_warning      
   ,p_assign_payroll_warning            =>     p_assign_payroll_warning        
   ,p_orig_hire_warning               =>      p_orig_hire_warning    );
   
   commit;        
   end;             
   
Re: Error When create new emplyee [message #564961 is a reply to message #564582] Wed, 29 August 2012 14:18 Go to previous message
Littlefoot
Messages: 19892
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd say that you didn't supply all arguments CREATE_EMPLOYEE expected. However, I might be *very* wrong.
Previous Topic: ORA-01403 FRM-40735: PRE-FORM in custom form
Next Topic: GL_IMPORT_REFERENCES and XLA_AE_LINES
Goto Forum:
  


Current Time: Sun Dec 21 21:13:02 CST 2014

Total time taken to generate the page: 0.15886 seconds