GitHub user sivaguru-rajasekaran added a comment to the discussion: Oracle
Table Input with variables (${LAST_RUN_TS}, ${LAST_RUN_ID}) failing in Apache
Hop
Table Create Table
xxsify_cpq_order_details_udm CREATE TABLE
`xxsify_cpq_order_details_udm` (
`SCQH_ID` bigint NOT NULL,
`BATCH_ID` bigint DEFAULT NULL,
`INVENTORY_ITEM_ID` bigint DEFAULT NULL,
`ITEM` varchar(240) DEFAULT NULL,
`ITEM_DESCRIPTION` varchar(240) DEFAULT NULL,
`QUANTITY` decimal(18,6) DEFAULT NULL,
`LIST_PRICE` decimal(18,6) DEFAULT NULL,
`DISCOUNT` decimal(18,6) DEFAULT NULL,
`NET_PRICE` decimal(18,6) DEFAULT NULL,
`NET_AMOUNT` decimal(18,6) DEFAULT NULL,
`ITEM_TYPE` varchar(250) DEFAULT NULL,
`ORDER_TYPE` varchar(240) DEFAULT NULL,
`ORDER_TYPE_ID` bigint DEFAULT NULL,
`LINE_TYPE` varchar(240) DEFAULT NULL,
`LINE_TYPE_ID` bigint DEFAULT NULL,
`CONTRACT_PERIOD` varchar(240) DEFAULT NULL,
`BU` varchar(100) DEFAULT NULL,
`BUSINESS_LINE` varchar(240) DEFAULT NULL,
`ORDER_NUMBER` bigint DEFAULT NULL,
`LINE_ID` bigint DEFAULT NULL,
`STATUS` char(1) DEFAULT NULL,
`ORDER_CREATION_DATE` datetime DEFAULT NULL,
`CREATION_DATE` datetime NOT NULL,
`CREATED_BY` varchar(240) NOT NULL,
`LAST_UPDATE_DATE` datetime NOT NULL,
`LAST_UPDATED_BY` bigint DEFAULT NULL,
`LAST_UPDATE_LOGIN` bigint DEFAULT NULL,
`BILL_GST_NO` varchar(100) DEFAULT NULL,
`SHIP_GST_NO` varchar(100) DEFAULT NULL,
`ORG_ID` bigint DEFAULT NULL,
`SCOD_ID` bigint DEFAULT NULL,
`SXOD_ID` bigint DEFAULT NULL,
`ADDRESS_REF_ID` varchar(30) DEFAULT NULL,
`GST_NO` varchar(30) DEFAULT NULL,
`CREATED_ON` timestamp(6) NULL DEFAULT NULL,
`ID` bigint NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`ID`),
UNIQUE KEY `uk_xxsify_id` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=700013 DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci
GitHub link:
https://github.com/apache/hop/discussions/6250#discussioncomment-15324804
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
