Order Management

Get Involved. Join the Conversation.

Topic

    Ekansh Jain
    How to default the "Requested Date" to...
    Topic posted August 29, 2019 by Ekansh JainBronze Medal: 1,250+ Points, tagged Global Order Promising, Order Management, Order Management Analytics, SCM, Supply Chain Financial Orchestration, Supply Chain Orchestration, Tip, White Paper 
    40 Views, 3 Comments
    Title:
    How to default the "Requested Date" to Syadate+1 at Sales Order
    Summary:
    How to default the "Requested Date" to Syadate+1 at Sales Order
    Content:

    Hi,

    While creating the sales order, if the "Requested Date" is not updated for a future date, the system gives error while submitting the Sales Order.

    Therefore, our users have decided to update the "Requested Date" manually to future date.

    Is there any way, to default the "Requested Date" field with "Sysdate+1" value?

    i.e. Requested Date = Sysdate+1

    Thanks

    Ekansh

    Comment

     

    • Shyam Singh Patel

      Hi Ekansh,

      please see the following note ID.

      How to Create a Processing Constraint Which Restricts Request Ship Date Less Than SYSDATE? (Doc ID 2259112.1)
      How to default Schedule Ship Date from Requested Ship Date (Doc ID 2190769.1)

      Make Sure Either SSD or SAD should Equal or greater than Sys date then RD issue will be no more.  server time will be UTC always. hence you need to put the default timezone profile for all users.

      Regards
      Shyam

      • Ekansh Jain

        Hi Shyam,

        Thanks for responding.

        So do you mean:

        Make Sure Either SSD or SAD should Equal or greater than Sys date then RD issue will be no more.  server time will be UTC always. hence you need to put the default timezone profile for all users.

        Ekansh - This issue is occurring because schedule ship date is equal to Sys date and not requested date?

        Basically just by defaulting the timezone profile is going to help instead of creating any default rule or processing constraint?

        Thanks

        Ekansh

        • Shyam Singh Patel

          Hi Ekansh,

          yes, the timezone will resolve the issue.

           

          How To Activate Different Time Zones in Fusion Application Cloud Instance (Doc ID 2155517.1)
          Different Dates Between BI And Oracle Sales Cloud OR How to convert Date in BI to the Timezone of the logged-in user (Doc ID 2391247.1)
          Oracle Sales Cloud: User Preferred Time Zone Setting in Business Intelligence (BI) (Doc ID 1671494.1)
          How To Setup User Preferences In Bulk By Administrator In Fusion Applications ? (Doc ID 2092073.1)
          Manage Planning Source Systems - Destination System OPS Time Zone (Doc ID 2361755.1)
          How do I change the timezone setting of my Oracle Cloud Database? (Doc ID 2165725.1)
          How To Change Time Zone For OPS Source System (Doc ID 2240925.1)
          https://community.oracle.com/message/14118954#14118954  -  How to return in Web Services the users timezone
           
           
          Navigator > Setup and Maintenance > Manage Administrator Profile Values > FND_TIMEZONE
           
          Set User General Preferences --- for All Users 
          Manage Time Zones   ---- Select the Correct Timezone UTC - Coordinated Universal Time
           

          https://community.oracle.com/thread/4097199

          Set Default Time Zone For All Users in Fusion Applications (Doc ID 1630493.1)
          How to Change the Preferences for All the Users? (Doc ID 1501663.1)

          Regards
          Shyam