Release Notes for Item Cost Wizard

 

Version 1.2.6  (11-Feb-2011)

Allowed update of frozen costs for items where on hand quantity = 0

 

Version 1.2.5  (11-Feb-2011)

Changed download sql in statement on the elements not to use a distinct subquery on parent download as this was slowing down the query.
Removed references to category set/categories in element download if they are not part of the selection criteria
Fixed defaulting bug in download category to defaulting to the category from rather than the users default value.

Version 1.2.4  (02-Feb-2011)

Changed last po price and last inv price download sql to reference back to the header rather than to just the cost type.
Fixed LOV on download organization to validate it is a valid organization
Fixed item cost details download sql to join back on organization and item_id.

Version 1.2.3  (02-Feb-2011)

Re-imported Generic modules.
Added in download from spreadsheet functionality
changed toolbar LOV options order the same as bom and item wizards

Version 1.2.2  (13-Sep-2010)

Added DFF functionality to the wizard.

 

Version 1.2.1 (14-Jan-2011)

Made a change to the submit import program to disable the submit button if the cost type field is blank

 

Version 1.2.0 (09-Oct-2010)

Changed wizard to accumulate SQL before loading it and to reduce database SGA load. Requires version 1.2.0 of the package body to work.

Version 1.1.16 (14-Jun-2010)

Updated common modules with other MFG wizards
Fixed bug in Download form when you delete the item un handled error
Fixed bug where hide messages not working
Fixed set_status not clearing error message column when record valid/inserted
Fixed issue with submit cost update not returning organization properly
Fixed toolbar issue with insert template missing
Changed tool bar options to be more user friendly for upload types and validate vs validate commit.
Fixed issues with set status not working for update mode

Version 1.1.15 (24-May-2010)

Changed mfg_lookups_v to fnd_lookup_values_vl for 11.5.9 support.
Version 1.1.14 24-May-2010
Added support for uploading using european decimal point.
Fixed ambiguity were you can chose INSERT mode and then UPDATE cost.

Version 1.1.13 (10-May-2010)

Fixed bug where bind variable was next to a bracket causing Java IN OUT error.
Changed get_item_cost_info to return qty/po and inv prices even if the cost type for the item isn't setup
Version 1.1.12 27-Apr-2010
Fixed bug in Item Costs form where shrinkage not defaulting to 0 and lot size not defaulting to 1

Version 1.1.11 (25-Mar-2010)

Added functionality to delete updated records without having to download the records first.
Changed check for current load status to only take Interfaced and Accepted items into account.

Version 1.1.10 (18-Mar-2010)

Toolbar/RC Menu improvements
Version 1.1.9 17-Mar-2010
Fixed but where create turns into update.
Fixed return message for update not showing correctly
Fixed delete all transactions pressing no option deleted

Version 1.1.8 (05-Mar-2010)

Added functionality to update current costs keeping existing costs not being updated there. By adding to interface.

Version 1.1.7 (09-Feb-2010)

Changed design to validate all records before allowing any insert of costs.

Version 1.1.6 (09-Feb-2010)

Changed MSTK KFF to look at costing enabled flag instead of invoice enabled.
Updated MSTK KFF not to look at master org, using child org instead.

Version 1.1.5 (05-Feb-2010)

Added in check boxes to select the download type
Added element source type field to the wizard
Removed requirement that cost must not be zero
Fixed Issue where new item level record erroring when there is no item on that record.

Version 1.1.4 (30-Jan-2010)

Fixed download basis type bug with mfg_lookups (affecting 11.5.9)

Version 1.1.3 (25-Jan-2010)

Fixed Bug where material overhead didn't allow all 6 basis types.

Version 1.1.2 (25-Jan-2010)

Fixed Bug in shrinkage where test of value using clng causing anything over .5 to round up to 1
Changed Delete functionality so if you press delete for an item then all subelements for that item are deleted.
Changed Item level validation to return the correct error message when there is a validation fault rather than just Erroring without a reason.
Item Cost form wasn't defaulting based on rollup to what was on the spreadsheet.

 

Version 1.1.1 (25-Jan-2010)

Fixed Gensupport SetStatus not working correctly
Fixed default activity passing value instead of ID
Changed refresh of costs updated to excl the cost value as that would only work for single element cost changes.
Fixed bug in based on rollup not using shrinkage when it is based on rollup.

Version 1.1.0 (05-Jan-2010)

Changed upload to only upload records when they have passed validation
Upgraded CstSupport, InvSupport to be object based rather than record based
Fixed bug where activity not erroring when activity isn't found
Fixed issue with download not downloading DFF's correctly.

Version 1.0.4 (19-Dec-2009)

Updated KFF and DFF modules
Fixed bug in validate header values populating current row not header row

Version 1.0.3 (05-Dec-2009)

Created form to choose request to run
Added view requests form
Updated common modules

Version 1.0.2 (22-Oct-2009)

Ignored records not being reset.
Refresh not taking rows below the header into account causing it not to validate against the org/item/cost type
Fixed activities not loading for sub element
Added check of concurrent request against refresh functionality
Added limit of 10 decimal places to loads due to size inconsistency between oracle and excel.

Version 1.0.1 (24-Sep-2009)

Updated import to delete from interface table if Import is successful.
Added in sum by sub element when downloading costs

Version 1.0.0 (2-Sep-2009)

Initial versionDelete function wasn't deleting errored rows
Basis field error incorrectly going to subelement field
Created form to submit cost update if user has functional access