My Oracle Support Banner

E1: 45: Variable Tables in Advanced Pricing (P4075/P4072/P4071) (Doc ID 1363180.1)

Last updated on APRIL 18, 2024

Applies to:

JD Edwards EnterpriseOne Advanced Pricing - Sales - Version XE and later
Information in this document applies to any platform.


Use a Variable Table where there is a requirement to track a price that changes frequently, for example in the petroleum products or precious metals industries. The Variable Table functionality is available in both Sales and Procurement adjustments, and can be used on its own using Basis Code 6, or within a formula adjustment (Basis Code 7). The technical brief on formula functionality (1357902.1) contains a section on using Variable Tables.

In many cases the result of the Variable Table will be used as a base price for an item, overriding or substituting a price held in the F4106 table. In these instances, ensure the "Override Price" box is checked in the Price Adjustment Definition. 




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Price Adjustment Definition (P4071)
 Price Adjustment Detail Revisions (P4072)
 Price Variable Table (P4075)
 Purge Price Variable Records from F4075 and UDC 40/VT

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.