Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am loading the inventory history transaction table from IFS (PL/SQL) using the following script:
select
transaction_code,
date_created,
cost
from IFSAPP.INVENTORY_TRANSACTION_HIST_TAB;
this loads the whole table which is massive so I have been trying to restrict it to one year:
select
transaction_code,
date_created,
cost
from IFSAPP.INVENTORY_TRANSACTION_HIST_TAB
where TO_CHAR(DATE_CREATED,'YYYY') = '2018';
this works except the cost field shows only null values.
Has anyone else encountered this problem?
If you pull the data for a different year is it populated? Is so, maybe the cost field has not been populated yet for 2018.
What's the o/p in sql developer? Are you getting values?
select
transaction_code,
date_created,
cost
from IFSAPP.INVENTORY_TRANSACTION_HIST_TAB
where TO_CHAR(DATE_CREATED,'YYYY') = '2018';
May be try this
SELECT
transaction_code,
date_created,
cost,
TO_CHAR(DATE_CREATED,'YYYY') year
from IFSAPP.INVENTORY_TRANSACTION_HIST_TAB;
Do you see year 2018 and in those rows does cost have any value?