PMT_LOAD_SC Not Processing Rows Where AMOUNT = 0 & PRENOTE_FLAG = Y
(Doc ID 2038076.1)
Last updated on FEBRUARY 05, 2019
Applies to:PeopleSoft Enterprise FIN Cash Management - Version 9.2 and later
Information in this document applies to any platform.
The PMT_LOAD_SC process flags rows where the Amount = 0 and PRENOTE_FLAG = Y as exceptions. These rows remain on the payment staging tables and the PMT_DETAIL_STG.PMT_STATUS = E. The user is processing prenote payments and the process should process rows with amount = 0 and PRENOTE_FLAG = Y since rows with prenote flag of Y will be zero dollars.
1) Loaded data into the staging tables Note: The file, sql_inserts.txt has the insert sql statements.
2) On the PMT_DETAIL_STG, the Amount = 0 and the PRENOTE_FLAG is Y.
3) Run PMT_LOAD_SC
4) Checked the staging tables. Data from PMT_DETAIL_STG shows PMT_STATUS = E.
5) Checked the exception log table (PS_PMT_EXCEPT_LOG) and see that the issue is the Amount field. For Prenote rows, the amounts should be $0.00.
Rows with $0.00 Amount and PRENOTE_FLAG = Y should be picked up and inserted into the PMT_xxx_TBL tables to be processed by PMT_DISPATCH.
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