Skip to Main Content

Data Science & Machine Learning

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

40104. 00000 - "invalid training data for model build"

3570359Sep 30 2019 — edited Oct 2 2019

Hello.

I have created a view from standard oracle EBS table, and want to make a decision tree from following code but getting above error.

create or replace view xxmh_zdt_td1 as

select a.pay_from_customer,a.comments,a.status,a.creation_date,a.receipt_date,a.amount

from ar_cash_receipts_all a

where trunc(a.creation_date)<to_date('2018-12-30','RRRR-MM-DD')

and a.pay_from_customer is not null

;

INSERT INTO xxmh_zDTSETTINGS VALUES (dbms_data_mining.algo_name, dbms_data_mining.algo_decision_tree);

BEGIN

  -- Populate settings table

  INSERT INTO xxmh_zDTSETTINGS VALUES

    (dbms_data_mining.algo_name, dbms_data_mining.algo_decision_tree);

  COMMIT;

  DBMS_DATA_MINING.CREATE_MODEL(

           MODEL_NAME          => 'xxmh_zdt_tm1',  --myy

           MINING_FUNCTION     => dbms_data_mining.classification,  --

           DATA_TABLE_NAME     => 'XXMH_ZDT_TD1',  --

           CASE_ID_COLUMN_NAME => 'PAY_FROM_CUSTOMER',  --

           TARGET_COLUMN_NAME  => 'STATUS', --

           SETTINGS_TABLE_NAME => 'XXMH_ZDTSETTINGS');

end;

/

Is there anyway to find why this error is coming.

thanks,

7Z

Comments
Post Details
Added on Sep 30 2019
2 comments
402 views