Context

Load the item lifecycle calendar into AIF Apps for IPO Implementation. The file goes in through Upload input files to AIF Apps; RSE_MASTER_ADHOC_PROCESS then loads it with a long-form option rather than a one-letter flag.

Steps

  1. Generate rse_life_cycle_calendar_stg.txt and zip it as ORASE_WEEKLY_ADHOC.zip.
  2. Upload the zip to ris/incoming and run INPUT_FILES_ADHOC_PROCESS (AIF APPS > Standalone) — see Upload input files to AIF Apps.
  3. POM > AIF APPS > Standalone > RSE_MASTER_ADHOC_PROCESS > job RSE_MASTER_ADHOC_JOB: set the parameter to --life_cycle_cal. Navigation in How to run a POM standalone job.
  4. Run RSE_MASTER_ADHOC_PROCESS.
  5. Validate:
select * from rse_life_cycle_calendar;
select * from rse_life_cycle_calendar_dtl;
select * from rse_life_cycle_calendar_bad;

rse_life_cycle_calendar_bad holds the rejected rows — it should be empty. Fix the source file and reload if it is not.


Reference