Ahmad Bilal Karachi, Pakistan I am currently working as a Techno-functional Consultant in a Home Appliances Manufacturing company in Pakistan called Dawlance, I have more then 5 years experience of oracle applications in different areas, my proviso work was with a Textile and Cement Manufacturer named Kohinoor Maple leaf Group , I also have a good experience on oracle collaboration suite 10g and before that I worked as Oracle developer in software house named Logical Solution.i am working as forums moderator for erpstuff.com contributing articles on different websites like oracle.anilpassi.com. I also am working as contractor for oraclecontractors.com


December 10, 2007 at 12:23 pm
i want some meterials on OM set up.can you provide me so?
regards,
joydip mukhopadhyay
December 20, 2007 at 1:26 am
Hello Bilal, Eid Mubarak
I am in need of a little help. I have studied Oracle financials for quite some time. Tried to get as much knowledge as possible but unfortunately I do not have practical experience of a real time world. Even then, I got a job offer here in Texas USA.
The poject details are not very complicated but I do not have confidence. I need little tips and tricks to handle issues.
Is it possible to have your working email address or phone number in Karachi ? I will be very grateful to you.
Adil
January 1, 2008 at 5:25 pm
Hi Bilal,
Right now i am in migration project.please tell me about Labour,Time management,Ap,Om modules. so that i can proceed to my work.Please send me some material if you have on this modules…
Thanks
roshan
January 24, 2008 at 3:15 pm
Hi bilal,
There is a small requirement in Oreder management…
the thing is If there are any order holds we have to send the notifications to the customers trough fax/email…i konw the base tables and iam able to query those orders/custname..etc…. but guide me how to sned the notification..thank you and its a urgent requirement
February 14, 2008 at 8:37 am
to send the notification you can use oracle alerts
May 19, 2008 at 10:47 am
Hi Ahmed,
You have a real good blog. Thanks for posting so much information.
I have 1 doubt regarding collaboration Suite. It would be really great if you can help me.
I have installed Oracle Collabsuite 10g and during installation given SMTP port as 30. Now after installation I want to change the port from 30 to 25. Is there any way to do the same. I tried many options and also referred to documents, but did not get any help. I also posted the same in Oracle Forum
http://forums.oracle.com/forums/thread.jspa?threadID=648602&tstart=0
, but did not get any reply.
Thanking in advance.
Regards,
Advait Deo
May 19, 2008 at 4:26 pm
Perform the following steps:
1.
Open the Oracle Email listener configuration file as follows:
*
Open $ORACLE_HOME/network/admin/listener.ora
*
Locate the ESSMI entry for SMTP_IN in the configuration file.
*
Change the port number for the ESSMI entry to the desired value and save the file.
*
Stop and restart the Oracle Email listener.
2.
Update the Oracle Email process parameter as follows:
*
Start Directory Manager (for Oracle Internet Directory) and log in as orcladmin.
*
Navigate to:
* Entry Management
* cn=OracleContext
* cn=Computers
* cn=your_hostname
* cn=mtier
* cn=EMailServer
* cn=mailProcessConfig
*
Check entries for the different processes. For example:
cn=your_hostname:UM_SYSTEM:smtp_in
*
Click Process Entry in the Navigator.
*
In the Properties tab, update the value of the orclmailport attribute to the desired value.
*
Click Apply to save the changes.
3.
Reinitialize the SMTP process as follows:
*
Log in as the ias_admin user in the Enterprise Manager Web site at:
http://hostname.domain:1810/
*
Navigate to the Middle-tier instance and select System Components, and then Unified Messaging.
*
Select the Unified Messaging Inbound SMTP process and click Reinitialize.
Note: You can also use the oesctl command to reinitialize the SMTP process from the command line.
May 20, 2008 at 5:28 pm
Hi Ahmad,
Thanks a lot for the detailed steps. I followed the steps exactly, but I am still facing the issue with mails.
I have stopped sendmail OS level process running on port 25 and then made changes in listener.ora file on apps side. Bounced the listener. Made changes in OID. The orclMailPort parameter was Null, I put a value of 25 in that field.
However , since I am using collabsuite 10g, I was not able to find “Unified Messaging” in System Components and was not able to re-initialize. So I bounced the entire apps tier.
Still same issue is persisting. Could you please suggest anything on this. Am I missing some thing.
Thanks again for your help!!
Regards,
Advait Deo
May 21, 2008 at 9:56 am
Dear Advait Deo,
it is a Metalink Note so say Thanks to oracle metalink
let me do it then i will update accordinlgy
May 23, 2008 at 7:16 pm
Hi Ahmed,
Finally got the way to change SMTP port in OCS10g
http://advait.wordpress.com/2008/05/23/changing-smtp-port-in-oracle-collabsuite-10g/
Regards,
Advait Deo
May 27, 2008 at 11:46 am
Good One.
February 24, 2009 at 12:30 pm
Hi Belal
How to map multiple position hierarchy in single operating unit. ie materials dept req should go material manager, po req should go to purchase manager. and how does know the system wher it should go ?
March 1, 2009 at 2:48 pm
Hierarchy will be like this
CFO Level 1
Department Manager Level 2 PO and Material Manager
below them you can assign respective department resource
In Simple it should be a Top Down Tree
March 5, 2009 at 10:46 am
hey ahmed,
can you tell me how to set mover order number to auto numbering and lock it. for time been we are having open field if mannual is entered then its fine else it generates autonumber. now from where does this sequence is maintain.
March 5, 2009 at 11:16 am
By Using Form Personalization you need set property ALTERABLE_PLUS (APPLICATIONS COVER) to false…
March 23, 2009 at 3:39 am
Ahmad
Good blog ….Thanks it was really helpful.
Regards
Krishna
July 10, 2009 at 4:36 am
I have a question related to Oracle Advanced Pricing; Here is the Scenario.
Have customers who are in the retail space. Need the capability to APPLY DISCOUNTS at Sales Order Level;For example sales order so-ord-123 has 5 lines (l1, l2, l3, l4, l5) with an order total of $1000. Need to apply Order Level discount based on a) number of items ordered b) total quantity of items ordered c) total value of sales order; This discount should be re-calculated during shipping (based on actual items shipped and quantities shipped)
Is it possible to do the above using Oracle Advanced Pricing?
If a discount were to be applied, can the discount be made visible in Oracle Receivables? This is not mandatory but Sales Order Level Discounting is…..
Kindly respond at the earliest.
Thanks.