My Oracle Support Banner

TCC: Function Projection "Subtract Date" Error "ORA-06553: PLS-306" (Doc ID 2865699.1)

Last updated on MAY 09, 2023

Applies to:

Oracle Taleo Platform Cloud Service - Connect - Version 22A and later
Oracle Taleo Recruiting Cloud Service - Version 22A and later
Information in this document applies to any platform.

Symptoms

 An export that has the Subtract Date function projection fails with this error:

 

Changes

 A Subtract Date function projection with date UDFs was added to the export script.

Steps:

  1. In an export script opened in TCC, click Add button in the Projections tab.
  2. Set "Add a function projection" and in the Function Projection drop down choose "Subtract date" and click OK.
  3. Enter a value for "Alias" and set both parameters to use UDFs defined as dates.

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!

In this Document
Symptoms
Changes
Cause
Solution
References


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