Re: Commitment Control - Duplicate Key

Thanks, Charles.

So you were able to perform an insert under commitment control for an
item that already existed, thereby creating an additional PT journal
entry?

I wanted to make sure that this wasn't some O/S bug that I needed to
fix.

Not to get into to much detail, but this additional journal entry causes
issues down the line for me.

Of course the system that is trying to create the item that already
exists (the Oracle Transparent Gateway) should already know that the
item exists.

James Salter
Systems Programmer
American Cast Iron Pipe Company
phone (205) 325-3033
fax (205) 307-3833



from: Charles Wilt <charles.wilt@xxxxxxxxx>
subject: Re: Commitment Control - Duplicate Key

James,

I don't have any links for you....but playing around with the
issue...I notice that the PT entry only shows up if the record was
inserted under commitment control.

Charles


On Wed, May 20, 2009 at 10:14 AM, Salter, James <JSalter@xxxxxxxxxx>
wrote:

I have a situation where we have a record that already exists in the
database (uniquely keyed file), yet I am seeing PT journal entries for
the same item under commitment control and a follow up DR journal

entry.

The commitment control process was never committed, it errored out and
was rolled back.

Can you have PT journal entries under commitment control for records
that already exist?

Documentation or a link to where this is possible would be

appreciated,

otherwise it looks like a call to IBM.

Thanks.
James Salter
Systems Programmer
American Cast Iron Pipe Company
phone (205) 325-3033
fax (205) 307-3833

_________Confidentiality Notice_______________________
This e-mail and any files transmitted with it is
confidential and is intended solely for the use of
the individual(s) or entity(ies) to whom this e-mail
is addressed. If you are not the intended recipient
or the person responsible for delivering the e-mail
to the intended recipient, be advised that you have
received this e-mail in error, and that any use,
disclosure, dissemination, forwarding, printing,
retention or copying of this e-mail is strictly
prohibited. If you have received this e-mail in
error, please immediately return this e-mail to
the sender and delete the e-mail from your system.
Thank you.