WSH_DELIVERIES_PUB.CREATE_UPDATE_DELIVERY() versus Context Sensitive Descriptive Flexfields

hi,
Lately, I been working on a piece that should populate "Additional Delivery Information" DFF for "local" context (88) and was surprised to see that attributes hadn't been updated.

Methodology:  Custom mobile EBS form updates WSH_NEW_DELIVERIES table attributes - corresponding Oracle API is being called by MWA classes via JDBC connection.

Issue: After API call relevant attributes updated ONLY for Global Data Elements context.

Reference Field for this DFF is ORG_ID, so naturally, while calling this API to allocate Attributes 12 & 13, I would expect them to be saved within "local" Context 88.

x_delivery_info         apps.wsh_deliveries_pub.Delivery_Pub_Rec_Type;

      select tt.name into l_delivery_name
      from wsh_new_deliveries tt 
      where tt.delivery_id = to_number(p_delivery_id);
      
      x_delivery_info.attribute12 := VALUE1;
      x_delivery_info.attribute13 := VALUE2;
      x_delivery_info.delivery_id := to_number(p_delivery_id);
      x_delivery_info.NAME := l_delivery_name;
      x_delivery_info.last_update_date := SYSDATE;
      x_delivery_info.last_updated_by := fnd_global.user_id;
      apps.WSH_DELIVERIES_PUB.CREATE_UPDATE_DELIVERY(
                           p_api_version_number => 1.0,
                           p_init_msg_list => l_init_msg_list,
                           x_return_status => xx_return_status,
                           x_msg_count => xx_msg_count,
                           x_msg_data => xx_msg_data,
                           p_action_code => 'UPDATE',
                           p_delivery_info => x_delivery_info,
                           x_delivery_id => x_delivery_number,
                           x_name => x_delivery_name);


I been working with Oracles APIs for quite some time and kinda, got used to the fact that ATTRIBUTE_CATEGORY update is "built in" (I been told its mater of the setup though).

Anyway, in this particular case YOU MUST provide the value to the record to have it working correctly:

x_delivery_info.attribute_category := fnd_profile.value('ORG_ID');


Hopefully 2 minutes of reading   save you some time.

Take care,

Why nothing is fetched from GMD_RECIPES_B?

hi All,

This is my first post, YES SIR!
The only reason I didn't post anything so far- no bugs left in Oracle what so ever...LOL.
Seriously, there are plenty of those to go around, yet for the most I came across, there are already solutions/work-arounds published somewhere.
And besides, who am I to decide what is a BUG and what is a FEATURE? :)
So basically, I am going to gather here info that might be not necessarily genuine, yet might have and additional info to supplement previous posts - needless to remind not everybody has account at Metalink.

As for the issue previously mentioned:

Problem: You are able to access Formulas and Recipes  at  Oracle EBS - via several Product Manufacturing Responsibilities, but nothing is ever fetched by SQL*Plus/PL/SQL Developer/TOAD - you name it, no matter what FND_LOBAL.APPS_INITIALIZE() you been trying. 

Solution: I am mainly quoting solution already posted on ONT Forum, though my is rather shorter:
Assign the Oracle EBS User you been using for APPS_INITIALIZE the Formulator Responsibility and here you go!
Link to original post:
https://forums.oracle.com/forums/thread.jspa?threadID=2230436