Forum Stats

  • 3,759,961 Users
  • 2,251,621 Discussions
  • 7,870,889 Comments

Discussions

Aging - 7 Buckets - By Account Report

User_7SQ9I
User_7SQ9I Posts: 2 Employee

HI ,

When i adding extra buckets for Aging - 7 Buckets - By Account Report report

facing belwo problem


ORA-01789: query block has incorrect number of result columns
  ==> select rpad ( 'a' , 50 , '-' ) cust_name_inv , rpad ( 'a' , 30 , '-' ) cust_no_inv , rpad ( 'a' , 4000 , '-' ) sort_field1_inv , rpad ( 'a' , 4000 , '-' ) sort_field2_inv , 0 inv_tid_inv , 0 contact_site_id_inv , rpad ( 'a' , 60 , '-' ) cust_state_i
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error: 
REP-300: query block has incorrect number of result columns
  ==> select rpad ( 'a' , 50 , '-' ) cust_name_inv , rpad ( 'a' , 30 , '-' ) cust_no_inv , rpad ( 'a' , 4000 , '-' ) sort_field1_inv , rpad ( 'a' , 4000 , '-' ) sort_field2_inv , 0 inv_tid_inv , 0 contact_site_id_inv , rpad ( 'a' , 60 , '-' ) cust_state_i



Answers