EBS 12.2.9
12c
OL7
Hi ALL,
We encounterd error when running EBS lockbox below:
+---------------------------------------------------------------------------+
Receivables: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
ARLPLB: Process Lockboxes
+---------------------------------------------------------------------------+
Current system time is 18-JUN-2020 15:22:42
+---------------------------------------------------------------------------+
Starting ARLPLB
Input parameters:
Y
700-01-210_2
Y
/LCC/LBBPI/DATA/700-01-210.001
arplbox
1000
Y
N
2020/03/31 00:00:00
R
Y
N
Y
82
1
L
Scoring model Id is NULL
Lockbox id is NULL.
Inserted ar_transmissions record
Control file: /ua03/appcrp2/LCCCRP2/fs1/EBSapps/appl/ar/12.0.0/bin/arplbox.ctl
Bad file: /ua03/appcrp2/LCCCRP2/fs_ne/inst/LCCCRP2_lccatest/logs/appl/conc/log/b811623.bad
Log file: /ua03/appcrp2/LCCCRP2/fs_ne/inst/LCCCRP2_lccatest/logs/appl/conc/log/l811623.log
Discard file: /ua03/appcrp2/LCCCRP2/fs_ne/inst/LCCCRP2_lccatest/logs/appl/conc/log/d811623.dis
Username:
SQL*Loader: Release 10.1.0.5.0 - Production on Thu Jun 18 15:22:42 2020
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Commit point reached - logical record count 64
Commit point reached - logical record count 128
Commit point reached - logical record count 192
Commit point reached - logical record count 220
AR-ARLPLB: Statistics Gathered On Interface Table.
autoapply_flag : N
2001
10005
6
4
L700
N
rows updated : 012
AR-ARLVLN: Error from arlvcr.
¿1¿8 ¿ ORA-06550: line 1, column 5689:
PL/SQL: ORA-00913: too many
AR-ARLVCB: arlvcr returned FALSE
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
No completion options were requested.
Output file size:
564
AR-ARLVCB: work has been rolled back.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 18-JUN-2020 15:22:56
+---------------------------------------------------------------------------+
Please help....
Kind regards,
jc