Retail Merchandising System (MOSC)

MOSC Banner

getting error when trying to download template file for Item induction RMS 14.1

edited Dec 9, 2016 6:03AM in Retail Merchandising System (MOSC) 1 commentAnswered

Hi All,

I am using 14.1 RMS version and when trying to download blank template or with data getting error "Error ORA - 01403: no data found returned by program unit ITEM_INDUCT_SQL.create_s9t".

I was looking into the package ITEM_INDUCT_SQL.create_s9t and got one calling package 's9t_pkg.update_ods(l_file)' having the below select query :

SELECT ODS_BLOB

  INTO l_tmpl_blob

  FROM s9t_folder

  WHERE file_name = 'ODS_SYSTEM_TEMPLATE_FOR_OUTPUT_FILES.ods';

During the process there was no row inserting into the table s9t_folder with file_name 'ODS_SYSTEM_TEMPLATE_FOR_OUTPUT_FILES.ods'.

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