DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle Advanced Planning Scheduler - Error

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    57
    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


  2. #2
    Join Date
    Feb 2001
    Posts
    62
    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

  3. #3
    Join Date
    Nov 2000
    Posts
    57
    Dear Friend,

    I do have the Objects. I doubt with the package. Is there any patch to solve this problem...?


  4. #4
    Join Date
    Feb 2001
    Posts
    62
    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
  •  


Click Here to Expand Forum to Full Width