PMT_LOAD_SC Not Processing Rows Where AMOUNT = 0 & PRENOTE_FLAG = Y
Last updated on MARCH 09, 2017
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 customer 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.
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