Material Cost Transfer to Projects from Inventory- Steps to be taken
a) Trigger need to be enabled
b) Profile Option Set up –
Set profile option Inv:Project Miscellaneous Transaction to user defined.
c) Set up the Expenditure types using the Cost responsibility (Setup >
Expenditure Type for Cost Elements).
Modified 25-JAN-2001 Type PROBLEM Status PUBLISHED
*************************************************************
This article is being delivered in Draft form and may contain
errors. Please use the MetaLink "Feedback" button to advise
Oracle of any issues related to this article.
*************************************************************
Problem Description
You are doing an issue to projects transaction. The transaction processes
and is costed successfully. However on running the Project Cost Transfer
(Cost Collector) the following error explanation is observed in the Material
Transactions form.
CSTPPCCB.pm_process_txn_mmt(65): ORA-01400: cannot insert NULL into
("PA"."PA_TRANSACTION_INTERFACE_ALL"."TXN_INTERFACE_ID")
Navigation: Transactions/Miscellaneous Transactions
Transactions/Material Transactions
Accounting Close Cycle/Project Cost Transfers
Forms: INVTTMTX INVTVTXN
Cost Collector: CSTPPCCB.pls
Solution Description
--------------------
The column txn_interface_id in table pa_transaction_interface_all is a
NOT NULL column. The trigger pa_transaction_interface_t2 populates this
column. The trigger is either missing or invalid.
The PL/SQL file, PAXTRXT2.pls, is located in: $PA_TOP/admin/sql
Compile this package to resolve the issue.
References
----------
a) Trigger need to be enabled
b) Profile Option Set up –
Set profile option Inv:Project Miscellaneous Transaction to user defined.
c) Set up the Expenditure types using the Cost responsibility (Setup >
Expenditure Type for Cost Elements).
Modified 25-JAN-2001 Type PROBLEM Status PUBLISHED
*************************************************************
This article is being delivered in Draft form and may contain
errors. Please use the MetaLink "Feedback" button to advise
Oracle of any issues related to this article.
*************************************************************
Problem Description
You are doing an issue to projects transaction. The transaction processes
and is costed successfully. However on running the Project Cost Transfer
(Cost Collector) the following error explanation is observed in the Material
Transactions form.
CSTPPCCB.pm_process_txn_mmt(65): ORA-01400: cannot insert NULL into
("PA"."PA_TRANSACTION_INTERFACE_ALL"."TXN_INTERFACE_ID")
Navigation: Transactions/Miscellaneous Transactions
Transactions/Material Transactions
Accounting Close Cycle/Project Cost Transfers
Forms: INVTTMTX INVTVTXN
Cost Collector: CSTPPCCB.pls
Solution Description
--------------------
The column txn_interface_id in table pa_transaction_interface_all is a
NOT NULL column. The trigger pa_transaction_interface_t2 populates this
column. The trigger is either missing or invalid.
The PL/SQL file, PAXTRXT2.pls, is located in: $PA_TOP/admin/sql
Compile this package to resolve the issue.
References
----------