The following diagram is a high-level view of key tables and fields of BRM Database. For complete list of fields please refer BRM documentation:


Queries for reference which are useful in all BRM projects: Sample Queries

In Oracle BRM (Billing and Revenue Management), a base opcode is a fundamental operation or API used to perform actions such as creating, retrieving, updating, or deleting (CRUD) data in the system. These opcodes are predefined and serve as the building blocks for implementing business logic and processes within the BRM framework.

Base opcodes examples:

Opcode Name	Details
PCM_OP_CREATE_OBJ	Used to create new objects or entities in the BRM database.
PCM_OP_DELETE_OBJ	Used to delete existing objects or entities from the BRM database.
PCM_OP_READ_OBJ	Used to retrieve information or data from existing objects in the BRM database.
PCM_OP_WRITE_FLDS	Used to update existing objects or entities in the BRM database.
PCM_OP_SEARCH	Widely used opcode to search for objects or entities based on specified criteria. Data can be retrieved from two or more entities by specifying link between the objects.

 Note: PCM_OP_BULK_WRITE_FLDS opcode is also used to update fields like PCM_OP_WRITE_FLDS opcode. This opcode is useful when we need to update the same set of fields across a large number of objects efficiently in a single operation.

OBRM Opcode Interface Diagram

In Oracle BRM (Billing and Revenue Management), standard opcodes are predefined APIs used to handle tasks such as subscription management, balance adjustments, and service provisioning etc. They ensure consistency and reliability in processing business rules and transactions.

Standard opcodes are BRM APIs which are part of BRM Function Modules (FM). Standard and Custom opcodes can be exposed as REST APIs to integrate with different applications. Below are some examples of Standard opcodes provided by Oracle Out-of-the-box from different modules:

Standard Opcode Name	Details
PCM_OP_CUST_COMMIT_CUSTOMER	Used to create or modify customer accounts, purchase products & discounts.
PCM_OP_ACT_USAGE	This opcode rates and records an event.
PCM_OP_BILL_MAKE_BILL	This is a main opcode which provides billing for the specified billinfo object.
PCM_OP_PYMT_COLLECT	Performs payment collections and refunds.
PCM_OP_COLLECTIONS_PROCESS_BILLINFO	Determines whether bill units enters or exit collections and performs collections actions.

Policy Opcodes are hooks provided in standard opcodes to implement customizations. They facilitate a wide range of functions, allowing for achieving custom requirements of billing and revenue processes. BRM provide a ".c" file for every policy opcode where developers can implement changes as per the business needs. Below are some examples of policy opcodes from different modules:

Policy Modules	Example with Details
Subscription FM Policies	PCM_OP_SUBSCRIPTION_POL_SPEC_CYCLE_FEE_INTERVAL: Specify a different start, end, scale for cycle fee events
Rate FM Policies	PCM_OP_RATE_POL_PRE_RATING: Modify the input flist being sent for rating, PCM_OP_RATE_POL_POST_RATING: To perform any update after rating the event
Bill FM Policies	PCM_OP_BILL_POL_SPEC_BILLNO: To customize the bill no generated by billing, PCM_OP_BILL_POL_POST_BILLING: To perform any operation immediately after billing
Invoice FM Policies	PCM_OP_INV_POL_PREP_INVOICE: To enrich the invoice with additional information
Collections FM Policies	PCM_OP_COLLECTIONS_POL_EXEC_POLICY_ACTION: Perform specific tasks on collection actions, PCM_OP_COLLECTIONS_POL_EXIT_SCENARIO: Execute actions like resume service when billinfo leaves collections scenario

BRM also provides support for custom opcodes in order to fulfill business specific requirements in the project. Custom opcodes are designed with the input/output specifications and new library to meet such requirements.
In order to invoke BRM API/opcode, Input payload needs to be prepared as per opcode specifications. Input Flists for Opcodes for Reference in all BRM Projects: View

