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
|
2.0.17 (27-Mar-2012)
|
|
Package Body Version
|
1.0.14 (Minimum 1.0.13) |
-
Fixed bug where named users could not be added
Wizard Version
|
2.0.16 (31-Jan-2012)
|
|
Package Body Version
|
1.0.14 (Minimum 1.0.13) |
-
Removed rounding from Distribution Total it was causing a problem when the Line Quantity had more than 10 Decimal places
Wizard Version
|
2.0.15 (14-Dec-2012)
|
|
Package Body Version
|
1.0.14 (Minimum 1.0.13) |
-
Added approval to the ChangeAPI.
Version 2.0.14 (22-Nov-2011)
Changed Icon for approval settings.
GL Encumbered date: added to distributions download
GL Encumbered date: added to forms
Version 2.0.12 (22-Aug-2011)
Fixed bug in BPA upload. BPAs would continue to upload when cancel
was chosen from validation message.
Version 2.0.11 (17-Aug-2011)
Added Approval Status column to Blanket Purchase orders.
Version 2.0.09 (09-Aug-2011)
Fixed bug in Standard PO upload. If the Head ID cell had a space in it the header would not load.
frmSubmitRequest - now disabling Submit button after a request has been submitted.
Added Approval method control form.
Version 2.0.08 (08-Aug-2011)
Removed conditional formatting from set_status for 2007+ speed reasons.
Imported latest generic code v171
Imported latest Request Display code.
Version 2.0.07 (21-July-2011)
Outside processing - changed linetype query to include outside processing
Removed BPA columns from Standard PO sections
Updated queries so StatusBar doesnt display false
Added MTLCategorySetID to POWConfigInfo
Changed ItemQuery to run off inventory org. Have traced the form in r12 tremor and it uses inventory org - organizaitons;financial system options
Set PO_ACTION_ALLOWED = False, PO_ACTION_ALLOWED_Done = False in post_login_events because changing responsibility or logging out wasnt resetting them.
Outside processing added to standard purchase orders
Version 2.0.05 (02-June-2011)
Quotation, Price Break Level, UOM changed to required field. It Was uploading into oracle causing the Quote to be invalid/incomplete until a value is entered.
Change API fixed bug where release was using the PO revision rather than the release revision and always giving 'Revision Number doesn't match the current revision.' errors.
Attachment Uploader errored when uploading an excel file. It uploaded sucessfully but the attachment form throws an error afterwards
Removed SECURITY_GROUP_ID from ValueSet sql - some r12 instances dont have this column.
Version 2.0.04 (01-June-2011)
Fixed bug where toolbar for standard purchase order was not being created properly - this meant the forms were not showing when clicked on by the toolbar. Attachments also were not showing.
Removed Attachments from blanket toolbar because it doesnt work. Need to re-implement.
Version 2.0.03 (17-May-2011)
Stopped forms from placing the cursor in the cell when closing from double_click.
Fixed mouse pointer to change from hour glass to arrow on click events and forms
Version 2.0.02 (2-May-2011)
Added Multi-Line to functionality to some fields on forms.
Fixed bug where Standard PO parse return string was writing a value to the charge account column if it was blank.
Version 2.0.01 (15-Mar-2011)
Added Download by sheet functionality
Fixed Change API download to stop duplicates.
Version 2.0.00 (14-Mar-2011)
BPAs split from Standard POs
Version 1.3.97 (21-Feb-2011)
Added purchaseable flag filter to item query.
Re-wrote refresh - Rejected lines would show as Accepted if the PO was created.
Fixed bug in download SQL and DFF for 11.5.9
Version 1.3.96 (26-Jan-2011)
Fixed bug in PO Header form - the Global flag was not enabling when when changing PO Type from Standard to Blanket.
Updated Descriptive Flexfields to latest code.
Fixed bugs in Line Effective and Line Expiration dates. These Bugs were in the Form, Validation and Download.
Version 1.2.95 (25-Nov-2010)
Added modifications for non-standard 11.5.8 and 11.5.9 installs.
Version 1.2.94 (24-Nov-2010)
Added Columns 'Supplier Note'(Header Section) and 'Note to Supplier'(Line Section).
Version 1.2.93 (17-Nov-2010)
Fixed bug for when a cell is in an Error State eg #NA - Trying to retrieve a value from a cell would cause an error.
Modified PO Number validation for creates - Stopped checking of Database for blank PO Number.
Fixed bug in header form - site was being overwritten by the first site in the list when the form was loading.
Version 1.2.92 (11-Oct-2010)
Fixed bug where SGA fix was breaking wizards on 11.5.9 and below.
Fixed incorrect logic where Exchange Rate Type, Exchange Rate, Exchange Rate Date and were being ignored by the the blanket upload.
Header Amount Agreed was downloading the wrong column.
Fixed bug where no information was returned when searching for data with an apostrophe in it i.e. O'Donnell would be searched for as O''Donnell
11.5.9 - Added inserting of line level action code for blanket updates. UPDATE or ADD for updating existing lines and adding new lines respectively.
Version 1.2.91 (03-Oct-2010)
Bug Fix in customization
Version 1.2.90 (27-Oct-2010)
Upgraded generic modules.
Added protection.
Fixed 2007 size/speed bug caused by conditional formatting in set_status.
Changed header form to allow invalid PO Numbers to be written back to the sheet
Fixed bug in request parameters - The batchID was not being passed through. So, all batches
were being submitted by the one request.
Fixed bug where non-numeric price value could be uploaded causing the wizard to error and the sql insert statement to error.
Version 1.2.89 (12-Oct-2010)
Changed Template Sheet and Sheet 1 to general format because text format was wreaking havoc upon formulas.
DistributionTotal Check changed to ignore non numeric values and blank lines.
Fix to endrow in rowdetails object. If the last PO on the sheet was also the last populated row on the sheet then endrow
would return 500+ rather than the actual endrow.
Version 1.2.88 (7-Oct-2010)
Removed fnd_look_up from header download sql.
Removed defaulting of 'Deliver To Location' (distributions level) for 11.5.8.
Added PO Wizard Package check so the wizard can run against both the old package and the new
package with the SGA changes.
Version 1.2.87 (06-Oct-2010)
Supports package change for reducing SGA overhead for insert statements.
Item query changed. Poor performing UOM join removed.
Fixed bug in Key Flexfield filter where where non required segments would cause no data to be returned if they were not populated.
Version 1.1.86 (16-Sep-2010)
Modified Keyflexfields to be compatible with 11.5.9 and 11.5.8
Version 1.1.85 (30-Aug-2010)
Fixed bug where dates were not written to cells during download
Version 1.1.84 (26-Jul-2010)
Rewrote Refresh - blank lines 100 clause was causing refresh to stop before completion if a non uploaded PO with more than a 100 lines came before uploaded POs.
Added Sales Credit DFFS.
Fixed DFF validation bug - if no dff columns are on the sheet but there is a required attribute.
Changed PO Validation to accept PO Numbers when entry is set to automatic. First checking to see that the number does not already exist.
Version 1.1.83 (14-Jul-2010)
Changed Documentation links to point to Purchase Order Wizard rather than Receivables Invoice Wizard in setup sheet.
Fixed the Kill button on the Download Controller form.
Version 1.1.82 (12-Jul-2010)
Modified Price validation. Now allowing Amount Base Line Types to be 1 or empty.
Version 1.1.81 (7-Jul-2010)
Fixed bug where Key flex fields were failing to initialise caused by a language problem.
Version 1.1.80 (5-Jul-2010)
Changed validation of distributions Deliver_To_Location. Apostrophes in the Location Name would mean no values would be returned from the database. Changed it to use the proc that the other locations use.
Added back in 'Upload All Attachments'. Was unable to replicate previous upload issue.
Added new setup sheet.
Common modules upgraded to v128.
Fixed bug in the Line Quantity/Distributions Quantity check. DistributionTotal was truncating the decimal values.
Version 1.1.79 (2-Jul-2010)
Removed 'Upload All Attachments' from toolbar. It needs to be fixed.
Version 1.1.78 (29-Jun-2010)
Added a download progress form.
Version 1.1.77 (24-Jun-2010)
Added LOVs to download form. Added further error handling to try to pick up errors any download errors.
Version 1.1.76 (09-Jun-2010)
Download upgraded.
Fixed bug - Line Number was not being uploaded.
Price validation. Fixed bug where it was impossible to load a line with an AMOUNT based line type.
Fixed bug in refresh where a 500+ line purchase order would cause POs below not to be refreshed.
Version 1.1.75 (03-Jun-2010)
Fixed bug in Lines form which set continue_level = 3. Which then stopped the item query from returning data.
Version 1.1.74 (28-Jun-2010)
Fixed bug in interface distributions download sql.
Fixed bug where Line would not be uploaded when PO was being re-uploaded. This would only occur when the Line was not on the same row as the shipments.
Further fixes for big uploads.
Version 1.0.57 (9-Dec-2009)
Made changes to Purchase Order Number validation. Now looks at Purchasing Options and will let Alphanumerics through.
Adjusted toolbar positions with excel 2003.
Version 1.0.56 (23-Nov-2009)
Put a prepare_string around the location_code in modmain.get_deliver_to_location to remove morrisons bug with apostrophy in string.
Fixed bug where you would get an application error if the currency columns were removed from the wizard.
Added missing column 'Line Effective Date' to sheet1 and template.
Version 1.0.55 (10-Nov-2009)
Organization override re-added – because it was mistakenly removed.
Supplier override removed because it was not implemented - so it was misleading to have it available in the list.
Requestor added to download.
Added defaulting of distributions 'Deliver to Location' from the requestor.
Automatically generating line numbers if they are not provided.
Updated concurrent request viewer.
Version 1.0.54 (30-Oct-2009)
Item key flexfield modified. It was not bringing back values when used against some r12 instances.
Version 1.0.53 (29-Oct-2009)
Fixed bug where a distributions insert at the start of an accumulate block processblockdata call would not have the lineID and hence the block with fail with a ora-00936 error.
Version 1.0.52 (28-Oct-2009)
Added concurrent request viewer.
Changed item validation to work off the org_id from po_system_parameters rather than filtering on SOB.
Fixed bug where a distributions insert at the start of an accumulate block processblockdata call would not have the lineID and hence the block with fail with a ora-00936 error.
Version 1.0.51 (21-Oct-2009)
Added override tables for 'Blanket Approval Status' and 'Standard PO Approval Status'
Removed override tables that did not do anything - brought across from Requisition Wizard but never implemented.
Item kff added code to allow a one segment item kff to have a delimiter as part of the item text.
Added validation check for duplicate line numbers on upload.
Restricted Download Type LOV to Blanket and Standard only. It previously included all the PO Types ie Quotations, RFQs etc
Version 1.0.50 (24-Sep-2009)
Fixed r12 multi org bug where responsibility orgid was being used rather than the selected orgid.
Version 1.0.49 (27-Aug-2009)
Added global agreement and price limit columns
Version 1.0.48 (26-Aug-2009)
Item validation changed on line form. Validates on after update rather than needing to open the flexfield form. And, updates category, unit of measure and price accordingly.
Fixed bug where price was not being updated at times on line form.
Changed submit form to default to the buyer who is logged into the spreadsheet.
Version 1.0.47 (24-Aug-2009)
Removed defaulting of the Charge Account – now letting oracle default the values if they are not provided.
Version 1.0.46 (14-Aug-2009)
Added Line_type to context defaulting. Changed Context Defaulting to stop it using substitutions
Version 1.0.45 (22-Jul-2009)
Fixed bug where rate type and rate date were transposed in download
Added l.line order by clause to download
Fixed Exchange Rate Date bugs in Header form
Fixed upload validation for currency
Fixed download bug where alphanumeric PO Number cell value was set to 0
Fixed bug in attachment upload – the wizard was looking to see where line attachments section ended and hence would not upload if it was below other sections.
Fixed bug where the header attachments broke the delete messages for the line deletes.
Version 1.0.44 (21-Jul-2009)
Added Currency Columns to template sheet
Version 1.0.42 (13-Jul-2009)
Changes in package call for 11.5.9
Change order by clause in download selection
Version 1.0.41 (8-Jul-2009)
Added column Allow Price Override to lines section
Version 1.0.40 (2-Jul-2009)
Range delete bug fixed. Where 'Lines distributions' message would pop a lot.
Fixed 'effective date from' bug on header form. If there was no 'effective date to' then the 'expected date from' validation would error.
Date handling improvements.
Fixed bug where wizard would try to delete from the interface tables when IDs on the sheet were blank or not numeric.
Changes to the Batches form. Disallowed submission of Blanket, Create Sourcing Rules and Incomplete. This was causing the Request to fail without returning any messages to the wizard.
Version 1.0.39 (5-Jun-2009)
Fixed tax code defaulting for r12
Version 1.0.38 (21-May-2009)
Key Flex upgraded to handle 14 segments
