Rvtptcontrol Failed Rvtth-445: 'Subroutine Please define all applicable accounts' When Performing Receipt
(Doc ID 578951.1)
Last updated on DECEMBER 10, 2024
Applies to:
Oracle Inventory Management - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]Oracle iProcurement - Version 11.5.10 and later
Information in this document applies to any platform.
FORM:RCVRCERC.FMB - Enter Receipts GUI
Symptoms
When attempting to do receipt the following error occurs:
Error:
1- iProcurement shows the following error:
Your receipt could not be created successfully due to an unexpected error.
Please contact your system administrator with the following information for further assistance.
"rvtptcontrol failed
RVTTH-445: Subroutine Please define all applicable accounts.
Cause: Accounts have not been correctly defined.
Action: Please verify that all accounts have been defined on
the receiving parameters fo
2- Core Receiving Desktop form shows the following error:
rvtptcontrol failed
RVTTH-445: Subroutine Please define all applicable accounts.
Cause: Accounts have not been correctly defined.
Action: Please verify that all accounts have been defined on the
receiving parameters fo
Steps To Reproduce:
1. Navigate to iProcurement Receive Items
2. Select multiple items to receive.
3. Specify receipt header info and click Next.
4. Click Submit on the Review & Submit page.
5. Get error.
The rcv11i output for the purchase order from <Note 402245.1> shows:
po_system_parameters_all
AUTO_OFFSET_METHOD null
--so None: No substitutions are made and the Receiving Inspection account
for the destination organization is used.
rcv_parameters
ORGANIZATION_ID <org_id>
RECEIVING_ACCOUNT_ID <rcv_acct_id>
CLEARING_ACCOUNT_ID <rcv_acct_id>
RETROPRICE_ADJ_ACCOUNT_ID <retro_adj_acct_id>
RETROPRICE_ADJ_ACCOUNT_ID <retro_adj_acct_id>
So all the accounts are correctly defined
po_distributions_all
All the distribution lines have
CODE_COMBINATION_ID = <code_combo_id>
DESTINATION_TYPE_CODE = EXPENSE
BUDGET_ACCOUNT_ID = NULL
ACCRUAL_ACCOUNT_ID = NULL
VARIANCE_ACCOUNT_ID = NULL
The above BUDGET_ACCOUNT_ID , ACCRUAL_ACCOUNT_ID and VARIANCE_ACCOUNT_ID columns are NULL
po_system_parameters_all
AUTO_OFFSET_METHOD null
--so None: No substitutions are made and the Receiving Inspection account
for the destination organization is used.
rcv_parameters
ORGANIZATION_ID <org_id>
RECEIVING_ACCOUNT_ID <rcv_acct_id>
CLEARING_ACCOUNT_ID <rcv_acct_id>
RETROPRICE_ADJ_ACCOUNT_ID <retro_adj_acct_id>
RETROPRICE_ADJ_ACCOUNT_ID <retro_adj_acct_id>
So all the accounts are correctly defined
po_distributions_all
All the distribution lines have
CODE_COMBINATION_ID = <code_combo_id>
DESTINATION_TYPE_CODE = EXPENSE
BUDGET_ACCOUNT_ID = NULL
ACCRUAL_ACCOUNT_ID = NULL
VARIANCE_ACCOUNT_ID = NULL
The above BUDGET_ACCOUNT_ID , ACCRUAL_ACCOUNT_ID and VARIANCE_ACCOUNT_ID columns are NULL
After setting debug profile options per <Note 299497.1> the fnd_log_messages shows:
po.plsql.RCV_SeedEvents_PVT.Seed_RAEEvent.160 28-MAR-2009 15:21:06 Getting Debit and Credit Accounts
po.plsql.RCV_SeedEvents_PVT.Get_Accounts.begin 28-MAR-2009 15:21:06 Get_Accounts <<
po.plsql.PO_ACCOUNTING_GRP.BUILD_OFFSET_ACCOUNT 28-MAR-2009 15:21:06 Entering
BUILD_OFFSET_ACCOUNT; p_base_ccid: <p_base_ccid> p_overlay_ccid: <p_overlay_ccid> p_accounting_date: 28-MAR-09
po.plsql.PO_ACCOUNTING_GRP.BUILD_OFFSET_ACCOUNT 28-MAR-2009 15:21:06 Automatic offset method:
po.plsql.RCV_SeedEvents_PVT.Get_Accounts.50 28-MAR-2009 15:21:06 x_debit_acct_id : <x_debit_acct_id>
x_credit_acct_id : x_ic_cogs_acct_id :
po.plsql.RCV_SeedEvents_PVT.Get_Accounts.50 28-MAR-2009 15:21:06 Unable to find credit and/or
debit account. Setup is incomplete.
po.plsql.RCV_SeedEvents_PVT.Seed_RAEEvent160 28-MAR-2009 15:21:06 Seed_RAEEvent : 160 : Error
getting account information
po.plsql.RCV_AccEvents_PVT.Create_ReceiveEvents140 28-MAR-2009 15:21:06 Create_ReceiveEvents : 140
: Error creating event
po.plsql.RCV_SeedEvents_PVT.Seed_RAEEvent.160 28-MAR-2009 15:21:06 Getting Debit and Credit Accounts
po.plsql.RCV_SeedEvents_PVT.Get_Accounts.begin 28-MAR-2009 15:21:06 Get_Accounts <<
po.plsql.PO_ACCOUNTING_GRP.BUILD_OFFSET_ACCOUNT 28-MAR-2009 15:21:06 Entering
BUILD_OFFSET_ACCOUNT; p_base_ccid: <p_base_ccid> p_overlay_ccid: <p_overlay_ccid> p_accounting_date: 28-MAR-09
po.plsql.PO_ACCOUNTING_GRP.BUILD_OFFSET_ACCOUNT 28-MAR-2009 15:21:06 Automatic offset method:
po.plsql.RCV_SeedEvents_PVT.Get_Accounts.50 28-MAR-2009 15:21:06 x_debit_acct_id : <x_debit_acct_id>
x_credit_acct_id : x_ic_cogs_acct_id :
po.plsql.RCV_SeedEvents_PVT.Get_Accounts.50 28-MAR-2009 15:21:06 Unable to find credit and/or
debit account. Setup is incomplete.
po.plsql.RCV_SeedEvents_PVT.Seed_RAEEvent160 28-MAR-2009 15:21:06 Seed_RAEEvent : 160 : Error
getting account information
po.plsql.RCV_AccEvents_PVT.Create_ReceiveEvents140 28-MAR-2009 15:21:06 Create_ReceiveEvents : 140
: Error creating event
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |