Home › Discussions › Questions & Answers › Avoiding Errors: Entering Segment Values with Leading Zeros

Avoiding Errors: Entering Segment Values with Leading Zeros

Avatar photoCustomer Questions & Answers 5 replies

When entering segment values (Segments 1-20) into the `br_balance` function, how strictly must I adhere to Oracle’s internal configuration?

5 replies

  • Support Enginatics

    You must format the value exactly as configured in Oracle. This ensures the lookup is successful.

  • Avatar photoCustomer

    If my Oracle system stores account ’10’ as a four-character segment field, what must I enter into the parameter field?

  • Support Enginatics

    If Oracle stores ’10’ with leading zeros as four characters, you must enter ‘0010’. Failure to include all leading zeros will result in data retrieval errors.

  • Avatar photoCustomer

    If I leave the segment parameter blank, what does the function assume?

  • Support Enginatics

    Leaving the segment parameter blank or entering ‘%’ will include all possible values for that segment.

  • You must be logged in to reply to this post.