Field Value Not Getting Propogated for Custom Object Field Through webservice (Doc ID 2430421.1)

Last updated on JULY 21, 2022

Applies to:

Symptoms

On : 11.13.18.02.0 version, Opportunities

ACTUAL BEHAVIOR
Webservice call creates a record, but gives blank value for a specific custom attribute

EXPECTED BEHAVIOR
Webservice call creates a record, must also create correct value for the specific custom attribute

STEPS
The issue can be reproduced at will with the following steps:

log into OSC
Navigator>Sales>Opportunity
create a record
EDIT opportunity p[age opens up
key in values for creating Revenue line
save
click button: create sales order

This invokes the webservice and populates the records for custom object: Sales Order


click subtab: Sales Order
page opens up

review the values for custom fields
"Product text id"

is null

Notes: The physical column "EXTN_ATTRIBUTE_CHAR042" is null
This is mapped to custom field "Product text id"
***
Table: MKT_REF_ENTITIES
physical column: EXTN_ATTRIBUTE_CHAR042
WHERE ATTRIBUTE_CATEGORY = 'SalesOrder_c'
  AND ID = 300000025060648
***

select EXTN_ATTRIBUTE_CHAR042
from
FROM MKT_REF_ENTITIES
WHERE ATTRIBUTE_CATEGORY = 'SalesOrder_c'
  AND ID = 300000025060648
***


BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot review the value for "Product text id"

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.