My Oracle Support Banner

Synchronization Between BRM And PDC Fails For Multiple GL Segments (Doc ID 2274003.1)

Last updated on AUGUST 14, 2018

Applies to:

Oracle Communications Pricing Design Center - Version 11.1.0.7.0 and later
Information in this document applies to any platform.

Goal

On : 11.1.0.7.0 version,

Issue is that, synchronization between BRM and PDC fails for multiple GL segments.

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

1)  /opt/portal/7.5/sys/data/pricing/example/pin_glid

2)  vi pin_glid
3)  Added the Below line in GL Segment

gl_segment .

load_pin_glid -v pin_glid
-----
load_pin_glid: pcm_connection open
load_pin_glid: transaction open
load_pin_glid: old data pruned
load_pin_glid: glid and gl_segment created
load_pin_glid: transaction committed
load_pin_glid: pcm_connection closed

4)  stopSyncPDC
5)  startSyncPDC

Creating PID file ..
Starting SyncPDC with JAVA Memory arguments: -Xms256m -Xmx512m -XX:CompileThreshold=8000 -XX:PermSize=128m -XX:MaxPermSize=512m
SyncPDC with forceUpdate: Reinitialize BC metadata in PDC system.
PLEASE ENTER KEY PASSWORD TO DECRYPT THE PASSWORD(S) :
Clean up work item SYNC_EVENT...
Work item SYNC_EVENT started (item 1 of 8).
  Processing EXTRACT work action...
  Processing ANALYZE work action...
  Processing TRANSFORM work action...
  Processing LOAD work action...
  .............

Next syncPDC is scheduled to run at 06 Apr 2017 23:59:00.000 (every 1 day)


6)  After that , copied the pin_glid file and added the following line in GL segment
7)  vi pin_glid.100

gl_segment .100 no_rollup


8) run load_pin_glid

load_pin_glid: pcm_connection open
load_pin_glid: transaction open
load_pin_glid: old data pruned
load_pin_glid: glid and gl_segment created
load_pin_glid: transaction committed
load_pin_glid: pcm_connection closed

9)  stopSyncPDC
10)  startSyncPDC

Creating PID file ..
Starting SyncPDC with JAVA Memory arguments: -Xms256m -Xmx512m -XX:CompileThreshold=8000 -XX:PermSize=128m -XX:MaxPermSize=512m
SyncPDC with forceUpdate: Reinitialize BC metadata in PDC system.
PLEASE ENTER KEY PASSWORD TO DECRYPT THE PASSWORD(S) :
Clean up work item SYNC_EVENT...
Work item SYNC_EVENT started (item 1 of 8).
  Processing EXTRACT work action...
  Processing ANALYZE work action...
  Processing TRANSFORM work action...
  Processing LOAD work action...
  ..............

ERROR
-----------------------

 
How to resolve the above mentioned issue in PDC?
 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.