EBS Customizations (MOSC)

MOSC Banner

using custom.pll

edited Oct 30, 2011 9:26PM in EBS Customizations (MOSC) 6 commentsAnswered
Hi,
working in oracle applications 11i.
need to customize inventory transactions form INVTTMTX.I have a requirement to alert the user with a message whenever the issuing transaction invalidate a business rule/ data entered in DFF.
I have been advised to use CUSTOM.pll
The data I need to check is in mtl_material_transactions:

  1. transaction_type_id
  2. organization_id
  3. subinventory_code
  4. inventory_item_id
  5. transaction_quantity
  6. attribute3
  7. attribute4


I have created a boolean function that returns true if need tl alert the message.

I need guides on how to use CUSTOM.pll.

  • should i place the code/call the function(parameters) in procedure event(event_name) and send the message to the user when function = true?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center