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.