API Hz_org_cust_bo_pub.get_org_custs_updated Cannot Get Correct Action_type For Acct Site Profile Amt (Doc ID 1463242.1)

Last updated on FEBRUARY 28, 2017

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

 Standard BO cannot generate correct value of ACTION_TYPE for Created/updated site profile amount on customer screen.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Use existing customer with one site, create a new currency for each site profile
Responsibility:  Receivable Manager
Navigation: Customer > Standard > Create > Search
Select Party Name

Select account

Select Account Site
Go to 'Profile Amt'  > Add currency and Save

Run concurrent "TCA Business Object Events: Raise Events Program"

NOTE:- The event ID generated can be traced using the below query and HZ_CUST_PROFILE_AMTS record has correct values in column CHILD_OPERATION_FLAG and POPULATED_FLAG

SQL Query Result:

CHILD_ENTITY_NAME CHILD_ID CHILD_OPERATION_FLAG POPULATED_FLAG LAST_UPDATE_DATE CREATION_DATE PARENT_BO_CODE CHILD_BO_CODE PARENT_ENTITY_NAME PARENT_ID PARENT_EVENT_FLAG EVENT_ID CHILD_EVENT_ID DELETE_FLAG
1 HZ_PARTIES 14830770 U Y 2012/02/20 02:54:15 2012/02/20 03:29:04 ORG_CUST U 1216778
2 HZ_CUST_ACCOUNTS 1070422656 U Y 2012/02/20 02:54:15 2012/02/20 03:29:04 ORG_CUST CUST_ACCT HZ_PARTIES 14830770 1216778
3 HZ_CUST_ACCT_SITES_ALL 1070231293 U Y 2012/02/20 02:54:15 2012/02/20 03:29:04 CUST_ACCT CUST_ACCT_SITE HZ_CUST_ACCOUNTS 1070422656 1216778
4 HZ_CUST_SITE_USES_ALL 353020 U Y 2012/02/20 02:54:15 2012/02/20 03:29:04 CUST_ACCT_SITE CUST_ACCT_SITE_USE HZ_CUST_ACCT_SITES_ALL 1070231293 1216778
5 HZ_CUSTOMER_PROFILES 1333345 U Y 2012/02/20 02:54:15 2012/02/20 03:29:04 CUST_ACCT_SITE_USE CUST_PROFILE HZ_CUST_SITE_USES_ALL 353020 1216778
6 HZ_CUST_PROFILE_AMTS 1399050 I N 2012/02/20 02:54:15 2012/02/20 03:29:04 CUST_PROFILE HZ_CUSTOMER_PROFILES 1333345 1216778

6. Invoke the Standard API hz_org_cust_bo_pub.get_org_custs_updated in plsql block as below and check the returned value of attribute

x_org_cust_objs(1).account_objs(i).cust_acct_site_objs(j).cust_acct_site_use_objs(k).site_use_profile_obj.cust_profile_amt_objs(l).action_type
hz_org_cust_bo_pub.get_org_custs_updated(p_init_msg_list => x_init_msg_list
                                        ,p_event_id      => x_event_id
                                        ,x_org_cust_objs => x_org_cust_objs
                                        ,x_return_status => x_return_status
                                        ,x_msg_count     => x_msg_count
                                        ,x_msg_data      => x_msg_data);

EXPECTED RESULTS

The value of attribute ACTION_TYPE should be 'CREATED'

ACTUAL RESULTS

The value of attribute ACTION_TYPE is 'UNCHANGED' now.

Additionally, the API will generate 'UNCHANGED' value for ACTION_TYPE as well when update a existing site profile amount while it shoulde be 'UPDATED'

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