problem in running the plsql in apps of interfaces

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
seenujanu
Posts: 6
Joined: Sat Sep 02, 2006 8:56 am
Location: India

problem in running the plsql in apps of interfaces

Post by seenujanu »

hai friends,
Problem abt Interfaces
i am new in apps ,Plz let me know the problem in detail.
i have created a package giving some error u can find that in attachment.
i have created two tables in AR is ra_customer_int_temp and created the grants seleect,insert ,update
and created a synonym in APPS.

Before this i have executed in backend showing no errors.
i have registerd in apps and Execution name is doc.newcust and package name is doc & file name is doc.sql
extension placed in sql folder in AR.
after running in Application showing this error.
Any more things i have left Plz let me know


Current system time is 31-AUG-2006 16:00:41

+---------------------------------------------------------------------------+

**Starts**31-AUG-2006 16:00:42
ORACLE error 6550 in FDPSTP

Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00201: identifier 'DOC.NEWCUST' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
.

The SQL statement being executed at the ti
+---------------------------------------------------------------------------+
Start of log messages from Plsql program
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from PlSql program
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+


Executing request completion options...


Finished executing request completion options.



+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 31-AUG-2006 16:00:42

+---------------------------------------------------------------------------+

thanks in advace
seenu
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Pl don't create duplicate threads. I am closing this one while keeping other open in the General Forums. thanks
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 10 guests