Search found 3 matches

by OracleAppsTechno
Wed Apr 01, 2009 1:35 am
Forum: HCM (Human Capital Management)
Topic: How to enter employees ?
Replies: 3
Views: 1214

Dear Mr. Fayyaz,

to Enter 900 or 2000 employees this will enter through HRMS API's and if you have the Technical Background to execute the query in SQL then its easy other wise only Oracle Apps Technical Consultant or your DBA will do this for you...


Regards,
by OracleAppsTechno
Tue Nov 18, 2008 1:46 am
Forum: Oracle Databases
Topic: DBMS_Alert to perform action and emailed us Back.
Replies: 1
Views: 1571

DBMS_Alert to perform action and emailed us Back.

Dear all, I want the Database script or Alert to check the Table usage at each mount point and if the table space MINEXTENTS and MAXEXTENTS become less the given figures (at any mount point) it should send an email to my email id. I want the script or alert to exactly compare the value Table Space. ...
by OracleAppsTechno
Tue Nov 11, 2008 5:11 am
Forum: Reports (Only Oracle Apps Reports)
Topic: Purchase Order Total?
Replies: 3
Views: 2985

First You have to create Formla Column and in that formula column you have to define.... like this begin DECLARE COMM_IN_CHAR VARCHAR2(17); TYPE RecType IS RECORD (Word VARCHAR2(20)); TYPE TableType IS TABLE OF RecType INDEX BY BINARY_INTEGER; Words TableType; RETURN_WORDS VARCHAR2(500); begin Words...