ASN receipt
Dear Team,
we are receiving ASN through standard forms (Receipts) ,at the same time there is an integration exist for the same with scale system
In some cases users manually receipting the ASN in oracle forms ,So when integaration pushing the data for same ASN details it is errored out in staging table
here before pushing data to Standard interface tables we have staging tables created we have created a package to validate the staging table records and only pushing the valid records to
what are the unique fields that we can refer while receipting ASN to limit this integration issue