My Oracle Support Banner

EAR 9.2: Resolve Meta SQL Is Not Working Correctly For Customer Statement Process (AR_STMTS.INS3200A.INS32001 SQL) (Doc ID 2900374.1)

Last updated on OCTOBER 03, 2022

Applies to:

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


Resolve Meta SQL is not working correctly for Customer Statement Process (AR_STMTS.INS3200A.INS32001 SQL)
In the Customer statement process, AR_STMTS.INS3200A.INS32001 section, %insertselect statement where DELETE_AFTER_PRINT='N' is set. When resolving the meta sql in App Designer, it is setting blank value instead of 'N' .  The same is true for STATEMENT_IMG field as well.

Replication Steps:
1. Open AR_STMTS.INS3200A.INS32001 SQL in App designer.
2. Select the SQL and right-click to resolve meta SQL.
3. Note after USER10 the value blank is getting inserted.



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.