32012 asset receipt inspection portal external design

8/2/2019 32012 Asset Receipt Inspection Portal External Design

1/42

Smart Device Managementv2.0.0

Portal External Design32012 Asset Receipt Inspection


2/42

32012 Asset Receipt Inspection Portal External Design Smart Device

Management

sdgfd

Last Modified: January 23, 2012 15:06 a1/p1Printed On: November 7, 2006

2 Copyright 2012, Oracle. All rights reserved.


3/42

Smart Device Management 32012 Asset Receipt Inspection Portal External

Design

Smart Device Management, Portal External Design

ORACLE CONFIDENTIAL. For authorized use only. Do not distribute to third parties.

Copyright 2012, Oracle and/or its affiliates. All rights reserved.

This document is for informational purposes only. It is not a commitment to deliver any material,code, or functionality, and should not be relied upon in making purchasing decisions. Thedevelopment, release, and timing of any features or functionality described in this documentremains at the sole discretion of Oracle. This document is not warranted to be error free, nor is itsubject to any other warranties or conditions, whether expressed orally or implied in law, includingimplied warranties and conditions of merchantability or fitness for a particular purpose.

This document in any form, software or printed matter, contains proprietary information that is theexclusive property of Oracle. This document and information contained herein may not bedisclosed, copied, reproduced or distributed without the prior written consent of Oracle. Thisdocument is not part of your license agreement nor can it be incorporated into any contractualagreement with Oracle or its subsidiaries or affiliates.

Copyright 2012, Oracle. All rights reserved. 3


4/42


Management

Table of Contents

Table of Contents......................................................................................................................... .4

Overview........................................................................................................................................5

Document History................................................................................................................ .........5

Business Use Cases.................................................................................................................... .5

Design Element Asset Replication Activity.......................................................................... ....5System Data.............................................................................................................................6

Business Services..............................................................................................................6Navigation Options.............................................................................................................8

Application Service.............................................................................................................9

User Interface and Business Rules..................................................................................... ......9Menu / Submenu / Context Menu / Go To Context..............................................................9Replication Activity Query Portal (W1REPACTQ) (New)...................................................10Related Object Search Zone (W1-REPACTQ1)(New).......................................................11UI Maps............................................................................................................................15

BPA Scripts.............................................................................................................................19Asset Replication Activity BPA Script (W1-AsRpActMnt) (New).................................. ......19Reapply Asset Template BPA Script (W1-AppAstTmp) (New)..........................................20

Service Scripts........................................................................................................................21Validate Replication Related Object Query Filter (W1-ValReplRO) (New).........................21

Implementation Guidelines......................................................................................................22Replication Guidelines......................................................................................................22

Design Element Mass Asset Disposition Update .............................................................. ....23System Data....................................................................................................................... ....23

Business Services............................................................................................................23Navigation Options...........................................................................................................26

Application Service...........................................................................................................27Service Program...............................................................................................................27

Services..................................................................................................................................28Retrieve Asset Next Dispositions Service (New)...............................................................28Retrieve Assets using Asset Info Criteria (Update)............................................................30

User Interface and Business Rules.........................................................................................31Menu / Submenu / Context Menu / Go To Context............................................................31Mass Asset Disposition Update Portal (W1ASTMDU) (New).............................................32

Asset Information Query Zone (W1-ASTMDUQ1)(New)....................................................35BPA Scripts.............................................................................................................................38

Asset Disposition Mass Update BPA Script (W1-AstMasUpd) (New)............................ ....38Service Scripts........................................................................................................................40

Validate Asset Information Mass Asset Disposition Filter ( W1-AsMdQ1Val) (New)..........40Asset Info Query Zone Pre-Processing (W1-AsInfQ1ss) (Update)............................ ........41



5/42


Design

OverviewThis document describes the entities and processes needed to support asset replication and assetdisposition mass update.

Document HistoryDate Name Description/Reason for change

2011-12-29 Anette Velarde Initial Version

2012-01-13 Jay Dela Cruz Modified for internal review

2012-01-18 Jay Dela Cruz Review points

2012-01-19 Anette Velarde Review points-Added Asset column (New Asset Section) inGeneral Asset Replication Display UI Map

2012-01-23 Anette Velarde Added Copy Service History Flag in AssetReplication UI (Display & Maintenance)

Business Use CasesReceipt Inspection involves three independent processes.

Replicate assets in the same lot/pallet.

Select assets for testing.

Mass update assets disposition, for example, rejecting or accepting the lot/pallet.

Design Element Asset ReplicationActivity

Companies receive many assets in a lot/pallet. Assets in a lot/pallet are the same except for a fewdetails like serial numbers and badge numbers. Need a way to easily create those assets.



6/42


Management

System Data

Business Services

Retrieve Activity Types of a Category (W1-ACTTYPCAT)(New)

This business service returns all activity types of a particular category.

Properties

Property Value

Code W1-ACTTYPCAT

Description Retrieve all activity types of a particular category

Service Program FWLZDEXP Data ExplorerApplication Service F1-DFLTAPS

Schema

Field Element name Comments

Category category mapField="F1_VALUE"

Row Count rowCount mapField="ROW_CNT"

Results results type="list" mapList="DE"

Activity Type activityType Flattened element for thefirst column of the resultset.

mapField="COL_VALUE"

Activity Type Description description Flattened element for thefirst column of the resultset.

mapField="COL_VALUE"

Xml Schema



7/42


Design

Retrieve Activity Types of a Category Zone (W1-ACTTYPCAT) (New)This zone returns all activity types of a particular category.

Properties

Property Value

Code W1-ACTTYPCAT

Description Retrieve all activity types of a particular category

Zone Type F1-DEApplication Service F1-DFLTS

Parameters

Parameter Value

Display Description Area False

User Filter 1 type=String name=category required=true

SQL 1 Condition F1

SQL 1 Display Columns C1 C2

SQL Statement 1 Pseudo SQL 1

Column 1 for SQL 1 source=SQLCOL

sqlcol=ACT_TYPE_CD


sqlcol=ACT_TYPE_DESC

Pseudo SQLSELECT A.ACT_TYPE_CD, L.DESCR100 ACT_TYPE_DESC

FROM W1_ACTIVITY_TYPE A,W1_ACTIVITY_TYPE_L LWHERE A.ACT_TYPE_CD = L.ACT_TYPE_CDAND L.LANGUAGE_CD = :LANGUAGEAND A.CATEGORY_FLG = :F1



8/42


Management

Navigation Options

Replication Activity Query (w1repactqTabMenu) (New)This navigation option points to theReplication Activity Query portal. This is automatically

generated when the query portal is created.

Properties

Property Value

Code Replication Activity

Description The Navigation option that points to ReplicationActivity Queryportal.

Navigation Option Type Transaction

Navigation Mode Add Mode

Target Transaction w1repactqTabMenu

Tab Page

Search Transaction

Search Type

Search Group

Script

Go To Tooltip

Context

Field Key Field

Usage

Navigation Usage

Favorites

Menu



9/42


Design

Application Service

Replication Activity Query (W1REPACTQ) (New)This is the application service associated with the Replication Activity Query portal and is

automatically generated when the portal is created

Properties

Property Value

Code W1REPACTQ

Description This application service is associated with theReplication Activity Query portal

Access Modes

Access Modes

Inquire (R)

User Interface and Business Rules

Menu / Submenu / Context Menu / Go ToContext

Main MenuCreate a new sub menu Asset Replication under the Main menu. Add the following under the newsubmenu.

Replication + (New). + is associated with a navigation option forAsset Replication BPAScript. Replication launches theReplication Activity Search.

ContentsName Description Product Module

Replication This launches theReplicationActivity Search Portal. Clickingthe (+) button will invoke theAsset Replication BPA Script.



10/42


Management

Layout

Replication Activity Query Portal(W1REPACTQ) (New)

This is the search portal of Activities to be replicated. This portal includes a multi query zone whichallows the users to search for an activity given a set of criteria.

PropertiesProperty Value

Code W1REPACTQ

Description Replication Activity QueryType Stand Alone

Navigation Option w1repactqTabMenu

Show On Portal Preferences No

Portal ZonesZone Display Initially Collapsed Default Sequence

W1-

REPACTQRY

True False 10

Layout



11/42


Design

Replication Activity Multi Query Zone (W1-REPACTQRY)(New)

Properties

Property Value

Code W1-REPACTQRY

Description Replication Activity Search

Zone Type F1-DE-MULQRY (Multi Query Data Explorer)

Application Service W1REPACTQ

Parameters

Parameter Value

Query Zone 1 W1-REPACTQ1

Override Action 1 type=LINK action=SCRIPT bpa='W1-RepActMnt'label=ADD_LBL class='oraZoneHeaderLink'

tempstorage=[action='ADD']

Dialogue Trigger

Click Add Hyperlink

Clicking the Add hyperlink will invoke the Asset Replication BPA to add a new ReplicationActivity.

Related Object Search Zone (W1-REPACTQ1)(New)This zone is used to filter and search for replication activities by related object.

