Home » Applications » Other Application Suites » Table Registation problem
Table Registation problem [message #343403] Wed, 27 August 2008 03:42 Go to next message
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
Re: Table Registation problem [message #396177 is a reply to message #343403] Sat, 04 April 2009 11:20 Go to previous message
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:
  


Current Time: Thu Mar 28 10:56:57 CDT 2024