Recently I came across a very annoying issue. Every time we changed the bill-to or ship-to address on the order header the 'Date Ordered' field would re-default to SYSDATE, messing up all the sales reporting.
A short research on metalink revealed note 748269.1 which recommends updating package OE_Dependencies_Extn and changing some seeded dependencies. To make a long story short we did that ending up with a 3 weeks long P1 issue that did not seem related in any way..
There is, however, a trivially simple way of fixing this problem using the OM defaulting rules:
(N) OM -> Setup -> Rules -> Defaulting
Query OM header, scroll down to Ordered Date and change the seeded defaulting rule to:
This will make the date default to itself first and to sysdate only if it was NULL in the first place.
No comments:
Post a Comment