Thursday, 7 November 2013

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

Monday, 7 October 2013

LDT Files For Lookups

The Below Commands can be used to Download and upload LDT files for Lookups:

Download / Generate : FNDLOAD userid/pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct /server_path/lookup_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME ='AU' LOOKUP_TYPE='lookuop_type'

Upload : FNDLOAD userid pwd O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct lookup_name.ldt . Please ensure you are at the server folder where the LDT is placed when running this command.

Tuesday, 10 September 2013

Purchase Order Import Error : Error: Can not derive item_id for the specified buyer item_number or vendor_product_num PO_PDOI_DERV_PART_NUM_ERROR

The above error at the first look gives the impression of the customer item number setup issue. But if you face this error check the below things:

  • Is the item assigned to the receving org specified in the PO
  • Is the item assigned to the IVO of the receiving org.
Take the necessary corrective action and re-import.