Saving a SQL ID, Last Value Before the FROM Statement Does Not Save (Doc ID 205349.1)

Last updated on MAY 19, 2009

Applies to:

Oracle Financial Services Applications (OFSA)
Oracle Financial Data Manager - Version: 4.5 to 4.5.40
This problem can occur on any platform.

Symptoms

After saving a SQL ID in OFSA Balance and Control, you notice that the last value before the FROM statement does not save.

Changes

For Example:

INSERT INTO DDA(
IDENTITY_CODE,
ID_NUMBER,
GL_ACCOUNT_ID,
ORG_UNIT_ID,
COMMON_COA_ID,
FLOAT_COF)
select
to_char (as_of_date,'yyyymmdd')||'45',
'USD',
1,
sum(to_number(dda_flt_cost) + to_number(non_dda_flt_cost)),
0,
0 <--------------This value gets truncated when saved (notice this is before the FROM)
FROM dda_FLT2
where (pri_acct_type in ('GLR', 'REC') or pri_acct_type is null) and
as_of_date in (select data_as_of_date from ofsa_idt_configure where sys_id_num =
103233)
GROUP BY
as_of_date,
Org_unit_id;
commit;

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