Announcement

Collapse
No announcement yet.

BNG for Order

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • BNG for Order

    I have two systems sending order into OTM. I want to setup a BNG to create Order base ids based on the information from the transorder
    I have a refnum(JDE_SOURCE_SYS) associated that will give me the identity of the sorce system. So if my source system are A1, A2 and my order id is 1000. I want to create two orders in the system
    A1-1000
    A2-1000.
    I have written the below BNG rule, but it is not returning the required value.

    {r*:id=1:xml=REFNUM/JDE_SOURCE_SYS}-{r*:id=2:xml=BASE}

    How do i fix this?

    Thanks

  • #2
    Re: BNG for Order

    Hi Surender,
    1. Change your BN rule to {r*:id=1:xml=REFNUM/DOMAIN.JDE_SOURCE_SYS}-{r*:id=2:xml=BASE}
    2. Make this rule definition as default
    3. Deactivate the original BN RULE for order base in the system - remove default checkbox from it (There cannot be more than more default BN rule for same business object)
    Nipun Lakhotia
    Manager, EY

    Comment


    • #3
      Re: BNG for Order

      Thanks nipunlakhotia

      I entered it as you have mentioned and used the Test BNG Rule options in actions but it just gives we a - .
      Do I need to make any more changes.

      Surender

      Comment


      • #4
        Re: BNG for Order

        Also this is the error in the logs
        Warning GLog Trying to create elementName :., Exception: org.w3c.dom.DOMException: INVALID_CHARACTER_ERR: An invalid or illegal XML character is specified. [RMICallHandler-117]

        Thanks

        Comment


        • #5
          Re: BNG for Order

          Are you sure about this format - {r*:id=2:xml=BASE} ? This might be giving that error.

          or

          alternatively, you can capture Order ID also as some refnum -ORDER_BASE_ID and edit BN rule as
          • {r*:id=1:xml=REFNUM/DOMAIN.JDE_SOURCE_SYS}-{r*:id=2:xml=REFNUM/DOMAIN.ORDER_BASE_ID}
          Nipun Lakhotia
          Manager, EY

          Comment


          • #6
            Re: BNG for Order

            I have tried this

            {r*:id=1:xml=REFNUM/CRP.JDE_SOURCE_SYS}-{r*:id=2:xml=REFNUM/CRP.SO}

            Same issue. When I test it, just gives a -

            Does this require some property file setup?

            Thanks

            Comment


            • #7
              Re: BNG for Order

              Attaching the configuration screenshot
              Attached Files

              Comment


              • #8
                Re: BNG for Order

                I hope you have created JDE_SOURCE_SYS and SO as Order base refnum qualifiers in CRP domain.

                I have tested this in my domain and it is working fine.
                Nipun Lakhotia
                Manager, EY

                Comment


                • #9
                  Re: BNG for Order

                  I have created the refnums and they are appearing on my order base as well. The thing is it works for Order Release but not for Order Base. I am using BN Type of ORDER_BASE_XID and BN Context id of INV_PARTY_CONTEXT_FOR_ORDER_BASE. Is that correct?
                  Thanks

                  Comment


                  • #10
                    Re: BNG for Order
                    1. Uncheck default check-box from BN Rule ID- ORDER_BASE_XID.DEFAULT
                    2. Use BN Type ID as ORDER_BASE_XID
                    3. BN Context ID as EMPTY_CONTEXT
                    Nipun Lakhotia
                    Manager, EY

                    Comment


                    • #11
                      Re: BNG for Order

                      While my sequence number worked
                      I have another issue now

                      The sequence is generating fine when I do a copy order base. But when the transorder is coming in via integration ,since the refnum is not registered when Order base id is created, the system is just taking a "-".
                      As per Oracle refnums cannot be used while generating Order base ids.

                      Has anyone faced such an issue. Is there a workaround?

                      Thanks

                      Comment


                      • #12
                        Re: BNG for Order

                        can you share your incoming transorder xml?
                        Nipun Lakhotia
                        Manager, EY

                        Comment


                        • #13
                          Re: BNG for Order

                          The transorder
                          Attached Files

                          Comment


                          • #14
                            Re: BNG for Order

                            But when we try to upload transorder xml without ORDER_BASE_GID, system shows error and does not upload the xml.

                            Transmission Error:
                            <MessageText = THE REQUIRED ELEMENT TransOrderHeader.TransOrderGid IS MISSING>

                            How are you able to upload such xml?
                            Nipun Lakhotia
                            Manager, EY

                            Comment


                            • #15
                              Re: BNG for Order

                              With <TransactionCode>I</TransactionCode> we do not need an order number. I just reporcessed the transorder in my system and it get uploaded. I generated with order number CRP.20090528-0001

                              Comment

                              Working...
                              X