Receivables & Collections

Get Involved. Join the Conversation.

Topic

    venkatesan vs
    Customer upload through FBDI
    Topic posted February 6, 2019 by venkatesan vsGreen Ribbon: 100+ Points, tagged Receivables 
    170 Views, 4 Comments
    Title:
    Customer upload through FBDI
    Summary:
    Customer upload - no record processed, no error , but completed sucessfully
    Content:

    I try to upload customer through FBDI , How to Upload Customer Using FBDI (Doc ID 2175412.1).

    Followed the  steps given in this meta link note - 2175412.1. When I load the customer’s , all concurrent request are completed

    Successfully. But no records is imported. I went through Customer Data Management -> Data Import

    The request showing completed. But it is showing zero record processed and imported.

     

    1. What is the issue ?
    2. Why it is not processed any records ? it is not showing any error also?

     

     

    Version:
    R13
    Image:

    Comment

     

    • Leaman Crews

      Please provide a list of all steps you took, and the logs for each process. 

    • Suresh Kumarasamy

      I believe this batch not populated or it may contain tailing space with batch ID in customer spreadsheet. Please check the sheet or share the uploaded sheet.

    • venkatesan vs

      Yes , please find the log file in the attachment.

      log file showing 1 row successfully loaded. but , in the Data Import Batch showing - zero records.

       

      Table HZ_IMP_ACCOUNTS_T:
        1 Row successfully loaded.
        0 Rows not loaded due to data errors.
        0 Rows not loaded because all WHEN clauses were failed.
        0 Rows not loaded because all fields were null.

      Space allocated for bind array:                 255346 bytes(23 rows)
      Read   buffer bytes: 1048576
      Total logical records skipped:          0
      Total logical records read:             1
      Total logical records rejected:         0
      Total logical records discarded:        0
      Run began on Wed Feb 06 13:50:36 2019
      Run ended on Wed Feb 06 13:50:36 2019
      Elapsed time was:     00:00:00.13
      CPU time was:         00:00:00.03
      • Suresh Kumarasamy

        HI,

        This log is from UCM to Interface table, i believe the batch id is not passed in to the customer excel file. if you share the customer upload excel template, the issue can be identified.