Process Manufacturing - EBS (MOSC)

MOSC Banner

Custom Table

edited Nov 4, 2020 2:22PM in Process Manufacturing - EBS (MOSC) 1 commentAnswered

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');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center