OraFAQ Forum: Other Application Suites » Table Registation problem

Home » Applications » Other Application Suites » Table Registation problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table Registation problem [message #343403]

Wed, 27 August 2008 03:42

jaganerp@gmail.com
Messages: 63
Registered: April 2008

Member

Hai Friend's

I created one table in non apps user, and given grant's to apps user and created one synonym in apps user and register that form in apps user but that table is not describe in apps user,but i want to create form based on that table, what i will do

i did like this

step1:
----------
CREATE TABLE XXVES_KFF_EMP
(
EMPNO NUMBER(5) PRIMARY KEY,
ENAME VARCHAR2(60) NOT NULL,
JOB VARCHAR2(20) NOT NULL,
SAL NUMBER(10,2) NOT NULL,
CCID NUMBER(38) NOT NULL REFERENCES XXVES_KFF_COMBINATIONS(CCID)
);
step2:
------
grant all on XXVES_KFF_EMP to apps
step3:
------
connect apps/apps@techserver
step4:
--------
EXECUTE AD_DD.register_table ('V-SAT', 'XXVES_KFF_EMP', 'T')
step5:
---------
EXECUTE AD_DD.register_COLUMN('V-SAT','XXVES_KFF_EMP','EMPNO',1,'NUMBER',5,'N','N')
EXECUTE AD_DD.register_COLUMN('V-SAT','XXVES_KFF_EMP','ENAME',2,'VARCHAR2',60,'N','N')
EXECUTE AD_DD.register_COLUMN('V-SAT','XXVES_KFF_EMP','JOB',3,'VARCHAR2',20,'N','N')
EXECUTE AD_DD.register_COLUMN('V-SAT','XXVES_KFF_EMP','SAL',4,'NUMBER',10,'N','N',2)
EXECUTE AD_DD.register_COLUMN('V-SAT','XXVES_KFF_EMP','CCID',5,'NUMBER',38,'N','N')
step6:
-----
desc XXVES_KFF_EMP;

now it's giving error object not exit

Report message to a moderator

Re: Table Registation problem [message #396177 is a reply to message #343403]

Sat, 04 April 2009 11:20

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Why this post not in "Oracle Fusion Apps & E-Business Suite"?
I think you are using Oracle Applications only.
Do you want me to move this to "Oracle Fusion Apps & E-Business Suite"?

By the way what is V-SAT? Is it just a schema or another custom product? Is V-SAT in fnd_application_vl?
I think AD_DD.register_table expects a application_short_name as the first parameter.

Moreover is your desc <table> giving issues? (Or) your form?
Try to use apps.<table> or V-SAT.<table>

By
Vamsi

EDIT: I didn't notice that it is a quiet old post.

[Updated on: Sat, 04 April 2009 11:24]

Report message to a moderator

Previous Topic:	Interface Documents for Customer Item & Bills of Material
Next Topic:	Need study document for -Oracle ECM Tools

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 12:05:24 CST 2024