My Oracle Support Banner

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 later
Information 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


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