My Oracle Support Banner

GLFYCF module: Year-End Carry Forward Completes In Error - ORA-942 On GL_POSTING_INTERIM_###### (Doc ID 2733346.1)

Last updated on DECEMBER 02, 2020

Applies to:

Oracle Public Sector Financials - Version 12.1.3 and later
Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
GLFYCF
Year-End
Carry Forward
ORA-00942
GL_POSTING_INTERIM_
glpibr
PERF0005

Symptoms

On : 12.1.3 version, Standard Reports & Inquiries

Executing GLFYCF Year-End Carry Forward completes with the following error:

>> glpibr()
PERF0005: Oracle error detected in glpibr() - ORA-00942: table or view does
not exist

SHRD0075: Error in glfmai/glpibr().
SHRD0115: Function Returning Status: 0
SHRD0102: Function Error Message:
  SHRD0018: Oracle database error trapped at function: glfmai/glpibr - label: glfmai/glpibr


A trace file shows the error is on a posting interim table "gl_posting_interim_######".

PARSE ERROR #139894335638688:len=76 dep=0 uid=173 oct=3 lid=173
tim=3891641158315 err=942
SELECT distinct ledger_id FROM gl_posting_interim_281455 ORDER BY ledger_id

The specific gl_posting_interim_####### table in the error message really does not exist in any database schema.

Changes

 

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.