About Me

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

17 Responses to “About Me”

  1. joydip mukhopadhyay Says:

    i want some meterials on OM set up.can you provide me so?

    regards,

    joydip mukhopadhyay

  2. Syed Adil Says:

    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

  3. roshan jameer Says:

    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

  4. tarannum Says:

    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

  5. Ahmad Bilal Says:

    to send the notification you can use oracle alerts

  6. Advait Deo Says:

    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

  7. Ahmad Says:

    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.

  8. Advait Deo Says:

    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

  9. Ahmad Says:

    Dear Advait Deo,
    it is a Metalink Note so say Thanks to oracle metalink :)

    let me do it then i will update accordinlgy

  10. advait Says:

    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

  11. Senthil Says:

    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 ?

  12. Ahmad Bilal Says:

    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

  13. Amirali Says:

    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.

  14. Ahmad Bilal Says:

    By Using Form Personalization you need set property ALTERABLE_PLUS (APPLICATIONS COVER) to false…

  15. Krishna Says:

    Ahmad
    Good blog ….Thanks it was really helpful.

    Regards
    Krishna

  16. Kumar Says:

    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.


Leave a Reply