ERPstuff - Oracle EBS Community

which product's family pack?

1. Financials Family Pack using
select
substr(bug_number,1,10) BUG,
decode(bug_number,
'1807809','11i.FIN_PF.A',
'2218339','11i.FIN_PF.B',
'2380068','11i.FIN_PF.C',
'2629235','11i.FIN_PF.D',
'3016445','11i.FIN_PF.D.1',
'2842697','11i.FIN_PF.E',
'3153675','11i ...

maybe this is not a perfect idea........share to everyone

select * from (
select sno
from num
where sno <= 5
order by sno asc)
union all
select * from (
select sno
from num
where sno > 5
and sno <= 10
order by sno desc)

maybe you should check your DB's status??

ORA-01034: ORACLE not available
Cause: Oracle was not started up. Possible causes include the following:
- The SGA requires more space than was allocated for it.

- The operating-system variable pointing to the instance is improperly defined.

Action ...

Oracle version is 9.2.0 when I installed EBS 11.5.10.2
It contain some of test data in db.
you needn't insert any data before you use it....

It just let you know ...what situation will change your configragion.

just clone successful on 11.5.10.2

the following parameters to your sqlnet.ora file:
tcp.validnode_checking = yes
tcp.invited_nodes = (www.aq.com,172.16.1.4)
tcp.excluded_nodes = (199.16.1.21)

The first line enables this features. The invited nodes is a list of the hosts, either DNS name or IP address, that are allowed to connect ...

I heard Quest Spotlight .....

it's a good tool....

but I am trying it ......