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

Supplier Import Error : AP_VEN_DUPLICATE_NAME

When performing Supplier Import you might be faced with an Error : AP_VEN_DUPLICATE_NAME .

The Oracle Supplier Import API has a check that the Oracle system (ap_suppliers) should not have a vendor with the same name as the vendor being created. If a match is found the record will be errored in import and error will be inserted in the table AP_SUPPLIER_INT_REJECTIONS with the error code : AP_VEN_DUPLICATE_NAME

Thanks

AutoInvoice Error : The supplied unit of measure and the primary unit of measure of your system item must share the same unit of measure class

When Importing Data via AutoInvoice we get an error : The supplied unit of measure and the primary unit of measure of your system item must share the same unit of measure class

This error occurs due to the below reasons:

The item has not been assigned to the warehouse for which the data is trying to be imported.

The item UOM definition and the setup are different.

Thanks

API To Update Bank Branch Details

Oracle has provided an API to update the bank branch details:

     IBY_EXT_BANKACCT_PUB.update_ext_bank_branch (
          p_api_version                => 1.0,
          p_init_msg_list              => FND_API.G_TRUE,
          p_ext_bank_branch_rec        => l_bank_branch_rec,
          x_return_status                 => l_chr_return_status,
          x_msg_count                    => l_num_count,
          x_msg_data                     => l_msg_data,
          x_response                      => x_response_rec
                    );

l_bank_branch_rec is BANK BRANCH record type variables. The mandatory parameters to be passed to the API are as below:

bank_party_id => Bank Id
branch_party_id => Branch Id
branch_name => branch_name
branch_number => branch_number
branch_type  => branch_type
alternate_branch_name => alt branch name
bch_object_version_number ,typ_object_version_number ,rfc_object_version_number ,eft_object_version_number => Bank Branch object version number derived from iby_ext_bank_branches_v.

In case of successful Update the API will return 'S'  , In case of errors use the below code snippet to display the error messages:

FOR i IN 1 .. l_num_count
           LOOP
              fnd_msg_pub.get (
                 p_msg_index       => -1,
                 p_encoded         => 'F',
                 p_data            => l_msg_data,
                 p_msg_index_out   => l_msg_index_out);

              fnd_file.put_line(fnd_file.LOG,
                 'Error in Bank Branch Updation  ' || l_msg_data);
              l_chr_val_ret_msg :=
                 l_chr_val_ret_msg || '  ' || l_msg_data;
             
END LOOP;

Thanks