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 SEPTEMBER 26, 2022

Applies to:

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





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.





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





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

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