Categories
Project Manufacturing Purchasing

Project Borrow/Payback – Warning at Receipt

A little Project Manufacturing geekery here. PJM allows you to borrow from one project and pay back ¬†at a later date. There’s a nice dashboard that shows which project has borrowed which items from a lending project and functionality in ASCP that suggests a buy to pay back the borrowed item. But there’s nothing that triggers the stockroom to do the payback transaction when they receive this PO.

This personalization was to provide that functionality.

Details of the personalization are below:

The trigger is:

(SELECT COUNT(*) FROM
PJM_BORROW_TRANSACTIONS b,
PJM_BORROW_PAYBACKS p,
PJM_SEIBAN_NUMBERS s
WHERE :rcv_transaction.item_id =b.inventory_item_id
and :rcv_transaction.project = s.project_number
and b.borrow_project_id = s.project_id
and (b.loan_quantity)-(NVL((p.payback_quantity),0))>0
and b.borrow_transaction_id = p.borrow_transaction_id(+)
)>0

The message is:

=select ‘This project, ‘||:rcv_transaction.project||’, owes ‘||to_char((b.loan_quantity)-(NVL((p.payback_quantity),0)))||’ of this item to project ‘||sb.project_number||’.Please perfom a project payback transaction.’
FROM PJM_BORROW_TRANSACTIONS b,
PJM_BORROW_PAYBACKS p,
PJM_SEIBAN_NUMBERS sa,
PJM_SEIBAN_NUMBERS sb
WHERE b.borrow_transaction_id = p.borrow_transaction_id(+)
AND b.borrow_project_id = sa.project_id
AND b.lending_project_id = sb.project_id
and sa.project_number = :rcv_transaction.project
and b.inventory_item_id = :rcv_transaction.item_id

Categories
Inventory Project Manufacturing

Item Shortage Checks & Project Manufacturing

We were wondering why we only got shortage warnings some of the time when we were doing PO¬†receipts. A Service Request and many trace files later, Support let us know that were were experiencing intended functionality. The shortage checking functionality considers total on-hand and does not consider projects at all. So, if you have none on hand in your project’s inventory and have a shortage on a job for that project, you will not receive a shortage message during PO receipt if inventory exists in another project.

We logged an enhancement request, but we know how they go…

Categories
Project Manufacturing

Oracle Project Manufacturing

I’ve been working with Support, Development and Product Management for the last few weeks to clarify some of the functionality around Project Manufacturing and how it integrates with other modules.

My client is using Advanced Supply Chain Planning, Work in Process and Inventory in a Project Manufacturing environment. We’ve seen that, by setting the Reservation Level to Planning Group in the ASCP options, we can use excess supply from other projects within the planning group for a particular project. When we release the job created from the Planner Workbench and pick release the components, the Component Pick Release function releases these materials from other projects within the planning group. Our issue comes when we try to transact the resulting Move Order and move the components into the staging subinventory. The Move Order Transaction fails because a project transfer is required during the move.

Strangely, if we navigate to the View/Update Allocations screen and transact from there, the move order processes successfully and the project transfer is effected.

Support told us that the error message is intentional and that our ability to process the transaction from the Allocations screen is a mistake. They intend to prevent this with a patch in the near future.

Project Manufacturing Development recommends that on-hand balances are reviewed for project ownership prior to running pick release and that project transfers are done were necessary before pick release is run. This is difficult for the client, as some WIP jobs include 200-300 components and a manual review would slow down the process considerably. They intend to continue to use the “backdoor” approach and avoid applying th patch that will stop them.

We understand that more than one customer has logged an enhancement request so that this functionality is available.