My Oracle Support Banner

MSCPUSH Push Plan Fails With Oracle Error 904 In FDPSTP on 10gR2 (Doc ID 431751.1)

Last updated on FEBRUARY 14, 2019

Applies to:

Oracle Advanced Supply Chain Planning - Version to 12.0.4 [Release 11.5 to 12]
Information in this document applies to any platform.

EXECUTABLE:MSCPUSH - Push Plan Information


When attempting to run MSCPUSH the following error occurs.

ORACLE error 904 in FDPSTP
Cause: FDPSTP failed due to ORA-00904: "A1"."SUPPLIER_SITE_ID" : invalid identifier
ORA-02063 : preceding line from ATEST
ORA-02063 : Preceding 2 lines from TEST
ORA-06512 : at "APPS>MSC_M2A_PUSH", line 2558

Also reported in R12.0.4 as error text:

ORACLE error 2055 in FDPSTP

Cause: FDPSTP failed due to ORA-02055: distributed update operation failed; rollback required
ORA-00904: "A1"."SUPPLIER_SITE_ID": invalid identifier
ORA-02063: preceding line from UASCP
ORA-02063: preceding 2 lines from UAT


Launch Push Plan Information request from the APS Instance where the setups is:
1. A distributed installation of APS and ERP instances where --- 
2. BOTH instances are running the RDBMS



Update October 2007
This has also been reported by customer on APS instance with RDMBS pushing to ERP on

Update January 2009
Reported for R12.0.4 pushing from APS on RDBMS to ERP also on


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.