XTR Accruals Amort Table With Wrong Period From Value (Doc ID 1316935.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Treasury - Version: 11.5.10.0 to 12.1.3 - Release: 11.5 to 12.1
Information in this document applies to any platform.

Symptoms


=== ODM Issue Clarification ===
On : 12.1.2 version, Acct'ing-Jounals,Accrual,Reval, Find that XTR accruals amort table with wrong period from value.
When you run accruals for period one with dates Period from 1-jan-2011 and period to 28-jan-2011 expected the XTR_Acccruals amort table to store period_from as 1-jan-2011 and period_to as 28-jan-2011. Instead of 1-jan-2011 as period_from XTR_accruals_amort table stores 31-dec-2010 is
the issue. See the data on the deal number 237 that uploaded after the accrual process.
Day Count Basis: Actual / Actual - Bond

Review: : DEAL_237_AFTERPATCH.xls
Results of:
Select * FROM XTR.XTR_ACCRLS_AMORT
where DEAL_NO=237;

DEAL_NO TRANS_NO PERIOD_FROM PERIOD_TO
237 7 11/27/2010 00:00:00 12/31/2010 00:00:00 237 8 12/31/2010 00:00:00
01/28/2011 00:00:00 237 8 01/29/2011 00:00:00 02/25/2011 00:00:00
The Transaction 7 PERIOD TO: 12/31/2010 and TRANSACTION 8 PERIOD_FROM:
12/31/2010???>> It should be 01/01/2011.

In R12.1.2:
forms/US/XTRACACL.fmb 120.6.12010000.2
XTR_ACCRUAL_PROCESS_P xtracclb.pls 120.33
XTR_ACCRUAL_PROCESS_P xtraccls.pls 120.4

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run accruals for a period one certain deals shows the issue which has:
Day Count Basis: Actual / Actual - Bond

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot be sure to complete accounting.

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