CALIDUS Portal TTM Interface

The setup of the interface has been documented for customers here: ctms:CALIDUS Portal TTM Interface.

The Job must be enabled

Select * from DBA_JOBS
where UPPER(what) like '%LOTS%'

	BEGIN
	INT_XML_OUT2.PROCESS_XML_OUTBOUND_LOTS_ORD;

	INT_XML_OUT2.PROCESS_XML_OUTBOUND_LOTS;
	END;

Possible issues

-- Jobs not running? Check the following:
select logins from v$instance; -- if not allowed, won't run jobs
select value from dba_scheduler_global_attribute where attribute_name='SCHEDULER_DISABLED' -- if TRUE won't run jobs
select value from v$parameter where name='job_queue_processes'; -- if 0 won't run jobs (most common
alter system set job_queue_processes=20; -- Fix to above issue

Messages are written to INT_XML_CONTROL, type LOTS, processed "N" or "P".

Any issues with FTP to the box will be logged to ADM_LOG

select * from adm_log
where prog_name like '%INT_XML%'
and err_type = 'ERROR'
-- ORI_USER = 'MTS_OWNER'
order by stmt desc