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

Last updated on JUNE 28, 2017

Applies to:

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

EXECUTABLE:MSCPUSH - Push Plan Information

Symptoms

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
ORA-065
 

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

 

STEPS:
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 10.2.0.2 RDBMS

 

 

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

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

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