problem in running the plsql in apps of interfaces [message #190595] |
Thu, 31 August 2006 06:20 |
seenujanu
Messages: 53 Registered: August 2006 Location: chennai
|
Member |
|
|
hai friends,
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. 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
|
|
|
|
Re: problem in running the plsql in apps of interfaces [message #190614 is a reply to message #190595] |
Thu, 31 August 2006 07:03 |
seenujanu
Messages: 53 Registered: August 2006 Location: chennai
|
Member |
|
|
hai ngouadjeu
This is to import the Newcustomer details in to interface tables in AR.
actualy i have created a staging table in AR not a custom and then created a PRIVELIGES to APPS.i have placed in AR --file name is doc.sql
The owner of the doc package is AR.
i have compiled in the APPS SCHEMA WITH NO ERRORS.
i have added the mandatary paramaters.
u can find the attachment of that coding AR .
plz let me know in detail...
|
|
|
Re: problem in running the plsql in apps of interfaces [message #190644 is a reply to message #190614] |
Thu, 31 August 2006 09:12 |
agostino_neto
Messages: 180 Registered: July 2005
|
Senior Member |
|
|
Did you create a synonym for ARNewCust for apps ?
Generally packages are created directly on apps user.
What is your executable file: ARNewCust.NewCust or DOC.NEWCUST ?
The name should be ARNewCust.NewCust is the package is already stored in the database (and belongs to apps or if there is a synonum)
|
|
|
problem in running the plsql in apps of interfaces [message #190731 is a reply to message #190644] |
Fri, 01 September 2006 01:11 |
seenujanu
Messages: 53 Registered: August 2006 Location: chennai
|
Member |
|
|
Still i am getting problem
hai ngouadjeu
i have changed that executable file name ARNewCust.NewCust
still i am getting that same problem
i have created a packages directly on apps user not in AR
i have compiled in APPS not in AR
when i compiled in apps i am not getting the error but
when i compile in AR i am getting error that table or view doesnt exist
AR_LOOKUPS
fnd_territories_tl
ra_customers_interface
seenu
|
|
|
Re: problem in running the plsql in apps of interfaces [message #190780 is a reply to message #190731] |
Fri, 01 September 2006 03:34 |
agostino_neto
Messages: 180 Registered: July 2005
|
Senior Member |
|
|
Are you still having
----
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
----
First check grant all permission on custom tables to apps
Check that the executable name is similar to the package name (and not the file name -You should not have 'DOC.NEWCUST' must be declared)
Do not create the same package in AR and APPS (it is not useful)
|
|
|
problem in running the plsql in apps of interfaces [message #190907 is a reply to message #190595] |
Sat, 02 September 2006 04:54 |
seenujanu
Messages: 53 Registered: August 2006 Location: chennai
|
Member |
|
|
Hai senior
I Have Granted to APPS is
GRANT DELETE, INSERT, SELECT, UPDATE
ON AR.ra_customer_int_temp
TO APPS
WITH GRANT OPTION
for this custom table ra_customer_int_temp
Executable Name 'ArNewcust.NEWCUST'
But i am having same problem showing this error
ORACLE error 6550 in FDPSTP
Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00201: identifier 'arnewcust.NEWCUST' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Any thing i have left from this
Plz let me know that........in Details
thanks
seenu
|
|
|