Here I am trying to configure Oracle Advanced Planning Schedular in the E-Business Suite. I think u have some expertise on this apart from your other APPS knowledge. Please see my mail and respond ASAP machi.

The Probelm is as follows:
The version is Oracle Apps 11i(11.5.2)


I have two database. One is Production with instance name PROD and the other is Vision demo database with instance name VIS.

Advanced Planning Schedule(APS) is installed in Production Database(PROD) and hence I took this database as the destination database. I have installed all the modules in the Vison demo database(VIS) and took this as source database.

I have created the database link between these two databases(PROD & VIS). The link is a public database link in order to give access to all users to access the schemas of other database.

I did run the refresh snapshot scripts in the source(VIS) database.

From Application side I have done following setup:
1) Increased Standard Manager work shift to 25
2) Create APS Partition
3) Create Partitions
4) Set MRP:Snapshot workers =4

I got stuck when I tried to create the INSTANCES THROUGH SETUP-INSTANCES IN ADVANCED SUPPLY CHAIN PLANNER in the Production(PROD) considered here as the destination database.

I gave the following.

Instance Code: We used VIS
Instance Type: Discrete
Version:11i
Application Database Link(Source-VIS):The link created on the source that points to the destination.
Planning Database Link(Destination-PROD):The link created on the destination that points to the source.
Check Box: Enabled
GMT : 5
Currency:USD
Assignment set: Since we did not have an assignment set to work with, I left this blank.

When I tried to save the form, we got error.

FRM-40745: ON-INSERT trigger raised unhandled exception ORA-00942.

ORA-00942: table or view does not exist
ORA-02063: preceding line from VIS1152
ORA-06512: at "APPS.MSC_GET_NAME", line 768


Hope to have your reply ASAP.

Srikanth