Below are some important functions/macros which are frequently used in BRM opcodes to implement different functionalities.

Flist Management Macros-

Name	Details
PIN_FLIST_CREATE(ebufp)	Allocates memory and creates new flist
PIN_FLIST_FLD_GET(flistp, fld, optional, ebufp),  PIN_FLIST_FLD_TAKE(flistp, fld, optional, ebufp)	Retrieve a field value from an flist. GET is a readonly whereas TAKE is removing field from flist and taking ownership
PIN_FLIST_FLD_SET(flistp, fld, valp, ebufp),  PIN_FLIST_FLD_PUT(flistp, fld, valp, ebufp)	Sets a field value to an flist. PUT is giving ownership of the field to the flist
PIN_FLIST_FLD_COPY(src_flistp, src_fld, dest_flistp, dest_fld, ebufp)	Copy field between flists
PCM_OP(ctxp, opcode, inflistp, opflistpp, flg, ebufp)	Invokes an opcode with the given input flist,flags and sets the response in the output flist
PIN_FLIST_DESTROY_EX(flistpp, NULL)	Removes allocated memory to flist, should be invoked once flist is no longer in use
PIN_FLIST_ELEM_GET(flistp, fld, elem_id, optional, ebufp)	Retrieve an array field from flist
PIN_FLIST_ELEM_GET_NEXT(flistp, fld, recidp, optional, cookiep, ebufp)	Loop through an array field in the flist
PIN_FLIST_SUBSTR_GET(flistp, fld, optional, ebufp)	Retrieve a substruct field from flist
PIN_FLIST_ELEM_ADD(flistp, fld, elem_id, ebufp), PIN_FLIST_ELEM_SET(flistp, elem_flistp, fld, elem_id, ebufp)	Sets a new array in flist
PIN_FLIST_CONCAT(dest_flistp, src_flistp, ebufp)	Concatenate flists
PIN_FLIST_SORT(flistp, sort_listp, sort_default, ebufp)	Sort flist

Other Macros-

Name	Details
PIN_POID_CREATE(db, type, id, ebufp)	Allocates memory and creates new poid
PIN_POID_COMPARE(pdp1, pdp2, check_rev, ebufp)	Compares two poids if they are identical
PIN_POID_IS_NULL(pdp)	Determines if the given poid is null
PIN_POID_DESTROY(pdp, NULL)	Removes allocated memory to poid
PIN_BEID_IS_CURRENCY(currencyid)	Returns 1 if the passed integer is a currency resource, 0 for non currency resource
PIN_ERR_LOG_FLIST(loglevel, descr, flistp)	Logs flist value to the cm.pinlog for troubleshooting
PIN_ERR_LOG_MSG(loglevel, descr)	Logs a string value to the cm.pinlog for debugging. Other data types can be converted to string and then logged
pbo_decimal_from_str(str, ebufp)	Create a new decimal variable from a string value
pbo_decimal_is_zero(dec, ebufp)	Returns 1 if the passed decimal has a value of zero, else 0
pbo_decimal_add_assign(dest, src, ebufp),  pbo_decimal_subtract_assign(dest, src, ebufp)	Performs add/subtraction of two given decimal values
pbo_decimal_compare(dec1, dec2, ebufp)	Compares two given decimal values if they are less,equal,greater than each other. Returns -1,0,1 if first parameter is less,equal or greater correspondingly.
pbo_decimal_destroy(&dec)	Removes allocated memory to decimal, should be invoked once it is no longer in use

