My Oracle Support Banner

Retro Process Throwing Error: Details: The entry value is validated by a lookup table, but the value (Defulat)does not exist for lookup type does not exist for lookup type ORA_EXPEDITE_CHECK_PRINTER (Doc ID 2418827.1)

Last updated on JULY 03, 2018

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.18.02.0 version, Global Payroll

Retro process throwing error

We ran the retro process and faced the following error:
“: The entry value is validated by a lookup table, but the value (Defulat) does not exist for lookup type ORA_EXPEDITE_CHECK_PRINTER.”.

I added lookup value in the mentioned lookup and retro ran fine. however, I am not sure we should be making updates to the lookup. please confirm.


ERROR
-----------------------

A system error ORA-20001: The entry value does not exist in the lookup table. Details: The entry value is validated by a lookup table, but the value (Defulat)does not exist for lookup type does not exist for lookup type ORA_EXPEDITE_CHECK_PRINTER. (Default was spelled incorrectly in the message)
ORA-06512: at "FUSION.PAY_RETRO_PKG".line 1812 ORA-06512:at line 1 occurred in table pay_retro_pkg_pkg.create_retro_entry at location 3065. Your help desk was notified


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

We ran the retro process and faced the following error:

BUSINESS IMPACT
-----------------------
The issue has the following business impact:

I added lookup value in the mentioned lookup and retro ran fine. however, I am not sure we should be making updates to the lookup. please confirm.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.