Distribution - JDE1 (MOSC)

MOSC Banner

Populating new Price overrides

edited Jun 26, 2015 11:45AM in Distribution - JDE1 (MOSC) 2 commentsAnswered ✓

9.1

Doing a mass update of over 600 price overrides.

Data extracted from R4072, W4072B.

P4072 Price Adjustment Detail Revisions Program:

Changing "Factor Value Numeric"

Changing "Effective Date"

Using Cust Grp 1 (Complex Cust. Price groups), 2nd item number, Address Number (customer)  to identify records.

The F4072 will work but need to get the Cust grp Key ID from the F40942.

The programs I found based on level of detail for data would be manually intensive.

Thinking SQL.

Thanks - Debbie

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