Unable to Search for Move Orders Created by Other Users on Find Move Orders (Doc ID 280131.1)

摘自：https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=245901104141807&id=280131.1&_adf.ctrl-state=3met3uf4_52

APPLIES TO:

Oracle Inventory Management - Version 11.5.9 and later
Information in this document applies to any platform.
FORM:INVTOMAI.FMB
Issue and resolution apply both to R11i and R12


 

SYMPTOMS

In the Move Orders form (INVTOMAI), when using the Find function, the Created By field cannot be
changed. For this reason, move orders from other users cannot be queried.

Also the following error might occur:

APP-INV-05507: There were no Move Order records found

CAUSE

The security function INV_INVTOMAI_CREATOR is not enabled in the menu being used. The form INVTOMAI.fmb within the Package TOMAI_MENU and PROCEDURE CREATED_BY_CHECK checks for the function INV_INVTOMAI_CREATOR. If it is not enabled for the user, the Created By field is not updatable.

The Sub function INV_INVTOMAI_CREATOR may not be defined in sysadmin, and thus is not part of Menu INV_MOVE_ORDER

 

SOLUTION

To implement the solution, execute the following steps to enable the INV_INVTOMAI_CREATOR function:

A. Define the INV_INVTOMAI_CREATOR function if is does not already exist:

1. Navigate: System Administrator > Application > Function
2. Enter Function Name: INV_INVTOMAI_CREATOR
3. Enter User Function Name: 'Move Orders Creator'
4. Under the Properties tab, enter Type: Subfunction
5. Enter Maintenance Mode support: None
6. Enter Context Dependence: Responsibility
7. Save

B. Assign the function to the Menu you are using:

1. Navigate System Administrator > Application > Menu
2. Query for menu 'INV_MOVE_ORDER'
3. Add a new line to the menu:
   Prompt: 'Move Order Creator'
   Function: select 'Move Orders Creator' from the LOV
   Description: 'Move Orders Creator'
4. Save

The Created By field in the Move Order find form should now be enabled and modifiable. You may need to sign out and back in for the change to take affect.

REFERENCES

BUG:3396638 - CANNOT QUERY ON MOVE ORDERS FOR OTHER USERS

需求：MO无法查询他人开立信息

测试：依上述解决方案作业

结果：OK