Order Management - EBS (MOSC)

MOSC Banner

Can anybody send me the script deplete_inv.pls?

edited May 12, 2016 5:00AM in Order Management - EBS (MOSC) 2 commentsAnswered

Error when run a workload by using the workload generator: $ ./workgen 2 1

The Oracle base for

The Oracle base for ORACLE_HOME=/u01/OracleHomes/db12c/product/dbhome_1 is /u01/OracleHomes/db

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

     deplete_inv(order_item_rec.product_id, order_item_rec.quantity);

     *

ERROR at line 89:

ORA-06550: line 89, column 6:

PLS-00201: identifier 'DEPLETE_INV' must be declared

ORA-06550: line 89, column 6:

PL/SQL: Statement ignored

The database do not have "deplete_inv" store procedure (SP) for the "oe" schema, and the.O.S. do not have the script "deplete_inv.pls" to create the SP too:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center