Hi Expert,
I have one interactive grid report where few of the columns i am fetching from table and few of them are just deriving of the table column.let say if i am getting some records like 'Test_1' from table and from that i am separating 'Test 'and '1' and displaying in the same report in two different custom column.
To store this records i have written pl sql code but when i try to insert the record records are not getting stored.
It gives a message of all the custom columns are not exits.
Report query:
SELECT
table_name,
Column_id,
column_name,
data_type,
replace(initcap(column_name), '_', ' ') display_name,
replace(initcap(column_name), '_', ' ') Description,
'Y' Required,
''Validation,
''Transformation,
''Flex_Field,
CASE
WHEN column_name IN (
'STG_ID',
'SOURCESYSTEMOWNER',
'SOURCESYSTEMID'
) then ROWNUM * 0
ELSE ROWNUM * 5
end position
FROM
user_tab_columns
WHERE
table_name =:P46_TABLENAME
Apex Version: 20.2