My Oracle Support Banner

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

Last updated on JULY 09, 2021

Applies to:

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

Purpose

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. 

Scope

 

Details

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
Purpose
Scope
Details
 Setup
 Price Adjustment Definition (P4071)
 Price Adjustment Detail Revisions (P4072)
 Price Variable Table (P4075)
 Example
 Purge Price Variable Records from F4075 and UDC 40/VT
References

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