OKL_EXT_BILLING_CHARGES_PVT does not Update OKL_EXT_BILLING_INTF_ALL.tai_id
(Doc ID 2707679.1)
Last updated on SEPTEMBER 08, 2020
Applies to:
Oracle Lease and Finance Management - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.5 version, Billing Modules
ACTUAL BEHAVIOR
---------------
Find that OKL_EXT_BILLING_CHARGES_PVT does not update OKL_EXT_BILLING_INTF_ALL.tai_id.
When creating invoices using concurrent program OKL_THIRD_PARTY_BILLING_IMPORT (Third Party Billing Import) the column TAI_ID is not set. They need to link the OKL_EXT_BILLING_INTF_ALL back to OKL_TRX_AR_INVOICES_B after creating invoices for a custom extension and don't have a way to join the two tables directly.
eTRM defines OKL_EXT_BILLING_INTF_ALL.tai_id as:
TAI_ID NUMBER Foreign key to table OKL_TRX_AR_INVOICES_B
EXPECTED BEHAVIOR
-----------------------
Expect OKL_EXT_BILLING_CHARGES_PVT to update OKL_EXT_BILLING_INTF_ALL.tai_id.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populate table: OKL_EXT_BILLING_INTF_ALL
2. Run concurrent program: OKL_THIRD_PARTY_BILLING_IMPORT (Third Party Billing Import).
If successful, the column TRX_STATUS_CODE will be set to PROCESSED and TAI_ID will be null (instead of the foreign key ID).
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 |
Cause |
Solution |
References |