My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
  1. Bug Summary
 2. Fixed File(s)
 3. Recommended Patch(es)
 4. Solution Steps
References

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