problem in running the plsql in apps of interfaces

All the discussion which is not possible in the above forums should be posted here.
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,
abt Interafces
i am new in apps ,Plz let me know the problem in detail.

This is to import the Newcustomer details in to interface tables in AR.
actualy i have created a staging table in AR and then created a PRIVELIGES to APPS.
The owner of the doc package is AR.
i have compiled in the APPS SCHEMA WITH NO ERRORS.
i have added the mandatary paramaters.
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. u can find the coding in attachment.

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
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests