-
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
-
U should have these objects in your database. Check your install files for errors.
SQL> select * from dba_objects where object_name = 'MSC_GET_NAME';
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------- ------------------
CREATED LAST_DDL_ TIMESTAMP STATUS T G S
--------- --------- ------------------- ------- - - -
APPS
MSC_GET_NAME
69646 PACKAGE
27-JUL-01 30-JUL-01 2001-07-30:13:13:04 VALID N N N
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------- ------------------
CREATED LAST_DDL_ TIMESTAMP STATUS T G S
--------- --------- ------------------- ------- - - -
APPS
MSC_GET_NAME
78275 PACKAGE BODY
27-JUL-01 31-JUL-01 2001-07-31:16:59:23 VALID N N N
-
Dear Friend,
I do have the Objects. I doubt with the package. Is there any patch to solve this problem...?
-
Don't know what you mean. Are the packages valid ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|