Contract Variables: User Defined Variable With Source PL/SQL Procedure Errors With 'The Stored Procedure Associated With The Variable Is Not Valid' (Doc ID 1154243.1)

Last updated on FEBRUARY 17, 2019

Applies to:

Symptoms

When attempting to define a user defined variable with Source PL/SQL Procedure, a warning shows while saving.

ERROR
-----------------------
The stored procedure associated with the variable XXXX is not valid. Review the procedure and revise as required.

STEPS
-----------------------
1. Create package.
2. Resp. Contracts Terms Library Administrator
       Contracts: Contract Terms Library
       NAV Variables.
3. Tab Contract Terms Library / Variables
       Create Variable.
       Variable Name DATA2
       Intent Buy
       Value Set 240 Characters Optional
       Source PL/SQL Procedure
       Procedure Name apps.xxxx_contract_vbles.xxxxx_sysdate2
       Variable Code data_avui
5. While saving message shows: Confirmation
      1. The stored procedure associated with the variable DATA2 is not valid. Review the procedure and revise as required.
      2. Variable DATA2 has been updated.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.