#27 Cannot process Orders/Invoices - ORA-00979

R2.4.3c
closed-fixed
Jorg Janke
7
2002-12-27
2002-12-27
Jorg Janke
No

See bug http://sourceforge.net/tracker/index.php?
func=detail&aid=659024&group_id=29057&atid=410215

Discussion

  • Jorg Janke
    Jorg Janke
    2002-12-27

    • priority: 5 --> 7
    • summary: Cannot process Orders/Invoices - ORA-979 --> Cannot process Orders/Invoices - ORA-00979
     
  • Jorg Janke
    Jorg Janke
    2002-12-27

    • status: open --> closed-fixed
     
  • Jorg Janke
    Jorg Janke
    2002-12-27

    Logged In: YES
    user_id=87038

    Download the following files and apply them to the database:

    http://cvs.sourceforge.net/cgi-
    bin/viewcvs.cgi/compiere/db/database/Procedures/C_Invoice_
    Post.sql

    http://cvs.sourceforge.net/cgi-
    bin/viewcvs.cgi/compiere/db/database/Procedures/C_Order_P
    ost.sql

    e.g.
    sqlplus compiere/compiere @C_Invoice_Post.sql

    alternatively you can call start sqlplus compiere/compiere
    and at the SQL> prompt enter

    start C_Invoice_Post.sql
    start C_Order_Post.sql
    exit