EGL92: GL_YC Year End Close No Success If Closing Rule Has Affiliate CF "SETID Invalid Identifier" (Doc ID 2251771.1)

Last updated on JULY 03, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

GL_YC year end close "No Success" if closing rule has Affiliate CF

The year end closing process errors out if the closing rule includes Affiliate chartfield. As per the error log the system is trying to query the AFFILIATE_VW on SETID and the SQL fails. See attached error log- files

ERROR
-----------------------
SQL Error: ORA-00904: "A"."SETID": invalid identifier

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Ledger Group with more than one ledger
2. Set up Closing Rule based on Account and Affiliate
3. Set up Closing Group with above closing rule
4. Run the Full Close process using GL_YC

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms