Service Request API: Error 'POL-4008 Null Buffer for Attribute is not Allowed'

(Doc ID 1939250.1)

Last updated on SEPTEMBER 01, 2016

Applies to:

Oracle Teleservice - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

When using the API CS_ServiceRequest_PUB.Create_ServiceRequest to create a Service Request, the CONTACT_POINT_TYPE is not specifically set to NULL.
Seems like it is populating with value of CHR(0) in ASCII but not the actual NULL value.

Expected Behavior:

Expect a NULL value in CS_HZ_SR_CONTACT_POINTS.CONTACT_POINT_TYPE.

Steps:

1. Create SR using API CS_ServiceRequest_PUB.Create_ServiceRequest.

2. After that, there is an issue on the contact table CS_HZ_SR_CONTACT_POINTS, where the CONTACT_POINT_TYPE is not specifically set to NULL.

3. Values being passed:

TYPE contacts_rec IS RECORD
   ( SR_CONTACT_POINT_ID            NUMBER         := FND_API.G_MISS_NUM,
     PARTY_ID                       NUMBER         := FND_API.G_MISS_NUM,
     CONTACT_POINT_ID               NUMBER         := FND_API.G_MISS_NUM,
    CONTACT_POINT_TYPE             VARCHAR2(30)   := FND_API.G_MISS_CHAR,
    PRIMARY_FLAG                   VARCHAR2(1)    := FND_API.G_MISS_CHAR,
     CONTACT_TYPE                   VARCHAR2(30)   := FND_API.G_MISS_CHAR );

Passed:

   l_contacts_tab(1).party_id      := p_contact_party_id;
   l_contacts_tab(1).PRIMARY_FLAG  := 'Y';
  l_contacts_tab(1).CONTACT_TYPE  := 'EMPLOYEE';

Workaround:

Updated the column CONTACT_POINT_TYPE to NULL manually.


Business Impact:

Due to this issue, users cannot sync the SRs to the MFS client, because of this incorrect value.
Mobile Field Service fails with the POL-4008 error.

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