My Oracle Support Banner

GLXJEENT When Enter a Manual Journal for Category Payroll Get APP-FND-01564: ORACLE error 942 in fdscar During INSERT INTO PAY_DOC_SEQUENCE_AUDIT (Doc ID 1674934.1)

Last updated on SEPTEMBER 05, 2019

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
Form:GLXJEENT.FMB - Enter Journals/Encumbrances

Symptoms

On : 12.1.3 version, Journal Entry

When creating a manual journal in GL for category Payroll , the following error occurs when saving

ERROR
-----------------------
APP-FND-01564: ORACLE error 942 in fdscar

Cause: fdscar failed due to ORA-00942: Table or view does not exist

The SQL statement being executed at the time of the error was
INSERT INTO PAY_DOC_SEQUENCE_AUDIT (DOC_SEQUENCE_ID, DOC_SEQUENCE_ASSIGNMENT_ID, DOC_SEQUENCE_VALUE, CREATION_DATE, CREATED_BY,) VALUES (:seqid, :seqassid, :sqlval, sysdate, :option_value) and was executed from the file &ERRFILE

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