Home » Applications » Oracle Fusion Apps & E-Business Suite » problem in running the plsql in apps of interfaces
problem in running the plsql in apps of interfaces [message #190595] Thu, 31 August 2006 06:20 Go to next message
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 #190600 is a reply to message #190595] Thu, 31 August 2006 06:33 Go to previous messageGo to next message
agostino_neto
Messages: 180
Registered: July 2005
Senior Member
Custom tables should be created in a custom schema not AR.
Who is the owner of doc package ?
Is there any error on that package ?
Did you add madatary parameters
Re: problem in running the plsql in apps of interfaces [message #190614 is a reply to message #190595] Thu, 31 August 2006 07:03 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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


Previous Topic: concureent requests in OM.
Next Topic: Financial Interview quries
Goto Forum:
  


Current Time: Sun Dec 04 12:49:03 CST 2016

Total time taken to generate the page: 0.04574 seconds