ERPstuff - Oracle EBS Community

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,

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 ...

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 ...