Tracking the FIRST creation date of a Purchase requisition line

Hi @LundahlOskar ,

You can use history logging for this requirement. You can enable the history logging for the Created Date field in purchase requisition screen.

Then, you can track the original date (old value) and how it has  changed in each MRP run by viewing history logging for that field.

Thanks,

History logging happens inside the database, as an Oracle trigger. If you set up history logging for a logical unit inside IFS Enterprise Explorer, that setting will carry over to IFS Aurena.

It’s my understanding the IALs and Quick Reports have been deprecated, but without replacements available in Apps 10, you’ll have to balance today’s business pain with tomorrow’s upgrade pain.

Do you have Oracle access? Maybe you could query this off-system.

Something like this would work in Apps 9. I haven’t tested it in Apps 10. (I didn’t run this to test it.)

CONNECT ifsapp

GRANT SELECT ON ifsapp.history_log_tab           TO ifsinfo WITH GRANT OPTION;
GRANT SELECT ON ifsapp.history_log_attribute_tab TO ifsinfo WITH GRANT OPTION;

CONNECT ifsinfo

EXEC ifsapp.ial_object_api.disable('C_HISTORY_LOG');

CREATE OR REPLACE VIEW ifsinfo.c_history_log_ial AS
SELECT *
  FROM ifsapp.history_log_tab
  WITH READ ONLY;

GRANT SELECT ON ifsinfo.c_history_log_ial TO ifsapp WITH GRANT OPTION;

EXEC ifsapp.ial_object_api.enable('C_HISTORY_LOG');
EXEC ifsapp.ial_object_api.add_description('C_HISTORY_LOG', 'Passthrough for HISTORY_LOG_TAB');

EXEC ifsapp.ial_object_api.disable('C_HISTORY_LOG_ATTRIBUTE');

CREATE OR REPLACE VIEW ifsinfo.c_history_log_attribute_ial AS
SELECT *
  FROM ifsapp.history_log_attribute_tab
  WITH READ ONLY;

GRANT SELECT ON ifsinfo.c_history_log_attribute_ial TO ifsapp WITH GRANT OPTION;

EXEC ifsapp.ial_object_api.enable('C_HISTORY_LOG_ATTRIBUTE');
EXEC ifsapp.ial_object_api.add_description('C_HISTORY_LOG_ATTRIBUTE', 'Passthrough for HISTORY_LOG_ATTRIBUTE_TAB');


/*
In a Quick Report:
SELECT *
  FROM ifsinfo.c_history_log l
  JOIN ifsinfo.c_history_log_attribute a
    ON a.log_id = l.log_id
 WHERE l.table_name = 'PURCHASE_REQUISITION_TAB'
   AND ...