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