BNG for Order

[surender Member Find all posts View Profile Close surender]

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

[nipunlakhotia Senior Member Find all posts View Profile Close nipunlakhotia]

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)

[surender Member Find all posts View Profile Close surender]

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

[surender Member Find all posts View Profile Close surender]

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

[nipunlakhotia Senior Member Find all posts View Profile Close nipunlakhotia]

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}

[surender Member Find all posts View Profile Close surender]

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

[surender Member Find all posts View Profile Close surender]

Re: BNG for Order

Attaching the configuration screenshot

[nipunlakhotia Senior Member Find all posts View Profile Close nipunlakhotia]

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.

[surender Member Find all posts View Profile Close surender]

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

[nipunlakhotia Senior Member Find all posts View Profile Close nipunlakhotia]

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

[surender Member Find all posts View Profile Close surender]

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

[nipunlakhotia Senior Member Find all posts View Profile Close nipunlakhotia]

Re: BNG for Order

can you share your incoming transorder xml?

[surender Member Find all posts View Profile Close surender]

Re: BNG for Order

The transorder

[nipunlakhotia Senior Member Find all posts View Profile Close nipunlakhotia]

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?

[surender Member Find all posts View Profile Close surender]

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