The 'Import Options' List of Values (LOV) does not Contain an 'Overwrite' option in the 'Import Application Accounting Definition' Process due to Incorrect Definition of Value Set XLA_SRS_AAD_IMPORT_OPTIONS. (Doc ID 2064715.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Foundation - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

When running the 'Import Application Accounting Definition' process in Receivables, the 'Import Options' LOV does not contain an 'Overwrite' option. The file pabcp.ldt contains a different definition of the value set XLA_SRS_AAD_IMPORT_OPTIONS in comparison to xla120vs.ldt.

pabcp.ldt 120.64.12020000.20 defines the following ADDITIONAL_WHERE_CLAUSE:

--
WHERE lookup_type = 'XLA_AAD_IMPORT_OPTION'
AND :$FLEX$.XLA_SRS_NO_VALIDATION = 'Y'
AND LK.LOOKUP_CODE <> 'OVERWRITE'
--

xla120vs.ldt 120.46.12020000.2 defines the following ADDITIONAL_WHERE_CLAUSE:
--
WHERE lookup_type = 'XLA_AAD_IMPORT_OPTION'
  AND :$FLEX$.XLA_SRS_NO_VALIDATION = 'Y'

The overwrite option is a requirement for custom definitions.

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