Changing The Promise Amount Causes Confirmation To Fail (Doc ID 1427103.1)

Last updated on JULY 24, 2017

Applies to:

Oracle Advanced Collections - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms


Changing the Promise Amount Causes Confirmation to Fail

The Query on the XML Template executes as follows:

SELECT TO_CHAR(SYSDATE, 'MM/DD/YYYY') CURRSYSDATE,
DECODE((PER.PERSON_FIRST_NAME || PER.PERSON_LAST_NAME), NULL, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('RESPONSIBILITY', 'APS'), PER.PERSON_FIRST_NAME) FIRST_NAME,
PER.PERSON_LAST_NAME LAST_NAME,
ORG.PARTY_NAME ORG_NAME,
LOC.ADDRESS1 ADDRESS1,
LOC.ADDRESS2 ADDRESS2,
LOC.CITY CITY,
LOC.STATE STATE,
LOC.POSTAL_CODE POSTAL_CODE,
PER.PERSON_FIRST_NAME FIRST_NAME1,
TO_CHAR(TO_DATE('null'), 'MM/DD/YYYY') SYSDATE1,
(SELECT SUM(PV.PROMISE_AMOUNT) FROM IEX_PROMISE_DETAILS PV
WHERE PV.CUST_ACCOUNT_ID= PROM.CUST_ACCOUNT_ID AND TRUNC(TO_DATE('null')) = TRUNC(PV.CREATION_DATE) AND PV.STATUS = 'COLLECTABLE') PTP_AMOUNT,
(SELECT SUM(PV.PROMISE_AMOUNT) FROM IEX_PROMISE_DETAILS PV
WHERE PV.CUST_ACCOUNT_ID= PROM.CUST_ACCOUNT_ID AND TRUNC(TO_DATE('null')) = TRUNC(PV.CREATION_DATE) AND PV.STATUS = 'COLLECTABLE') PTP_AMOUNT1,
RS.SOURCE_PHONE COLLECTOR_PHONE1,
RS.SOURCE_FIRST_NAME ||' '||RS.SOURCE_LAST_NAME COLLECTOR_NAME,
RS.SOURCE_JOB_TITLE COLLECTOR_TITLE,
RS.SOURCE_PHONE COLLECTOR_PHONE,
CURSOR (SELECT PSA.TRX_NUMBER INVOICE_NUMBER, TO_CHAR(PV.PROMISE_DATE, 'MM/DD/YYYY') PTP_DUE_DATE, PV.PROMISE_AMOUNT PTP_AMOUNT2
FROM IEX_PROMISE_DETAILS PV, IEX_DELINQUENCIES_ALL DEL, AR_PAYMENT_SCHEDULES_ALL PSA
WHERE
PV.CUST_ACCOUNT_ID= PROM.CUST_ACCOUNT_ID AND
TRUNC(TO_DATE('null')) = TRUNC(PV.CREATION_DATE) AND
PV.STATUS = 'COLLECTABLE' AND
PV.DELINQUENCY_ID IS NOT NULL AND
PV.DELINQUENCY_ID = DEL.DELINQUENCY_ID AND
DEL.PAYMENT_SCHEDULE_ID = PSA.PAYMENT_SCHEDULE_ID) AS PAYMENT_HISTORY
FROM
HZ_LOCATIONS LOC
,HZ_PARTIES ORG
,HZ_PARTIES PER
,JTF_RS_RESOURCE_EXTNS RS
,IEX_PROMISE_DETAILS PROM
WHERE
LOC.LOCATION_ID = 405
AND ORG.PARTY_ID= 26047
AND PER.PARTY_ID = NVL(39066, ORG.PARTY_ID)
AND RS.RESOURCE_ID = 100011061
AND PROM.PROMISE_DETAIL_ID = null


Promise_Detail_ID is missing.

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