My Oracle Support Banner

EGL 9.2: Allocation Temp Table ALC_GL_P_TAO Is Missing BUDGET_DT Field (Doc ID 2537325.1)

Last updated on MAY 01, 2019

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

 

 

 

Allocation Temp table ALC_GL_P_TAO is missing BUDGET_DT field

 

Allocation process is abending when users are trying to create allocation journals by mapping BUDGET_DT field on the pool to the BUDGET_DT field on the Target Allocation journal. This is due to the Allocation Temp tables ALC_GL_P_TAO and ALC_GL_P_G missing the BUDGET_DT field. All the other GL Target and Offset tables have the BUDGET_DT field.

 

 

ERROR

-----------------------

Stmt #: 1723 Error Position: 1835 Return: 904 - ORA-00904: "A"."BUDGET_DT": invalid identifier

 

 

 

Solution

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
Goal
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.