Unable To Open GL Future Periods (Doc ID 2928443.1)

Last updated on MAY 31, 2023

Applies to:

Goal

On : 11.13.22.10.0 version, Period Close Setup & Processing

Unable to Open GL Future Periods

Why Unable to Open GL Future Periods ?
 on the log file we can see:

SHRD0079: Number of records inserted into the gl_multi_bal_seg_gt table: 11.
Ledger ID: 3000000xxxxxx42
Primary Balancing Segment: 18200
Retained Earnings account: 18200-00-000-00000-3400000-00-00000-00000-00000
Error Message: FND_VS_VALUES_NOT_RELATED
{SG1_NAME}=Company
{SG2_NAME}=Office
{SG1_VALUE_SET_CODE}=Company XXX
{SG2_VALUE_SET_CODE}=Office XXX
{SG1_VALUE}=18200
{SG2_VALUE}=00000

Ledger ID: 3000000xxxxxx42
Primary Balancing Segment: 18100
Retained Earnings account: 18100-00-000-00000-3400000-00-00000-00000-00000
Error Message: FND_VS_VALUES_NOT_RELATED
{SG1_NAME}=Company
{SG2_NAME}=Office
{SG1_VALUE_SET_CODE}=Company XXX
{SG2_VALUE_SET_CODE}=Office XXX
{SG1_VALUE}=18100
{SG2_VALUE}=00000

Ledger ID: 3000000xxxxxx42
Primary Balancing Segment: 18300
Retained Earnings account: 18300-00-000-00000-3400000-00-00000-00000-00000
Error Message: FND_VS_VALUES_NOT_RELATED
{SG1_NAME}=Company
{SG2_NAME}=Office
{SG1_VALUE_SET_CODE}=Company XXX
{SG2_VALUE_SET_CODE}=Office XXX
{SG1_VALUE}=18300
{SG2_VALUE}=00000

<x gl_multi_bal_seg_api.get_balancing_accounts() 10-FEB-2023 09:47:30
SHRD0086: Error code from executing previous SQL statement: 1403

Solution

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