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