OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » How to make new item code automatically

Home » Applications » Oracle Fusion Apps & E-Business Suite » How to make new item code automatically (11.5.10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to make new item code automatically [message #447658]

Wed, 17 March 2010 02:36

baonam
Messages: 5
Registered: February 2010
Location: Incharge

Junior Member

Dear all,

I want to make new item code automatically.
Please guide me the way to make it.

Thanks you so much.
Kha Han.

Report message to a moderator

Re: How to make new item code automatically [message #448571 is a reply to message #447658]

Wed, 24 March 2010 02:08

westwolf2009
Messages: 14
Registered: March 2010

Junior Member

hi,
you can defince a sequence and automatically create the new item code on save the data first

Report message to a moderator

Re: How to make new item code automatically [message #448593 is a reply to message #448571]

Wed, 24 March 2010 03:21

baonam
Messages: 5
Registered: February 2010
Location: Incharge

Junior Member

Hi!
Thanks you for your replay.
But I don't know how to do it?
Could you please giude me the steps to make it?

Thanks and Best Regards,
baonam

Report message to a moderator

Re: How to make new item code automatically [message #448704 is a reply to message #448593]

Wed, 24 March 2010 20:51

westwolf2009
Messages: 14
Registered: March 2010

Junior Member

first :define a item code rule ,the item codes combined with sequence and characters.

second:you open the item define form ,open the form-level trigger
'POST-DATABASE-COMMIT',in there to add your custom code

eg: select xxx_seq.next_val||'item code rule'
into XXXX.XXXX FROM DUAL

Report message to a moderator

Re: How to make new item code automatically [message #448708 is a reply to message #448704]

Wed, 24 March 2010 21:53

baonam
Messages: 5
Registered: February 2010
Location: Incharge

Junior Member

Hi,

Thanks you for you reply.
To make new item code, we have a form to make it.
But, now, every day, I have to make 100 items/day by using a form make new item code. It take many time.
So, I want to write a program which I can make many item as the same time.
I have the begin data to make item (catagory, catalog, UOM, item type, organization_id...), but Idon't know the process of data to make item
Please help me.
Thanks
baonam.

Report message to a moderator

Re: How to make new item code automatically [message #448931 is a reply to message #448708]

Thu, 25 March 2010 20:43

westwolf2009
Messages: 14
Registered: March 2010

Junior Member

hi,

do you want to create new item auto?

my msn is:ltp200567@hotmail.com

maybe we can discuss it

Report message to a moderator

Previous Topic:	Project Accounting
Next Topic:	Need help on Custom.pll

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 01:42:20 CDT 2025