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 laterOracle 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 |