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 220.127.116.11 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 10.2.0.2 RDBMS
Update October 2007
This has also been reported by customer on APS instance with RDMBS 18.104.22.168 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!