My Oracle Support Banner

EDM: Changing Settlement Instructions on Deal Abends at Step TR_POSN_LIB.PROCESS.INSCF (Doc ID 2685926.1)

Last updated on JUNE 30, 2020

Applies to:

PeopleSoft Enterprise FIN Deal Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Treasury Counterparty has 2 different Settlement Instructions. If a Deal already has some payments made and when attempting to either (1) enter a Sell/Buyback transaction or (2) update the Settlement Instructions with a different Settlement Instruction, an error occurs and process abends at Step TR_POSN_LIB.PROCESS.INSCF.

ERRORS
A SQL error occurred. Please consult your system log for details.

Process 0 ABENDED at Step TR_POSN_LIB.PROCESS.INSCF (SQL) -- RC = 805 (108,524)

CallAppEngine: Application TR_POSN: AppEngine error. (2,653) TR_PANELS_WRK.CREATE_POSN_FUNC.FieldFormula Name:CreatePositionRecords PCPC:543 Statement:12
Called from:TR_PANELS_WRK.CASHFLOWS_PB.FieldChange Statement:8

During a CallAppEngine builtin function call, the Application Engine detected an error. The Application Engine log may provide more information.

SCENARIO 1

STEPS
1. Setup Treasury Counterparty with 2 different Settlement Instructions and one of them has the Primary box checked
2. Create a Deal with Classification = Debt, Rate Type = Fixed and Discount/Premium = Constant Yield Method
3. On the Settlement Instructions page, Counterparty's Instructions is populated with the Primary Settlement Instructions from Step 1
4. Run Automated Accounting for the Deal
5. Settlement for the 06/30/2020 payment is selected
6. Settlement is Approved
7. On the Payment Dispatch page, select the Settlement
8. Dispatch the Settlement
9. Settlement has Dispatch Status = Paid
10. Display the Deal
11. Click the Sell/Buyback hyperlink
12. Update the Update/Display Sell / Buyback Details page, accordingly, and for the Settlement Instructions, specify the non-Primary Settlement Instructions from Step 1
13. On the Deal Details page, click the Cashflows button
14. Above errors occur

======================

SCENARIO 2

STEPS
1. Setup Treasury Counterparty with 2 different Settlement Instructions and one of them has the Primary box checked
2. Create a Deal with Classification = Debt, Rate Type = Fixed and Discount/Premium = Constant Yield Method
3. On the Settlement Instructions page, Counterparty's Instructions is populated with the Primary Settlement Instructions from Step 1
4. Run Automated Accounting for the Deal
5. Settlement for the 06/30/2020 payment is selected
6. Settlement is Approved
7. On the Payment Dispatch page, select the Settlement
8. Dispatch the Settlement
9. Settlement has Dispatch Status = Paid
10. Display the Deal
11. On the Settlement Instructions page, click the magnifying glass for Counterparty’s Instructions
12. Select the non-Primary Settlement Instructions
13. On the Deal Details page, click the Cashflows button
14. Above errors occur

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.