Package Body Version - This is the product packages included in the current version of the wizard. The Minimum version (shown in brackets) is the lowest version of the package required to enable the wizard to function.
Wizard Version
|
1.3.06 (12-Mar-2012)
|
|
Package Body Version
|
1.2.0 (Minimum 1.2.1) |
-
Changed message to Inserting into interface when validation completed.
-
Fixed bug when first trying to load a record causing no load to occur.
-
Updated common modules.
-
Added Cancel Button Functionality to the wizard.
Version 1.3.05 (12-Mar-2012)
Changed refresh to load all lines into a collection before validating.
Version 1.3.04 (29-Feb-2012)
Fixed issues with interface downloader not working.
Changed refresh to ignore errored/validated lines and only look at all other lines where there is an interface ID
Version 1.3.03 (28-Feb-2012)
Fixed issues with downloader not working.
Improved design to generate multiple group ids if multiple orgs/cost types loaded at the same time.
Version 1.3.02 (11-Jan-2012)
Fixed download issues found in testing
Changed wizard to allow duplicate sub element/activity to load only if value is not duplicated.
Version 1.3.01 (11-Jan-2012)
Updated wizard element to check if Occurrences/item units on the form.
Version 1.3.00 (11-Jan-2012)
Changed Wizard to be object based.
Added support for activity Occurrences and item units
Changed refresh to verify loaded cost is the same as the wizards cost
Version 1.2.15 (16-Dec-2011)
Added defaulted flag to item cost header.
Version 1.2.14 (14-Dec-2011)
Fixed multiselect downloads overriding each other for multiple orgs.
Fixed single org loads not downloading due to multiselect change
Found bug when in create mode it checks material cost only rather that total item cost value.
Version 1.2.13 (09-Dec-2011)
Added in multi-select function on the download current costs form.
Version 1.2.12 (30-Nov-2011)
Added new Concurrent request query for performance issue.
Version 1.2.11 (17-Oct-2011)
Added in refresh to allow for error status 4 in the interface table.
Version 1.2.10 (05-Sep-2011)
Changed downloader to use MTL_SYSTEM_ITEMS_B_KFV instead of MTL_SYSTEM_ITEMS_KFV for R12.
Version 1.2.9 (05-Sep-2011)
Added in check to make sure the same sub element is not being loaded within an item.
Version 1.2.8 (19-Aug-2011)
Updated common modules
Fixed Object Runtime Issue with the Header form.
Version 1.2.7 (11-Feb-2011)
Fixed validate item bug not loading based on rollup = No value, only 'N' value.
Fixed item form not validating item exists on opening.
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 (04-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 (24-Jan-2011)
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
