AutoInvoice Line Transaction flex field Error

When importing invoices by the Autoinvoice Import Program , many times we are faced with the error : Please provide a value for the line transaction flexfield.
If we check the setup we see that even though the flexfield has been enabled in the setup the Requeired flag is not checked. How ever Auto invoice when importing the invoice does not check for the required flag being set or not. If the Flexfield is enabled Oracle expects a value to be provided in the interface if the value is not provided the record will be errored out in import.

Moreover the combination of the flexfield values need to be unique , else we will get the error : This line has the same transaction flexfield as another row in the interface table.  For each transaction line, the
               combination of interface_line_context and interface_line_attribute values must be unique

Auto Invoice Error : Please enter quota sales credit percentages that equal 100 percent for this line.

When running the autoinvoice import program you might be faced with the error :
Please enter quota sales credit percentages that equal 100 percent for this line. This error comes if we have multiple records in the table ra_interface_salescredits_all for one invoice line record and the sum of column : SALES_CREDIT_PERCENT_SPLIT is not equal to 100.
 

Supplier Import Error :POS_SPM_CREATE_SUPP_ERR1

During Supplier Import you may be faced with an error : POS_SPM_CREATE_SUPP_ERR1 . This error is reported if there already exists a record in ap_suppliers/ap_supplier_Sites_All with the same VAT_REGISTRATION_NUM as the current record being errored out.

Oracle does not allow creation of 2 suppliers with the same VAT numbers via supplier import. If needed you can import the suppliers by making these VAT  numbers as null and then hard update the Oracle base table column : VAT_REGISTRATION_NUM with the required value,

Thanks