Forms Configurator - Upload Template 12.2 Failing with Error HR_FORM_TEMPLATES "ORA-01403: no data found" (Doc ID 1991733.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Human Resources - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

In UAT
12.2.3
R12.HR_PF.C.delta.5 applied

When trying to upload a template that was downloaded from a 12.0.6 instance
get following error :
ERROR
----------------------------------
Upload from stage tables
 Error loading seed data for HR_FORM_TEMPLATES: APPLICATION_SHORT_NAME = PER, FORM_NAME = PERWSQHM, TEMPLATE_NAME = XXVAI_PER_ENTER_EMPS_FI_V4, TERRITORY_SHORT_NAME = FI, ORA-01403: no data found
 Error loading seed data for HR_TEMPLATE_WINDOWS: APPLICATION_SHORT_NAME = PER, FORM_NAME = PERWSQHM, TEMPLATE_NAME = XXVAI_PER_ENTER_EMPS_FI_V4, TERRITORY_SHORT_NAME = FI, APPLICATION_SHORT_NAME = PER, FORM_NAME = PERWSQHM, WINDOW_NAME = MAINTAIN_WINDOW, TEMPLATE_NAME = XXVAI_PER_ENTER_EMPS_FI_V4, TERRITORY_SHORT_NAME = FI, ORA-01403: no data found
 Error loading seed data for HR_TEMPLATE_CANVASES: APPLICATION_SHORT_NAME = PER, FORM_NAME = PERWSQHM, TEMPLATE_NAME = XXVAI_PER_ENTER_EMPS_FI_V4, TERRITORY_SHORT_NAME = FI, APPLICATION_SHORT_NAME = PER, FORM_NAME = PERWSQHM, WINDOW_NAME = MAINTAIN_WINDOW, TEMPLATE_NAME = XXVAI_PER_ENTER_EMPS_FI_V4, TERRITORY_SHORT_NAME = FI, APPLICATION_SHORT_NAME = PER, FORM_NAME = PERWSQHM, TEMPLATE_NAME = XXVAI_PER_ENTER_EMPS_FI_V4, TERRITORY_SHORT_NAME = FI, WINDOW_NAME = MAINTAIN_WINDOW, CANVAS_NAME = MAINTAIN_MAIN, ORA-01403: no data found
...


STEPS TO REPRODUCE
----------------------------------
Use responsibility :
Navigation :processes and reports > submit processes and reports
1.single request
2. Forms Configurator - Upload Template


ADDITIONAL INFORMATION
----------------------------------


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms