Saturday, July 25, 2009

Using Personalization how to make Warehouse Field Mandatory on Order Entry Screen

Personalization steps to make Warehouse field mandatory on Order entry screen with a condition to be mandatory for specific Order line type (eg Backorder):

Navigation: Help>Diagnostics>Custom Code > Personalize.

1. Enter Seq:10
Description : Warehouse Mandatory
Level:Function
Condition:
Trigger Event:WHEN-NEW-FORM-INSTANCE
process:Both



Context:
Responsibilites: please assign the responsibilites (order management) as required.
Actions Tab:
Seq:1
Type: Property
Language: All
Enabled:Checked
Object Type:Item
Target Object:LINE.SHIP_FROM_MIR
Porperty Name:Required
Value:TRUE




2.Enter Seq:20
Description:Show message when trying to save with null value in mandatory warehouse field
level:Function
Condition:
Trigger Event:WHEN-VALIDATE-RECORD
Trigger Object:Line



Condition:
:LINE.SHIP_FROM_MIR IS NULL
and ((:LINE.ORG_ID=X and :LINE_TYPE<>1001)
OR(:LINE.ORG_ID=Y and :LINE_TYPE<>1025
Processing Mode: Both

Note: please check the line_type or order type id which need to be included in the above condition in this for back order line type id.

Context:
Responsibility: assign the list of responsibilities as required.

Action Tab:
Enter Seq:10
Type:Message
Language: All
Enabled:checked
Message Type:error
Message Text:Please Enter a Warehouse



When users enter orders with out a warehouse they cannot book the order and they get a popup message please enter a warehouse.

Responsibility Not Visible to user in the list of responsibilites assigned to User:

Recently came to know that though the system adminstrator is given the responsibility access to users, users are not able to view the responsibilities in the list of responsibilities assigned.


1. Check if the responsibility is not end dated.
2. Run the request " Syn responsibility role data into the WF table".
3. Run the request " Synchronize WF LOCAL tables" enter the paramters
- Orig System: ALL
- Parallel Process:0
- Logging Mode: LOGGING (Logging Activated)
- Temporary Tablespace : Blank
- Riase Errors: Yes
4. Run the request "Workflow Directory Services User/Role Validation" enter the paramters
- p_BatchSize:10000
- Fix dangling user/roles : Yes
- Add missing user/role assignments : Yes
- Update WHO columns in WF tables: Yes
5. Log off and login back and verify that the responsibility appears.

That should resolve the issue.


If the problem is not resolved still ask the sysadmin to start the following servives
Navigation: System Administrator > Workflow > Oracle application manager > Workflow Manager
- Workflow Deffered Notification Agent Listner
- Workflow Error Agent Listner
- Workflow Java Deffered Agent Listner
- Workflow Java Error Agent Listner.

In case still there is a issue please raise a Service request with Oracle.