My Oracle Support Banner

ELA: CA_PROC_OND Is Failing With Error "Business Unit: Invalid Identifer" (Doc ID 2462693.1)

Last updated on FEBRUARY 03, 2019

Applies to:

PeopleSoft Enterprise FIN Lease Administration - Version 9.2 and later
Information in this document applies to any platform.

Symptoms


When running the Interface to AP/Billing the following error occurs.

ERROR
-------
-- 10:44:36.296 ........(RE_ACCTG_DST.Round.Step02) (SQL)
UPDATE PS_CA_BI_PSA_TA44 SET GROSS_EXTENDED_AMT = GROSS_EXTENDED_AMT + (
SELECT A.DIFFERENCE_AMT FROM PS_RE_RNDAMT_TAO4 A WHERE A.CA_TXN_ID =
PS_CA_BI_PSA_TA44.CA_TXN_ID AND A.DIFFERENCE_AMT <>0) WHERE EXISTS ( SELECT
B.DIFFERENCE_AMT FROM PS_RE_RNDAMT_TAO4 B WHERE B.CA_TXN_ID =
PS_CA_BI_PSA_TA44.CA_TXN_ID AND B.DIFFERENCE_AMT <> 0) AND DISTRIBUTION_ID =
1 AND BUSINESS_UNIT = '300'
/
-- Row(s) affected: 0
-- 10:44:36.304 Process 4478066 ABENDED at Step RE_ACCTG_DST.Round.Step02 (Action SQL) -- RC = 904
ROLLBACK
/
-- 10:44:36.307 SQL Error: ORA-00904: "BUSINESS_UNIT": invalid identifier

 

REPLICATION

---------------

1. Create a Receivable Lease. Activate the lease
2. Run Transaction Generator
3. Run RE_TXN_INTFC to send payment to Billing

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.