My Oracle Support Banner

R12 FSG returning zero value when Period of interest used in Row Set (Doc ID 1234573.1)

Last updated on AUGUST 19, 2019

Applies to:

Oracle General Ledger - Version 12.1.2 and later
Information in this document applies to any platform.


Attempting to define an FSG that is using a row set with rows using different period offsets and it does not return the correct data. Zero values are returned instead of the correct period data.

Example of what is being defined:
One column column set without a amount type defined

Two row rowset that have the same account combination defined for each.
Both are using the Actual YTD amount type.
Row 1 is using a period offset of -1
Row 2 is not using a period offset.

Expectations are that row 1 would return the prior period YTD ending balance for the specified account. Row 2 would return the current period YTD ending balance.

What is instead returned is zero values for both... even when there are non zero values that should be returned.

Example of output:

XXX US Date: 07-OCT-10 17:46:12
Test Top Cash FSG: FP-TOP CASH FLOW Page: 1
Current Period: APR-10

Currency: USD
No specific Ledger requested
0100 Cash Account - Prior Period YTD 0
0100 Cash Account - Current Period YTD 0

Expectations are that the correct YTD balance figures would be displayed and not zero values.


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

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