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
Messages: 78
Registered: September 2006
Location: Gaborone,Botswana

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.

Arun Reddy Smile .

Re: Problem with Custom Tables Registration [message #317101 is a reply to message #316762] Tue, 29 April 2008 09:17 Go to previous message
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)
Previous Topic: Oracle Inventory - material description
Next Topic: How to alter a parameter in a scheduled conc. program
Goto Forum:

Current Time: Wed Aug 23 03:15:43 CDT 2017

Total time taken to generate the page: 0.02329 seconds