My Oracle Support Banner

How To Store Big Values In Package_id (Doc ID 1272525.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version and later
Information in this document applies to any platform.


The package_id for purchased_products can store maximum value of 2147483647 (2 to the power of 31 minus 1). This field is defined as integer in server side:

pin_flds.h:#define PIN_FLD_PACKAGE_ID PIN_MAKE_FLD (PIN_FLDT_INT, 9055)

For some business requirement, one may try to store a bigger value into this field by using testnap with PCM_OP_WRITE_FLDS opcode with the below flist:

0 PIN_FLD_POID POID [0] /purchased_product 2071422 3
0 PIN_FLD_PACKAGE_ID INT [0] 4294967296

The actual stored value is 2147483647. It looks like the testnap application is passing only 2147483647 value to WRITE_FLDS opcode but not 4294967296.

How can we store bigger value in this field ?


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

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