My Oracle Support Banner

PN: R12.2: Error when executing PNCLAB: Calculate ROU Asset and Liability balances with streams (Doc ID 2419092.1)

Last updated on AUGUST 16, 2018

Applies to:

Oracle Property Manager - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Leases

Error when executing PNCLAB: Calculate ROU Asset and Liability balances with streams

When executing "Calculate ROU Asset and liability balances with stream" the report Complete in error.

ERROR
-----------------------
ORACLE error 1422 in FDPSTP

Cause: FDPSTP failed due to ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.PN_ACCNTING_BAL_STREAMS", line 8507
ORA-06512: at line 1

Get_Frozen_Flag : p_org_id / errmsg 441/ORA-01403: no data found
Get_Frozen_Flag : N
Frozen Flag: N
VALIDATE_REQ_PARAMS (+)
VALIDATE_REQ_PARAMS (-)
INIT_GTT_TABLES (+)
Entered GET_LEASE_DATA_SOURCE
Data Source (A: Archieve, P: Production): P
Loading GTT tables from PRODUCTION tables.
No of leases loaded:
Done loading GTT tables.
INIT_GTT_TABLES (-)
currency :
DELETE_ACCNTING_TEMP_DATA (+)
DELETE_ACCNTING_TEMP_DATA (-)
Error while fetching GL Period dates :ORA-01422: exact fetch returns more than requested number of rows
22-05-2018 09:08:23 Error in main procedure
22-05-2018 09:08:23 Error :-1422ORA-01422: exact fetch returns more than requested number of rows

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


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