Hi Everybody,
I am facing problem while invoice Processing.
We have Invoice_Header table and Invoice_Lines Table.
One Record in Invoice_Header table can have multiple related records
in Invoice_Lines.
We have not implemented locking mechanism at header level. So
whenever two user working on same invoice it creates problem.
Say One Invoice has 10 lines in Invoice_Lines Table and first user
pressed the <Process Invoice> button. It does so many validation and insert
records in subledger. Mean while another user can add new lines in same
Invoice result is discrepancy in printed copy and system records.
Can anybody tell me how to resolve this issue.
Thanks
Suman
DISCLAIMER: Information contained and transmitted by this E-MAIL is
proprietary to Mascot Systems Limited and is intended for use only by the
individual or entity to which it is addressed, and may contain information
that is privileged, confidential or exempt from disclosure under applicable
law. If this is a forwarded message, the content of this E-MAIL may not have
been sent with the authority of the Company. If you are not the intended
recipient, an agent of the intended recipient or a person responsible for
delivering the information to the named recipient, you are notified that any
use, distribution, transmission, printing, copying or dissemination of this
information in any way or in any manner is strictly prohibited. If you have
received this communication in error, please delete this mail & notify us
immediately at [EMAIL PROTECTED] Before opening attachments,
please scan for viruses.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suman S K
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
