My Oracle Support Banner

Parts Requirement Requisition Has Null Value In Po_req_distributions_all.budget_account_id (Doc ID 1569473.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Field Service - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 06-SEP-2016**


On : 12.1.3 version,

When a parts requirement is created and this function creates an internal requisition and an internal order, the created requisition has a null value in the po_req_distributions_all.budget_account_id field.
When the order is shipped and received, the corresponding receiving transactions fail in cost manager because the encumbrance account is not populated. Manually created requisitions work fine.

Cost Manager Error: CSTPACIN.COST_INV_TXN:CSTPACDP.insert_account (10) ORA-01400: cannot insert NULL into ("INV"."MTL_TRANSACTION_ACCOUNTS"."REFERENCE_ACCOUNT"

The issue can be reproduced at will with the following steps:
1. Create a parts requirement in Field Service
2. Create Order
3. Ship the Order
4. Cost the transaction
5. Cost manager will complete with error




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.