You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to store number generated from autosequence in item's Extensible flexfield

in Product Master Data Management 2 comments

Summary:

How to store number generated from autosequence in item's Extensible flexfield

Content (please ensure you mask any confidential information):

Hi,

as described in the summary we want to store the number generated by an auto_sequence in a Item's Extensible Flexfield. The length of this attribute is then considered in the Secondary If of another item rule, used to generate Item Number.

Following the document https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=536487090725822&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id=2757803.1&_afrWindowMode=0&_adf.ctrl-state=1blsbc2rzb_4, we have created an EFF and created a rule to populate it.

The rule has the following details: Type = Assignments, Composite = No, Association Type = Attribute Group, Business Entities = Item, Return Type = Generic, Target Business Entity = Item, Target Attribute Group = Context of EFF, Target Attribute = EFF, Primary IF = assignedToCatalog(Catalog[AA].CategoryCode[BB]), Secondary IF = True, Return Value = auto_sequence("SEQBB"; 1; 1)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!