Home » Applications » Oracle Fusion Apps & E-Business Suite » Problem with Custom Tables Registration
icon3.gif  Problem with Custom Tables Registration [message #316762] Mon, 28 April 2008 04:35 Go to next message
Arun1203
Messages: 78
Registered: September 2006
Location: Gaborone,Botswana
Member
Dear Members Smile ,

I want to create some alerts on my custom application.
I have registered my custom application with Apps.

I have created some custom tables in the respective custom schema.
After creating the tables I have registered them with AD_DD pacakage.
Created synonyms as well in apps.

Now when iam trying to query my respective custom table in
'Tables' form of Apps,iam unable to do that.

And also when iam trying to create the alerts in 'Define Alert' window my custom application is not shown in the Applications LOV.

Can any one please tell me what is the reason.

Thanks in advance.

Regards,
Arun Reddy Smile .




Report message to a moderator

Re: Problem with Custom Tables Registration [message #317101 is a reply to message #316762] Tue, 29 April 2008 09:17 Go to previous message
sameer_am2002
Messages: 129
Registered: September 2002
Senior Member
You need to run these scripts against your custom user by connecting to system user
SQL> @$AD_TOP/admin/sql/adaddls.pls <SYSTEM_PW> <SCHEMA_NAME> <SCHEMA_PW>
SQL> @$AD_TOP/admin/sql/adaaddls.pls <SYSTEM_PW> <SCHEMA_NAME> <SCHEMA_PW>
SQL> @$AD_TOP/admin/sql/adaddlb.pls <SYSTEM_PW> <SCHEMA_NAME> <SCHEMA_PW>
SQL> @$AD_TOP/admin/sql/adaaddlb.pls <SYSTEM_PW> <SCHEMA_NAME> <SCHEMA_PW>


After running these scripts give grants to apps for your custom objects
Then connect with apps and create synonym for these objects

Also you need to register your application in Oracle Alerts in order to use it. Navigation - > Oracle Alerts -> System - Installation.



Akil Ayub
Oracle Consultant
National Commercial Bank (Jeddah - KSA)

Report message to a moderator

Previous Topic: Date Stored in a attribute
Next Topic: error while applying receipts
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 18:11:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.