My Oracle Support Banner

ORMB 2701 In CI_ACCT Extract, Comma Present As A Part Of Value Is Not Handled (Doc ID 2631409.1)

Last updated on JANUARY 22, 2020

Applies to:

Oracle Financial Services Revenue Management and Billing Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

On 2.7.0.1.0

ACTUAL BEHAVIOR
---------------
In CI_ACCT, comma present in "addrss2" column is not handled. After 123, rest of the value is considered as next field.

ACCT_ID,BILL_CYC_CD,SETUP_DT,CURRENCY_CD,ACCT_MGMT_GRP_CD,ALERT_INFO,BILL_AFTER_DT,PROTECT_CYC_SW,CIS_DIVISION,MAILING_PREM_ID,PROTECT_PREM_SW,COLL_CL_CD,CR_REVIEW_DT,POSTPONE_CR_RVW_DT,INT_CR_REVIEW_SW,CUST_CL_CD,BILL_PRT_INTERCEPT,NO_DEP_RVW_SW,BUD_PLAN_CD,VERSION,PROTECT_DIV_SW,ACCESS_GRP_CD,ACCT_DATA_AREA,EC_EXPIRY_SCHEDULE_CD,BILL_LEAD_DAYS,ACCT_USAGE_FLG,TRIAL_BILL_SW,REPRICING_SW,CRE_BY,LAST_UPD_BY,CRE_DTTM,LAST_UPD_DTTM,PRODUCT_CD,DEFER_AUTO_PAY_DT,ACCR_CYC_CD,EXCL_ACCR_SW,RULE_APAY_SW,BO_STATUS_CD,STATUS_UPD_DTTM,BUS_OBJ_CD,BO_DATA_AREA,CLOSING_DT,DD_CR_SW,DT_EXTRACT_DTTM,RECORD_STATUS
0016906350,A50 ,2016-05-02 00:00:00.0,HKD, , ,,N,FR , ,N,N/A ,,,N,XXXXX , ,N, ,3,N,CMFR ,11trueDPOSTALAOtrueTestENG1, ,0,USAG,N,, , ,,,,,,N,N, ,, ,,,N,2019-12-16-08.36.36,I,
0018452980,PT4 ,2016-05-04 00:00:00.0,PLN, , ,,N,FR , ,N,N/A ,,,N,XXXXX, ,N, ,20,N,CMFR ,11trueLISBON123, IXGGBD SDNLGBBPLAPL TEST

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
References


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