otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire

Go Back   Oracle OTM / G-Log GC3 Community Support > OTM / G-Log - Functional Topics > Workflow
Reload this Page

Questions about BN Number Generator and Shipments


Workflow Configuring Workflow components - including Agents, Milestones, Notifications Auto Data Assignment and Events.

Tags:

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old October 24th, 2007, 04:05
Senior Member and Blogger
 
Join Date: Dec 2006
Location: Singapore
Posts: 147
Blog Entries: 5
Thanks: 5
Thanked 11 Times in 10 Posts
Groans: 0
Groaned at 1 Time in 1 Post
Rep Power: 2
ianlo is on a distinguished road
Send a message via AIM to ianlo Send a message via Skype™ to ianlo
Questions about BN Number Generator and Shipments

Hi everyone,

I have a couple of questions about BN generators and shipments:

1) Why are shipment IDs not generating in exact running sequence?
2) Is the Shipment ID BN generator shared across all shipment object types (Buy/Sell/Group/Secondary Charge)
3) How can we have a different BN generator for Buy and Sell shipments?"

Appreciate any help on this!

Thanks!
Ian
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old October 24th, 2007, 09:21
Junior Member
 
Join Date: May 2007
Location: Singapore
Posts: 26
Thanks: 0
Thanked 1 Time in 1 Post
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
satya_m is on a distinguished road
Re: Questions about BN Number Generator and Shipments

Hi Ian,

I haven't worked on BN Generator anytime,but a quick look at the code, this is what i found out. Please correct me if i am wrong.

1) Why are shipment IDs not generating in exact running sequence?

There is a propery in the glog.base.properties - 'glog.server.bngenerator.oracleSequence' . While generating the xid, the BNEngine looks for this property, and if its not definied, it generates the xid using the BNSequence.

I am not exactly sure why an exact running sequence is not getting generated, but when a shipment xid is generated, the BNEngine makes an entry into the BN_SEQUENCE talbe, updating the currValue. So when a shipment is getting generated next time, it picks up the currValue from this table for this Shipment BN Rule and generates a new sequence number for the xid.

2) Is the Shipment ID BN generator shared across all shipment object types (Buy/Sell/Group/Secondary Charge)

For both 'Buy' and 'Sell' its the same Shipment ID BN generator.

Group has a seperate BN GEnerator. Not sure about Secondary Charge.

3) How can we have a different BN generator for Buy and Sell shipments?

Not sure if this is possible. Its the same set of classes used to generate the shipment,both buy and sell. Its the shipmentBean that gets invoked and this bean generates the PK irrespective of the perspective. Even if you see the BN Rule, there is only one rule defined for Shipment. No seperate rules for Buy and Sell.

Hope this info helps.

Thanks,
Satya.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following User Says Thank You to satya_m For This Useful Post:
ianlo (October 29th, 2007)
  #3 (permalink)  
Old October 24th, 2007, 15:17
Senior Member and Blogger
 
Join Date: Nov 2006
Location: San Diego, CA
Posts: 76
Blog Entries: 2
Thanks: 0
Thanked 18 Times in 17 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 2
AlejandroBarba is on a distinguished road
Re: Questions about BN Number Generator and Shipments

Hi Ian,

About the running sequence, we have not experienced any problems with the running sequence that you mentioned. I might be able to get a better idea of the problem if you let me know the Rule Definition Syntax.

About how to have different BN Rules for Buy and Sell Shipments; we have achieved this by having a parent domain for the Buy Shipments and one child domain for each customer where the Sell Shipments are created. Every Domain has a different Shipment BN Rule.

Hope this helps,

Alejandro B.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old October 29th, 2007, 06:16
Senior Member and Blogger
 
Join Date: Dec 2006
Location: Singapore
Posts: 147
Blog Entries: 5
Thanks: 5
Thanked 11 Times in 10 Posts
Groans: 0
Groaned at 1 Time in 1 Post
Rep Power: 2
ianlo is on a distinguished road
Send a message via AIM to ianlo Send a message via Skype™ to ianlo
Re: Questions about BN Number Generator and Shipments

Hi everyone,

Thanks for your replies! If Buy and Sell both share the same shipment ID BN generator then it would make sense that there would be skips in the Buy shipment IDs and Sell shipment IDs

Thanks for all your replies!

Ian
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Location and Service Provider Business Number new_otm Execution 0 February 6th, 2008 14:58
Customizing the Sequence Number. skunniyur Branding, Screen Sets, XSL/CSS and Translations 1 December 4th, 2007 10:20
Business Number Generation neelimachenta Execution 5 June 25th, 2007 18:57
V45 Update/Migration Questions Part 2 CDrozdowski Installation and Upgrades 1 June 7th, 2007 19:28
[SOLVED] Shipment events copied from the buy shipments to the sell shipments? runinord Freight Forwarding 1 June 7th, 2007 16:16



All times are GMT. The time now is 14:30.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37