Lockbox Error : AR-ARLPLB ORA-01458: Invalid Length Inside Variable Character String ,when Called via FND_REQUEST API (Doc ID 2065008.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
ARLPLB Process Lockboxes

Symptoms

On : 12.1.3 version, Receipts Related

Process Lockboxes in Error

ERROR
-----------------------
AR-ARLPLB: -1458 ORA-01458: invalid length inside variable character string

STEPS
-----------------------
Receivable manager -> Interfaces -> Lockbox
 
Because of this, user find discrepancy in importing receipts.

For this error, Please refer  below sample parameters list passed for calling lock-box program via API :

Parameters :

=========

  1. New transmission (Y/N) (NEW_TRANSMISSION)
  2. transmission_id (LB_TRANSMISSION_ID)
  3. original request id (ORIG_REQUEST_ID)
  4. transmission name (TRANSMISSION_NAME)
  5. submit import (Y/N) (SUBMIT_IMPORT)
  6. data-file (DATA_FILE)
  7. control file (CNTRL_FILE)
  8. transmission format id (TRANSMISSION_FORMAT_ID)
  9. submit validation (Y/N) (SUBMIT_VALIDATION)
  10. pay unrelated invoices (Y/N) (PAY_UNRELATED_INVOICES)
  11. lockbox ID (LOCKBOX_ID)
  12. gl date (GL_DATE)
  13. report format (REPORT_FORMAT)
  14. complete batches only (Y/N) (COMPLETE_BATCHES_ONLY)
  15. submit post-batch (Y/N) (SUBMIT_POSTBATCH)
  16. alternate name search option (ALTERNATE_NAME_SEARCH)
  17. post partial amount or reject entire receipt (Y/N) (IGNORE_INVALID_TXN_NUM)
  18. USSGL transaction code (USSGL_TRN_CODE)
  19. Organization Id (ORG_ID)
  20. Apply Unearned Discount (Y/N) (APPLY_UNEARN_DISC)
  21. Number of Instances (1-99) (NO_OF_INSTANCES)
  22. Source type flag (S – SmartCash or L - Lockbox) (SOURCE_TYPE_FLAG)
  23. scoring model Id (SCORING_MODEL_ID)
Please look for parameter 21 & 22 .User often commits mistake by passing it as ‘NULL’.

 

Changes

 Post RPC Patch application.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms