APP-PJM-58055

Copyright (c) 2018, Oracle. All rights reserved.

单击此项可添加到收藏夹 PJM org: Unable To Transact Move Order Gets Error APP-PJM-58055 Project References Are Not Allowed For the Locator for this transaction (文档 ID 1966181.1) 转到底部转到底部

In this Document


Symptoms

Changes

Cause

Solution
  1. Mismatch Locator
  2. Mismatch Cost Group

References


APPLIES TO:

Oracle Inventory Management - Version 12.0.0 and later
Information in this document applies to any platform.

SYMPTOMS

INV: Unable to Transact move order that is connected to PJM. Error APP-PJM-58055 Project References 

While shipping an order that is project related, the transact move order (INV) was unable to be performed due to message "APP-PJM-58055 Project References Are Not Allowed For the Locator for this transaction"

Cause: The transaction Does not have project references

Action: Remove the Project References in the locator

error
 

Facts /check list:

1) There is on hand in the source Subinventory and Locator, there are no reservations for other sales orders etc affecting avalability.

2) The source Locator is a project locator. You have validated that in mtl_item_locations, the record for the locator shows in Segment 19 and Segment20 values correspond to a valid open project and task, same for PROJECT_ID, TASK_ID columns. PHYSICAL_LOCATION_ID is not null, SUBINVENTORY_CODE matches that of the on hand, locator enabled_flag is Y.  

3) The Project Manufacturing parameters in PJM org shows:

Enable Project References = checked (1)

Allow Cross Project Issues = Unchecked (2)

4) The expectation is not to move the on hand from one project to another project, but to move it from the current subinventory/locator where it resides to another one to allow shipping of the order.

5) The item is an asset (inventory item), not an expense item. Also the source subinventory is an Asset subinventory.

6) When you implement Project Manufacturing PJM you need to assign projects to the PJM organization to be able to use them in your Inventory asset item transactions:

Navigate to Project Manufacturing > Projects > Project Parameters form.

the project you are using in the project locator needs to be listed, Cost Group needs to be populated. Check table pjm_project_parameters for cost group id.

7) Check data in mrp_project_parameters table: the corresponding project_id and inv organization_id should be listed, and the costing_group_id should match that of the moqd mtl_onhand_quantities_detail for the corresponding on hand record.

8) Key Flexfield Segments: Application = Inventory, Stock Locator should show Allow Dynamic Inserts = Yes

9) The Move order transaction type is a User created transaction with details:

source Type = Move Order

Action = Issue from stores

Project flag = checked

 

CHANGES

INV Debug shows:

 BUILD_TREE Entered
[20-JAN-15 00:57:11] INV_QUANTITY_TREE_PVT:     ADD_QUANTITIES Entered
[20-JAN-15 00:57:11] INV_QUANTITY_TREE_PVT:       for node: rev=A lot= sub=FG-CONFIG  loc=15684  lpn=..with qty type=5 qty=4      action=28 xfrsub=SHIPPING xfrloc=

notice xfrloc is null

CAUSE

1. The first cause was a mismatch in the locator control of the subinventories. The move order attempted to move from a source with a project locator to a destination subinventory that was not locator enabled. Also it was using auto allocate and auto pick confirm.

2. A second cause related to a cost group mismatch.

SOLUTION

1. Mismatch Locator

Change destination Subinventory to be Locator Control = Dynamic entry. When performed the Move order allocation and transaction, system created new locator with same project and task as the one listed in MTL_ONHAND_QUANTITIES_DETAIL (MOQD) for the corresponding on hand record. Also, since the transaction involves serial number auto pick and auto allocate should be run as no while running pick slip, else the line use to back order.

Another possible option is a hook introduced allowing custom logic. See Note 2094311.1 for details. (Abstract: Project Manufacturing Hook - PJM_CUSTOMER_HOOK.tmo_proj_to_non_proj_use_hook? -- Add Flexibility to Transact Move Orders With Projects )

2. Mismatch Cost Group

Also, please review this note for cost_group_id requirements:
INV: Unable to Issue Out On-hand Item with Project and Task: Direct Inter Org Transfer Gets "Transaction processor error Negative balances not allowed" but there is no Reservation For On-Hand (Doc ID 1684343.1)

To implement the solution, please execute the following steps in a Test instance:

1. Download and review the readme and pre-requisites for the appropriate patch version:

Product Version Fixed File and Version Patch
12.1+ PJMCTHKB.pls 120.0.12010000.2 18663551:R12.PJM.B
12.2+ PJMCTHKB.pls 120.2.12020000.2 18663551:R12.PJM.C

 

 

 

2. Ensure that you have taken a backup of your system before applying the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file version per above:
PJMCTHKB.pls

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.

REFERENCES

NOTE:1912232.1 - Transact Move Order Fails: APP-PJM-58055 Project References Are Not Allowed For EAM Move Order
NOTE:1684343.1 - INv: Unable to Issue Out On-hand Item with Project and Task: Direct Inter Org Transfer Gets "Transaction processor error Negative balances not allowed" but there is no Reservation For On-Hand 
NOTE:367511.1 - Fix for Cost Group ID when Negative Balances Not Allowed Error
NOTE:2094311.1 - Project Manufacturing Hook - PJM_CUSTOMER_HOOK.tmo_proj_to_non_proj_use_hook? -- Add Flexibility to Transact Move Orders With Projects
请使用浏览器的分享功能分享到微信等