Forum Stats

  • 3,752,068 Users
  • 2,250,454 Discussions
  • 7,867,707 Comments

Discussions

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

3570359
3570359 Member Posts: 10
edited Oct 2, 2019 4:35AM in Machine Learning

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

Answers

  • 3570359
    3570359 Member Posts: 10
    edited Oct 2, 2019 4:35AM

    I have problem where customer enter text what they want to order and customer service based on text determine what item to order.

    I want to extract the text based on similiar text determine the product using machine learning.

    is it possible?