Properties

Property Value

Code W1-REPACTQ1



12/42


Management

Description Replication Activity Related Object Search

Zone Type F1-DE-QUERY

Application Service W1REPACTQ

Width Full

Parameters

Parameter Value


Filter Area UI Map Replication Activity Related Object Query Filter (W1-AssetReplActivityQ1QryFltr )

Validate Filter ValuesService Script

ss='W1-ValReplRO' input=[activityType=F1activityStatus=F2 workOrderId=F3 assetId=F4nodeId=F5 activityId=F6]

User Filter 1 type=String xpath= activityType

User Filter 2 type=String xpath=activityStatus

User Filter 3 type=String xpath=workOrderId

User Filter 4 type=String xpath=assetId

User Filter 5 type=String xpath=nodeId

User Filter 6 type=String xpath=activityId

Excel Rows Leave blank to enable Export to Excel on zones toolbar

SQL Display Columns C4 C6 C8 C10

SQL Statement 1 Pseudo SQL

Column1 for SQL1 source=SQLCOL

sqlcol=CRE_DTTMColumn2 for SQL1 source=SPECIFIED

spec=[''C1' C4]

order=DESC


sqlcol= ACT_ID

Column4 for SQL1 source=FKREF fkref= W1-ACTV

input=[ACT_ID=ACT_ID]

label=


sqlcol=NODE_ID

Column6 for SQL1 source=FKREF fkref= W1-NODE

input=[NODE_ID=NODE_ID]

label=

suppress=true



13/42


Design


sqlcol=ASSET_ID

Column8 for SQL1 source=FKREF fkref= W1-ASSET

input=[ASSET_ID=ASSET_ID]

label=

suppress=true


sqlcol =WO_ID

Column10 for SQL1 source=FKREF fkref= W1-WO

input=[WO_ID=WO_ID]

label=

suppress=true

Pseudo SQLSELECT ACT.ACT_ID,

ACT.NODE_ID NODE_ID,ACT.ASSET_ID ASSET_ID,ACT.WO_ID,ACT.CRE_DTTM,

ACT.ACT_TYPE_CDFROM W1_ACTIVITY ACT,W1_ACTIVITY_TYPE ACTTYPEWHERE ACT.ACT_TYPE_CD= ACTTYPE.ACT_TYPE_CDAND ACTTYPE.CATEGORY_FLG ='W1RE'[(F1) AND ACT_TYPE_CD=:F1][(F2) AND ACT.BO_STATUS_CD=:F2]

[(F3) AND ACT.WO_ID=:F3][(F4) AND ACT.ASSET_ID=:F4][(F5) AND ACT.NODE_ID=:F5] [(F6) AND ACT.ACTIVITY_ID =:F6]ORDER BY

ACT.CRE_DTTM DESC

List Contents

This query zone has the following user filters. At least one filter other than activity type and activitystatus must be populated, but activity type and activity status is optional.

Selects all activity records that match all entered filters and the category of its activity typeis W1RE- Replication.

Activity Information Information String of Activity

Node Information Information String of Node

Asset Information Information String of Asset

Work Order Information Information String of Work Order



14/42


Management

Related Object UI Map (W1-AssetReplActivityQ1QryFltr) (New)This HTML Fragment is used to display the filters in the Replication Activity Related Object Zone.

Properties

Property Value

Code W1-AssetReplActivityQ1QryFltr

Description Related Object

UI Map Type HTML Fragment

Layout

Contents

Activity Type Dropdown with activity types whose category isW1RE Replication. Seebusiness service Select Activity Types Of A Category.

Status Drop down. Build the drop down which consists of all states of business objectsunder Activity MO. Use the business service W1-RTBOST to get the activity statusdescriptions for Activity MO.

Work Order ID Custom Search of Work Order - Multi Query Zone.

Asset ID Custom Search of Asset - Multi Query Zone.

Node ID Custom Search of Node - Multi Query Zone.

Activity ID



15/42


Design

UI Maps

General Asset Replication Maintenance UI Map (W1-AssetReplActivityMaint) (New)

This UI Map is used to maintain a general asset replication activity.

Properties

Property Value

Code W1-AssetReplActivityMaint

Description General Asset Replication Activity Maintenance

UI Map Type Complete HTML Document

Layout

Contents

Main Section

Activity Type, display only

Asset ID, mdField=Template Asset, custom search

Node, display only and only visible when node id is populated



16/42


Management

Work Order ID, custom search

Copy Service History, c heckbox, required and default No (unmarked)

New Assets Section

A grid of information to be overriden on a template

Sequence Number

Badge Number

Serial Number

Asset, display only

Buttons

Upload from CSV File, information from file is used to populate the New AssetsSection

Download to CSV File, information from New Assets Section will be saved to aCSV File

Note. Code on how to Upload and Download a CSV File can be found in the oraHtml Attributes UI

Map Tips

Schema

Xml Schema

General Asset Replication Display UI Map (W1-AssetReplActivityDisp) (New)

This UI Map is used to display a general asset replication activity.

Properties

Property ValueCode W1-AssetReplActivityDisp

Description General Asset Replication Activity Display




17/42


Design

Layout

Dialogue Trigger

Click on Edit Button

This will execute theAsset Replication Activity Maintenance BPA Scriptwith UPD action.

Click on Delete Button

This will execute theAsset Replication Activity Maintenance BPA Scriptwith DEL action. Thiswill prompt the user for Delete confirmation.

Click on Reapply Button

This will execute the Reapply Asset Template BPA Script with UPD action.

Click on Transition Button

This will execute theAsset Replication Activity Maintenance BPA Script.

This pertains to the action to be taken by the Activity to move to the next status. Buttons willdepend on the next status defined in the Completion Event BO.

Complete Button will pass COMP action

Content

Main Section

Activity Info

Activity Type

Status

Status Reason, only visible when populated



18/42


Management

Asset, mdField=Template Asset

Node

Work Order

Copy Service History

New Asset Section, initially collapsed

A list of assets to be replicated

Sequence Number

Badge Number

Serial Number

Asset InfoID (will have value once replication is completed)

Record Action Section

Edit

Delete

Reapply. Note that the label should use MD field. Only available when activitystatus is Completed

Status Transition.

Record Info Section, initially collapsed

Activity ID

Business Object

Status DateTime

Create DateTime

Schema

Xml Schema

Activity Type For Replication UI Map (W1-ActivityTypeForReplication) (New)

This UI Map is invoked by the Asset Replication Activity BPA Script to get the input Activity Type.



19/42


Design

Properties

Property Value

Code W1-ActivityTypeForReplication

Description Activity Type For Replication


Layout

Content

Activity Type

Dropdown values will be populated from the results of the Retrieve Activity Types of aCategory

Schema

Xml Schema

BPA Scripts

Asset Replication Activity BPA Script (W1-AsRpActMnt) (New)

This script is used to maintain an activity and is invoked from:

Menu Replication +

Add hyperlink on theReplication Activity Search Zone.



20/42


Management

Edit, Delete buttons and State Transition Buttons inGeneral Asset Replication ActivityDisplay UI Map.


Code W1-AsRpActMnt

Description Asset Activity Replication Maintenance

Accessibility Option Accessible from Script Menu

Script Engine Version 1.0

Data AreaSchema Type Object DA Name

Business Service F1-DetermineBo F1-DetermineBo

Service Script F1-GetBOOpts F1-GetBOOpts

Service Script F1-GetBOSOpt F1-GetBOSOpt

Service Script F1-RetBOs F1-RetBOs

Script Steps This BPA is similar to the standard Activity maintenance BPA script. The difference is that the

Activity Type for Replication UI Map should be invoked in order to limit the Activity Types with aReplication Category.

Reapply Asset Template BPA Script (W1-AppAstTmp) (New)

This BPA updates all replicated assets using the template asset.


Code W1-AppAstTmp

Description Reapply Asset Template

Accessibility Option Accessible from Script Menu



21/42


Design

Script Engine Version 1.0


Script Steps Call service script Asset Mass Replication/Update with update action. See note below.

Note: Refer to 32012 Asset Receipt Inspection BO ED for the Service Script

Service Scripts

Validate Replication Related Object QueryFilter (W1-ValReplRO) (New)

This validates the filter for the Related Object query zone of the Replication Activity Portal.


Code W1-ValReplRO

Description Validate Replication Related Object Query Filter

Application Service F1-DFLTAPS

Script Engine Version

SchemaField Element name Comments

Activity Type activityType

Activity Status activityStatus



22/42


Management

Work Order ID workOrderId

Asset ID assetId

Node ID nodeId

Activity ID activityId

Script Steps If Work Order ID and Asset ID and Node ID and Activity are not populated, then:

Terminate with error:At least one filter must be populated other Activity Type andActivity Status

Implementation Guidelines

Replication GuidelinesPlease take the following steps to finish the setup:

1. Create a completion event type using Replication Completion Event Type business object. Onthe completion event type, choose the General Asset Replication Completion Event businessobject.

2. Create an activity type using Basic Activity Type business object. Set Category toW1RE

Replication. Define the completion event type defined above as the only completion event typeand as required. Choose the General Asset Replication Activity business object.

The base activity business object only allows users to change badge number and/or serial numberwhen replicating assets and everything else are kept the same as the template asset. Whenreceiving many the same assets, the users are required to create one asset for the lot first andreplicate the rest. If an implementation needs to override other information, please take thefollowing steps to extend base functionality:

1. Create a new asset replication activity BO to accept those overrides.

2. If needed, create a new asset replication completion event BO with a new enter algorithm forthe Excute status. Note that the enter plug-in on the base BO moves elements in the list byname to the asset BO.

3. Set up a completion event type and an activity type as described above.



23/42


Design

Design Element Mass AssetDisposition Update

Companies receive many assets in a lot/pallet. Assets in a lot/pallet are the same except for a few

details like serial numbers and badge numbers. Need a way to easily create those assets.

System Data

Business Services

Retrieve Asset Next Dispositions (W1-

RetAssetNextDispostions) (New)This business service returns the list of next possible asset dispositions for a given asset type &asset disposition or an asset id.

Properties

Property Value

Code W1-RetAssetNextDispostions

Description Returns the list of next possible asset dispositions for agiven asset type & asset disposition or an asset id

Service Program W1-ASTNXTDPOSApplication Service F1-DFLTAPS

Schema

Field Element name Comments

Asset Type assetType mapField="ASSET_TYPE_CD"

Status status mapField="BO_STATUS_CD"

Asset ID assetId mapField="ASSET_ID"

User ID userId mapField="USER_ID"

default=CurrentUser

Include System Disposition includeSystemDisposition

dataType="boolean"default="true"mapField="INC_SYSTEM_ROLES

_SW



24/42


Management

Next Dispositions nextDisposition type="list"

mapList="RESULTS"

Status Status Flattened element for the firstcolumn of the resultset.

mapField="BO_STATUS_CD"

Default default Flattened element for the firstcolumn of the resultset.

mapField="DEFAULT"

Boolean

Status Reason Flag statusReasonFlg Flattened element for thesecond column of the resultset.

mapField="BO_STATUS_REASON_CD"

Asset Disposition assetDpos Flattened element for the firstcolumn of the resultset.

mapField="ASSET_DPOS_FLG"

Asset DispositionDescription

assetDposDesc Flattened element for the firstcolumn of the resultset.

mapField="DESCR"

Asset Relationship assetRelationship Flattened element for the firstcolumn of the resultset.

mapField="ASSET_REL_FLG"

Xml Schema



25/42


Design

Retrieve Assets using Asset Info Criteria (W1-RetAstUseAssetInfo) (Update)

This is an existing business service from the 32004 Asset Portal ED that needs to be updated inorder to be used by the Asset Information Query Zone of the Mass Asset Disposition Update Portal.

PropertiesNo changes

SchemaAdd BO Status Code in the Output List

Xml Schema


26/42


Management

Navigation Options

Mass Asset Disposition Update (w1astmduTabMenu)(New)

This navigation option is associated with theAsset Disposition Mass Updateportal. This isautomatically generated when the portal is created.

Properties

Property Value

Code w1astmduTabMenu

Description Mass Asset Disposition Update

Navigation Option Type Transaction

Navigation Mode Change ModeTarget Transaction w1astmduTabMenu

Tab Page

Search Transaction

Search Type

Search Group

Script

Go To Tooltip

Context

Field Key Field

None

Usage

Navigation Usage

Favorites

Menu



27/42


Design

Application Service

Mass Asset Disposition Update (W1ASTMDU) (New)This is the application service associated with the Mass Asset Disposition Mass Update portal and

is automatically generated when the portal is created.

Properties

Property Value

Code W1ASTMDU

Description Mass Asset Disposition Update Portal

Access ModesAccess Modes

Inquire (R)

Service Program

Retrieve Asset Next Dispositions (W1-ASTNXTDPOS)(New)

This service invokes theRetrieve Asset Next Disposition Page Maintenance Service.

Properties

Property Value

Service Program Name W1-ASTNXTDPOS

Description Retrieve Asset Next Dispositions

Type Java

Retrieve Asset Using Asset Info Criteria (W1-ASSETINFOQRY) (Update)

This is an existing service from the 32004 Asset Portal ED that needs to be updated in order to beused by the Asset Information Query Zone of the Mass Asset Disposition Update Portal.



28/42


Management


Services

Retrieve Asset Next Dispositions Service(New)

This service program creates a list of possible Next Asset Dispositions.


Program Name RetrieveAssetNextDispositionsService

Program Description Creates a list of possible Next Asset Dispositions

Type PageMaintenance

Secured

Service Program W1- ASTNXTDPOS

Actions Read

Modules N/A

Header name=ASSET_TYPE_CD

name=BO_STATUS_CD

name=ASSET_ID

name=USER_ID

name= INC_SYSTEM_ROLES_SW

Body name=RESULTS

Lists name=RESULTS

contents:

BO_STATUS_CD

DEFAULT

BO_STATUS_REASON_CD

ASSET_DPOS_FLG

DESCR

ASSET_REL_ FLG



29/42


Design

Input / Output Definition

Input

Asset Type

Status

Asset ID

User ID, defaut=CurrentUser

Include System Disposition, dataType="boolean" default="true"mapField="INC_SYSTEM_ROLES_SW

Output

Asset Dispositions (List) Status

Default, boolean

Status Reason Flag

Asset Disposition

Asset Disposition Description

Asset Relationship

Processing If Asset ID is populated

If Asset Type and Status are both populated, then Terminate with error:BothStatus and Asset Type must be blank when Asset ID is provided.

Get the next states for the Asset provided

Determine the BO of the provided Asset by calling F1-DetermineBO businessservice (passing the Asset MO and the input Asset ID)

Get the Status by invoking the Asset BO for read

Invoke the F1-RetrieveAllNextStates business service to get the next states(passing the Assets BO, the retrieved Status, the input User ID and set theincludeSystemStates switch based on the input Include System Disposition switch

Else

If either Asset Type or Status is not populated, then Terminate with error:BothStatus and Asset Type must be provided when Asset ID is blank.

Get the next states based on the Asset Type and Status provided



30/42


Management

Determine the BO of the provided Asset Type by calling F1-DetermineBO businessservice (passing the Asset Type MO and the input Asset Type)

Get the Asset BO detail by invoking the Asset Type BO for read

Invoke the F1-RetrieveAllNextStates business service to get the next states(passing the retrieved Asset BO, the input Status, the input User ID and set the

includeSystemStates switch based on the input Include System Disposition switch

Loop through the outputs from business service F1-RetrieveAllNextStates:

If Access is True

Populate the Status and Default switch in the output.

Retrieve the Status Reason Flag of the status. Note that this flag isdefined in the lifecycle BO. Set the output if the Status Reason Flag is populated.See design note below.

Call business service Retrieve BO Status Asset Disposition

Populate the Asset Disposition and Asset Disposition in the output.

Retrieve the Asset Relationship for the Asset Disposition and populate the output.

Design Note. There may be a framework service for this already, for example F1-

GetBoStatusReason.

Retrieve Assets using Asset Info Criteria(Update)

This is an existing Java service from the 32004 Asset Portal ED that needs to be updated in orderto be used by the Asset Information Query Zone of the Mass Asset Disposition Update Portal.

PropertiesAnnotation needs to be changed to include BO Status Code

Input / Output Definition

InputNo changes



31/42


Design

OutputInclude BO Status Code

ProcessingInclude BO Status Code of the Asset in the columns to be retrieved.

User Interface and Business Rules

Menu / Submenu / Context Menu / Go ToContext

Main Menu (Change)Create a new sub menu Asset Replication under the Main menu. Add the following under the newsubmenu.

Mass Asset Disposition Update, associated withMass Asset Disposition Updateportal

ContentsName Description Product Module

Mass Asset DispositionUpdate

This launches the Mass AssetDisposition Update portal

Layout



32/42


Management

Mass Asset Disposition Update Portal(W1ASTMDU) (New)

This portal is invoked from the Mass Asset Disposition Update menu item in the Asset Replicationsubmenu. This is used for searching Assets and updating their dispositions.


Code W1ASTMDU

Description Mass Asset Disposition Update

Type Stand Alone

Show On Portal Preferences No

Portal ZonesZone Display Initially Collapsed Default Sequence

W1 -ASTMDUQRY

True False 10

Mass Asset Disposition Update Multi Query Zone (W1-

ASTMDUQRY) (New)

Properties

Property Value

Code W1-ASTMDUQRY

Description Mass Asset Disposition Update Search

Zone Type F1-DE-MULQRY (Multi Query Data Explorer)

Application Service W1ASTMDU

Parameters

Parameter Value

Query Zone 1 W1-ASTMDUQ1 (Asset Information)

Dialogue Trigger



33/42


Design

Query Options

Selecting an item from the drop down list invokes the associated Query Zone. Default QueryZone isAsset Information (W1-ASTMDUQ1)

Asset Disposition Mass Update UI Map ( W1-AssetMassDposUpdate) (New)

This map is used to mass update the list of assets. It is launched by theAsset Disposition MassUpdate BPA Script.

Property Value

Code W1-AssetMassDposUpdate

Description Asset Mass Disposition Update


Layout

Contents

Effective Date/Time

Asset Disposition

Values are the Current Asset Disposition passed to this map + Values returnedfrom the Retrieve Asset Next Dispositions business service. See design note below.

Onchange: Reset Node, Attached to Asset, Reason and Status (not shown but inthe schema) fields

If Current Asset Disposition is equal to the selected Asset Disposition, then set theStatus to blank.

Node



34/42


Management

Custom search. Hidden until Asset Disposition has been selected and its assetrelationship is not W1AT- Attached, passing Asset Type and Asset Disposition to thehidden filters.

Attached To Asset

Custom search. Hidden until Asset Disposition has been selected and its asset

relationship is W1AT Attached, passing Asset Type and Asset Disposition (thetarget/selected disposition) to the hidden filters.

Reason

Values are from business service F1-BOStateSelectReasonList

Hidden until Asset Disposition has been selected and different from the CurrentAsset Disposition and the selected Asset Disposition/Statuss Status Reason Flag iseitherF1OT Optional orF1RD Required.

OK Button

Protected until all the following fields are populated: Effective Date/Time, AssetDisposition, Node or Attached to Asset (either), Reason (if required)

Cancel Button

Note. If possible, the initial value in the dropdown should be the one whose default switch is true.

Perhaps this should be arranged in the service program that prepares these values.

Schema

Xml Schema



35/42


Design

Asset Information Query Zone (W1-ASTMDUQ1)(New)

This zone is used to query assets and mass update assets disposition/status.

Properties

Property Value

Code W1-ASTMDUQ1

Description Asset Information

Zone Type F1-DE-QUERY

Application Service W1ASTMDU

Width Full

Parameters

Parameter Value


Pre Process Service Script ss="W1-AsInfQ1ss"

input=[assetType=F1 specification=F2assetCondition=F3 address=F4 city=F5 postal=F6activityId=F7 assetCharacteristics=F8assetIdentifiers=F9]

Note: The filtering of the Asset Disposition is done afterthe Pre-Processing Script. See SQL below.

Filter UI Map W1-AssetMassDposQ1QryFltr

User Filter 1 type=String xpath=assetType

User Filter 2 type=String xpath=specification

User Filter 3 type=String xpath=assetCondition

User Filter 4 type=String xpath=address likeable=S

User Filter 5 type=String xpath=city likeable=S

User Filter 6 type=String xpath=postal likeable=S

User Filter 7 type=String xpath=activityId

User Filter 8 type=STRING xpath=assetCharacteristics

User Filter 9 type=STRING xpath=assetIdentifiers

User Filter 10 type=STRING xpath=assetDispositionValidate Filter ValuesService Script

ss= W1-AsMdQ1Val

input=[assetType=F1 specification=F2assetCondition=F3 address=F4 city=F5 postal=F6

activityId=F7 assetCharacteristics=F8assetIdentifiers=F9

assetDisposition=F10]



36/42


Management

SQL 1 Condition F1 F10

SQL 1 Display Columns C1

SQL Statement 1 Pseudo SQL1

Column 1 for SQL 1 source=FKREF

fkref='W1-ASSET'

input=[ASSET_ID=ASSET_ID]

label=ASSET_ID


sqlcol=STATUS

label=STATUS

suppress=TRUE


sqlcol=ASSET_TYPE_CD

suppress=TRUE


sqlcol=ASSET_DPOS_FLG

suppress=TRUE


sqlcol=ASSET_ID

suppress=TRUE

Multi Select available=YES

Multi Selection Action 1Script= W1-AstMasUpd (Asset Disposition Mass UpdateBPA Script)

Type=BUTTONLabel=W1_CHANGE_DPOS_LBL (Change Disposition)Refresh=ZONEList=assetListContext=[assetID=C5 assetType=C3 status=C2disposition=C4]

Pseudo SQL 1

SELECTf1_gtt_col1_vchar as ASSET_ID,f1_gtt_col2_vchar as ASSET_TYPE_CD,f1_gtt_col3_vchar as ASSET_DPOS_FLG,f1_gtt_col8_vchar as BO_STATUS_CDFROMF1_GENERIC_GTTWHERE f1_gtt_col3_vchar=:F10

List Contents

Asset Information Information String of Asset



37/42


Design

Dialogue Trigger

The multi select action 1 is a button associated with BPA scriptAsset Disposition Mass UpdateBPA script, passing in a list of Asset ID, Asset Type, Status and Disposition. The button label,

using MD Field, should be Change Disposition. The refresh option should be set to ZONE, i.e.the zone needs to refresh on completion of the script.

Asset Information Filter UI Map (W1-AssetMassDposQ1QryFltr) (New)

This map will be used as a filter area UI map for theAsset Information Queryzone.

Properties

Property ValueCode W1-AssetMassDposQ1QryFltr

Description Asset Information Query Filter


Layout

Contents

Please refer to the Asset Information Search (W1-ASSETQ1) for the details of this Filter UIMap. They should be the same except for the following:

o Asset Type is required.

o Add Disposition (New) as another required filter. The dropdown should be very

similar to the Disposition dropdown in theW1-AssetQ3QryFltrUI Map.

On change of the Asset Type, populate the dropdown values using theW1-AstTypDpn Service Script (Retrieve Asset Disposition for Asset Type)

o No hidden filters



38/42


Management

Note. Refer to 32004 Asset Portal ED for the Asset Information Search (W1-ASSETQ1) and the

W1-AssetQ3QryFltr UI Map

SchemaXml Schema

BPA Scripts

Asset Disposition Mass Update BPA Script(W1-AstMasUpd) (New)

This BPA updates the asset disposition and node of a list of assets.


Code W1-AstMasUpd

Description Asset Disposition Mass Update

Accessibility OptionScript Engine Version




39/42


Design

UI Map W1-AssetMassDposUpdate W1-AssetMassDposUpdate


Asset ID assetId

Asset Type assetType

Status status

Asset Disposition disposition

Xml Schema

Script Steps Loop through Asset List

If the Asset Type (n) is not equal to Asset Type (n+1) or Status (n) is not equal toStatus (n+1), then Terminate with error message:Unable to update Assets with different

Asset Types or Statuses

Get the Asset Relationship flag for the Disposition

Get the Asset Relationship by invoking the Asset Disposition BO (W1-AssetDisposition) for read (passing the retrieved details above)

InvokeAsset Disposition Map Update UI Map. Pass the following current values, which hasbeen ensured to be the same for all elements in the list:

Asset Type

Status (as Current Status)

Disposition (as Current Disposition)

Asset Relationship (as Current Asset Relationship)

Determine the BO of the Asset by calling F1-DetermineBO business service (passing the AssetMO and the Asset ID (1) from the schema). All Assets in the list will have the same Asset BO

Based on the values returned by the UI Map, loop through Asset List and update each Asset:



40/42


Management

Invoke the Asset BO for Read and validate the Effective Date/Time:

If the new Effective Date/Time (from the map) is not later than the EffectiveDate/Time of the current Asset in the list, then

Terminate with error: The new Effective Date/Time (%1) must be laterthan the current Effective Date/Time of this Asset (%2)

Invoke the Asset BO for Update and do group move from Asset Disposition Detail(of the UI Map) to the Asset BO

If there are errors during the update, the whole update will be rolled back. All ornothing applies during the update.

Service Scripts

Validate Asset Information Mass AssetDisposition Filter ( W1-AsMdQ1Val) (New)

This validates the filter for the Asset Information query zone of the Mass Asset Disposition UpdatePortal.


Code W1-AsMdQ1Val

Description Validate Asset Information Mass Asset Disposition Filter

Application Service F1-DFLTAPS

Script Engine Version


Asset Type assetTypespecification Specification

assetCondition AssetCondition

address address

city city

postal postal



41/42


Design

activityId activityId

assetCharacteristics assetCharacteristics

assetIdentifiers assetIdentifiers

Asset Disposition assetDisposition

Script Steps If Asset Type is not populated, then:

Terminate with error:Asset Type is a required criteria for this search

If Asset Disposition is not populated, then:

Terminate with error:Asset Disposition is a required criteria for this search

Note. Since this validation script is used in a Search Zone very similar to the Asset ModulesAsset Information Search, make sure all the validations in that search are included here as well.

Asset Info Query Zone Pre-Processing (W1-AsInfQ1ss) (Update)

This is an existing service script from the 32004 Asset Portal ED that needs to be updated in orderto be used by the Asset Information Query Zone of the Mass Asset Disposition Update Portal.


Data AreaNo changes

SchemaNo changes



42/42


Management

Script Steps On the step that saves the list returned by theW1-RetAstUseAssetInfoBusiness Service, make

sure that the BO Status Code is inserted as colVarchar8.

32012 asset receipt inspection portal external design

Documents