My Oracle Support Banner

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

Last updated on JUNE 26, 2018

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

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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