Custom Table
Hi All,
Working in OPM Version 12.1.3
Created a custom table with below steps, and inserted a record, but when i query the form the message shows table does not exist and when i check in application database table, there is no table showing,
please i need some help
create table XX_ORDER_APPROVAL(p_order_number number, p_batch_no varchar2(32), p_reason varchar2(200))
EXEC AD_DD.REGISTER_TABLE ('XBOL','XX_ORDER_APPROVAL','T', 512, 10, 70);
EXEC AD_DD.REGISTER_COLUMN ('XBOL','XX_ORDER_APPROVAL','P_ORDER_NUMBER', 1,'NUMBER', 10,'Y','Y');
EXEC AD_DD.REGISTER_COLUMN ('XBOL','XX_ORDER_APPROVAL','P_BATCH_NO', 2,'VARCHAR2', 32,'Y','Y');