EP_LOAD_ITEMS erros -1722 ORA-01722: invalid number Error in PROCEDURE EP_LOAD_ITEMS line 0
We are seeing error while running the EBS_FULL DOWNLOAD at the EP_LOAD_ITEMS stage.
The error '
"-1722 ORA-01722: invalid number Error in PROCEDURE EP_LOAD_ITEMS line 0
dynamic_ddl( 'CREATE SEQUENCE T_EP_SITE_SEQ START WITH ') "
There is a support note pointing it Sales Hook - pointing to MSC_sales_channel
Also I an seeing the record in t_ep_ebs_sales_ch with IS_FICTIVE =3 .. In a working is=nstance this is seen as IS_FICTIVE=2
We are able to load data using legacy laoding functionliaty.
Urgently seeking some pointers