ERPstuff - Oracle EBS Community

PlaceHolder is used in Reports just to retain some value. If any value need no calculations then can be placed in holder at report level.

Regards,
M.Omer Javed
ERP Technical Consultant
Mob:+923214647529/ +923004479693

select DEPTNO , dname, loc from
(
select dname,DEPTNO , loc ,
rownum sl
from dept order by deptno desc
) order by case when sl=2 then 0 else sl end;

Is it resolves the issue Najam?

Regards,
M.Omer Javed
ERP Technical Consultant
Mob:+923214647529/ +923004479693

Nice................. [:)]

Regards,
M.Omer Javed
ERP Technical Consultant
Mob:+923214647529/ +923004479693

Any one knows the solution to build a protection layer on database that only Specified IP Addresses can connect to the database?

Environment:
9i database (Protection to be applied)
Clients: 8i or 9i


Regards,
M.Omer Javed
ERP Technical Consultant
Mob:+923214647529/ +923004479693

Dear, Here is the work way round to get the required results. alter table dept add seq_no number; update dept set seq_no=1 where deptno=30; select Deptno,DName from dept order by seq_no,deptno desc; DEPTNO DNAME ---------- -------------- 30 SALES 40 OPERATIONS 20 RESEARCH 10 ACCOUNTING NEW YORK Rega...

By using Matrix Report formating, you can pick as many columns as you want from the database on the bases of parameters.
You should take date period as parameter not the session #s.

Regards,
M.Omer Javed
ERP Technical Consultant
Mob:+923214647529/ +923004479693

Thanks Alot, it Worked

Regards,
M.Omer Javed
ERP Technical Consultant
Mob:+923214647529/ +923004479693

Hi, I have a scenerio in which we have to drop and then ReBuild the table. We have done it via a script file. But All the reports Built on that table have to recompile. Is there any other way round so that we can run REP file without ReCompilation or Command line script for it? Regards, M.Omer Javed...

Backup of Database (export file) is being made via batch file which is executed from windows scheduler.
Is there any way to AutoZip the .DMP file from command line?

Regards,
M.Omer Javed
ERP Technical Consultant
Mob:+923214647529/ +923004479693

As there are lot of ERP Solutions available in the global market other than Oracle like SAP, PeopleSoft etc.....- Plus many companies are working for their own customized solutions. So, Forum should have discussion Main topics for these too. Regards, M.Omer Javed ERP Technical Consultant Mob:+923214...