Financial Management - PSFT (MOSC)

MOSC Banner

GL Jrnl Reversal Erroring on Open Item Insert

The COBOL progam, GLPPRVRS encounters a SQL INSERT error trying to insert into the PS_GL_OI_TMP001 table.

The dynamic INSERT statement, GLPPRVRS_I_OITEMP, that is created in the GLPPRVRS includes a data column called ACCOUNT_CODE that does not exist on the PS_GL_OI_TMP001, PS_GL_OI_TMP002, PS_GL_OI_TMP003, PS_GL_OI_TMP004 nor the PS_OPEN_ITEM_GL.

Has anyone encountered this error? It looks like the GL_OI_TMP and the OPEN_ITEM_GL record definitions should include the ACCOUNT_CODE that is defined on the JRNL_LN record definition.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center