Utility Name	Details
fm_utils_trans_open(ctxp, flg, pdp, ebufp)	Opens a transaction and locks the given object in read/write mode to maintain data integrity
fm_utils_trans_commit(ctxp, ebufp),  fm_utils_trans_abort(ctxp, ebufp)	Commit or Abort a transaction which was opened using fm_utils_trans_open() function based on whether the transaction is success or failure
fm_utils_is_subtype(pdp, value)	Determines if the type passed is the subtype of the poid_type passed. Returns 1 if the type passed is the subtype, 0 otherwise
fm_utils_add_n_days(num, timep)	Add specific number of days to the given time variable
fm_utils_op_is_ancestor(connp->coip, opcode)	Determines whether the given opcode is an ancestor of the current opcode using the given op stack. Returns 1 is opcode is an ancestor, 0 otherwise
fm_utils_time_round_to_midnight(time)	Rounds the given time variable to midnight
CM_FM_SET_NAMED_TRANS_FLIST(ctxp, flistp, TRANS_FLIST),  CM_FM_GET_NAMED_TRANS_FLIST(ctxp, TRANS_FLIST),  CM_FM_DROP_NAMED_TRANS_FLIST(ctxp, TRANS_FLIST, ebufp)	After opening a transaction, SET function sets an flist in one opcode and this flist can be retrieved using GET in another opcode. The drop macro is executed to remove flist from memory.

OBRM Multi-threaded Application (MTA) framework

MTA application is implemented to process operations/opcode in batch mode. This multi-threaded application executes parallely for high volume processing. Also MTA can be implemented in order to execute API calls asynchrously. For example some requests can be recorded in staging table and can be processed in batch, which gives a better way of error handling and retry mechanism.

MTA utility (Scheduled For Daily Run)	Details
pin_deferred_act -verbose	Processes the scheduled actions based on current date
pin_discount_cleanup -m close -verbose	Cancels the /purchased_discount objects which are expired as of current date
pin_cycle_fees -cancel -verbose	Cancels the /purchased_product objects which are expired as of current date
pin_bill_accts -active -retry -pay_type 10001 -verbose	Executes BDOM billing for Credit card (CC) pay type
pin_cycle_fees -cycle_fees -verbose	Applies cycle charges for products scheduled to start as of current date (products which were purchased with future start date)
pin_collect -active -pay_type 10003 -vendor fusa -verbose	Collects payment for CC pay types through payment gateway
pin_refund -active -pay_type 10003 -vendor fusa -verbose	Processes refund for CC pay types through payment gateway
pin_collections_process -report -verbose	Identifies any bill which is overdue and applies collection actions based on dunning rules
pin_ledger_report -mode export	Generates ledger report based on General Ledger (GL) configuration

Deployment and monitoring of applications running as pods in Kubernetes(k8s) environment is done using helm & kubectl respectively.

Some useful helm commands:

Helm Command	Details
helm install <brm-release-name> oc-cn-helm-chart --namespace <brm-namespace> --values oc-cn-helm-chart/override-values.yaml	To perform initial install to deploy new pods/services e.g. BRM pods
helm upgrade <brm-release-name> oc-cn-helm-chart --values oc-cn-helm-chart/override_values.yaml -n <brm-namespace>	To deploy changes done in config YAML file "override_values.yaml"
helm status <brm-release-name> -n <brm-namespace>	To check the helm status after install
helm history <brm-release-name> -n <brm-namespace>	To check the history of helm commands executed

Important kubectl commands:

Kubectl Command	Details
kubectl get nodes -o wide	To view the k8s nodes running in cluster with details
kubectl -n <brm-namespace> get pods -o wide	To check all the running pods status
kubectl -n <brm-namespace> exec -it <pod-name> bash	To login to the BRM pod instance
kubectl -n <brm-namespace> describe pod <pod-name>	To check details about a particular pod
kubectl -n <brm-namespace> get svc	To check the services type and status
kubectl -n <brm-namespace> logs -–since=1h -f <pod-name>	To view time bound logs of a specific pod
kubectl -n <brm-namespace> get hpa	To check horizontal pod autoscaler (HPA)
kubectl describe pvc --namespace <brm-namespace>	To retrieve details of persistent volume claim

Oracle Elastic Charging Engine (ECE) Components Diagram
This shows ECE architecture and supported integrations with different systems like PDC, BRM, Mediation System etc.: