Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> 6508 error in oracle financials

6508 error in oracle financials

From: Jeffrey Beckstrom <>
Date: Mon, 31 Jul 2000 13:45:46 -0400
Message-Id: <>

Runnnig Financials 10.7 NCA.

Users in AP trying to approve/cancel invoices getting package errors.=20 APP-1000: ORA-06508: PL/SQL: could not find program units being called = occured in AP_FUNDS_CONTROL_PKG.funds_reserve<AP_APPROVAL_PKG.Appproval<APX= INWK ..... or=20
the package will be AP_INVOICES_POST_PROCESS_PKG.post_forms_commit<APXINWKB=

with parameters.....=20
No new patches/changes have been made in months. Invalid objects have been = checked and corrected. Errors on occassion. User can logout of app and log = back on and then continue error free for a while.

Anybody have any ideas. As mentioned no Financials changes done in over 6 = months. Just started failing last week. If user gets error, logs out and = in and then works again!!! This function is heavily used and now fails = sporadically.

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204

 From: "Eric D. Pierce" <>  Date: Mon, 31 Jul 2000 10:52:39 -0700
 Subject: Re: Off topic --- How you give weekly status report ???

I met an amusing german engineer who had recently become a manager at a silicion valley company (while at my favorite slightly grungy ski mountaineering institute near Lake Tahoe several years ago). During apres ski conversation, he said that the basic rule in corporate, or any other, work bureaucracy was to *ALWAYS* tell the people above *what they want to hear*, which is basically that "EVERYTHING IS WONDERFUL" (regardless of how bad it actually is).

This has some interesting implications, which I'm sure the more expert members of the list can elaborate on, as required. :)


ps, for more resources type "BOFH" into a www search.

Date sent:      	Mon, 31 Jul 2000 06:56:14 -0800
To:             	Multiple recipients of list ORACLE-L <>
From:           	"Oak, Sameer" <>
Subject:        	Off topic --- How you give weekly status report ???

> I have a basic question about how Oracle DBA's give the weekly status report
> ???


 From: "William Beilstein" <>  Date: Mon, 31 Jul 2000 13:56:26 -0400
 Subject: Re: Export - Compress

I think what he is talking about is the COMPRESS option of the Oracle EXP = module, not export file compression.

>>> "I.S. Manager" <> 07/31/00 12:08PM >>>
That would be very system-dependant. Compression is highly cpu-intensive. If you have the system to yourself, that won't be a bottleneck, but on a busy system, it could slow things down.
With compression off, you require more disk i/o. But if your disk controller has lots of buffering, this may not be a bottleneck. Basically, the answer is non-deterministic, and the only way to find out = is
to test in your environment.

At 07:16 AM 7/31/00 -0800, you wrote:
>Small question :
>Which is fastest, an export with Compress =3D Y or an export with =
Received on Mon Jul 31 2000 - 12:45:46 CDT

Original text of this message