PMT_LOAD_SC Not Processing Rows Where AMOUNT = 0 & PRENOTE_FLAG = Y (Doc ID 2038076.1)

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.

Symptoms

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.

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

EXPECTED RESULTS
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.

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