Posts

Showing posts from February, 2024

Oracle BRM: PDC commands to export pricing and configurations

BRM Patch set 8 onwards there is a configuration available for the tax codes. PDC stands for Pricing and Design Center. This is used to configure the price plans required for the end customers. You can export the data into XML format and perform validations or deployments as required. Following are the commands which you can use to export the data from PDC. /ImportExportPricing -export all -metadata ./ImportExportPricing -export all -pricing  ./ImportExportPricing -export all -pricing PACKAGE_LIST ./ImportExportPricing -export all -config BALANCE_ELEMENT ./ImportExportPricing -export voicemail -config TAX_CODE -n "voicemail" -expRefs ./ImportExportPricing -export all -config ./ImportExportUtility -export -config TAX_CODE ./ImportExportUtility -import -config Taxcode.xml -ow Some more commands when there are failures while importing.  echo $PDC_PASSWORD |./ImportExportPricing -export <name> -metadata EVENT_ATTRIBUTE_SPEC -inclFailedObjs  echo $PDC_PASSWORD |./ImportE...

Oracle BRM: Things to remember for Business teams, Designers and Architects (Draft)

Image
The following topics will always be useful whether it is a greenfield implementation or an ongoing maintenance project.  Master Data Management Database cluster design across the enterprise applications Within Oracle BRM Cloud vs OnPrem  Account Management Pricing Management Services Management Inventory (Devices) Management AR (Payments, Adjustments, Disputes, Writeoffs) Management Integrations (OSS and BSS along with Tax and Payment gateways) Security (Encryption, PII, SSL, Authentication and Authorization) Billing Management Invoices and PDFs/Print Management Collections Management Usage and Rating Management DevOps and Code Management Reports and Documents Maintenance of the database/File systems of production Planning development, testing and integration environments 1. Are we going to maintain the master copy somewhere in another application? Master data management is crucial when there are plenty of applications which are going to store same data in a different format b...

Oracle BRM: Are you using ECE for rating? CohQL commands may help

These commands of CohQL (Coherence Query Language) may help to get the information from the cache of the coherence database. CohQL> select key() from RequestSpecification; CohQL>  select * from RequestSpecification where key()='EventDelayedSessionSptelConnectMetroEthernet:1.0'; ./query.sh -s -c -l 'select key(), value().toString() from PublicUserIdentity where key() = "639801014982"' ./query.sh -s -c -l 'select * from Customer where key() = "191448185435"'

Oracle BRM: What is the name of the tool provided by Oracle for automated testing?

  Pinata Opcoder Pinata opcoder is a tool that is provided by Oracle for automated testing of BRM applications. Oracle BRM's testing tools can be downloaded from the link below: http://www.oracle.com/technetwork/apps-tech/index-098865.html Note: Refer to the 'opcoder_user_manual.pdf' file for more details about configuring the test cases for Oracle BRM. The creation of a basic PINATA / Opcoder test involves the following steps: 1) Write out your Test Cases as comments in a PINATA script 2) Turn Recording On 3) Record your Test Cases, following the Recording hints given below 4) Mark your test cases with “fetch-opc”. Keep the individual opcoder files small to allow simple rerecording  of the parts if necessary. 5) Extract your .opc (opcoder) files to a test directory 6) Test and debug your scripts by playing them back, one at a time Note: Include a "Setup", "Test", and "Clean-up" section for each of your test cases. Your piƱata/opcoder. scripts ...

Oracle BRM: PerfLib tool and why we need it?

Perflib "Quick Start" Guide This guide is a brief introduction to how to install and setup Perflib to trace the BRM Connection Manager (CM) for those who would like to get  started as soon as possible. This guide will only describe how to start the CM with Perflib enabled and collect trace data.  Installing Perflib Perflib is shipped in a single tar archive called something similar to perflib__REL_X_Y_Z__basic_license_linux6.tar.gz. The following  installation steps will install Perflib: cd $PIN_HOME mkdir perflib cd perflib gunzip < perflib__REL_X_Y_Z__basic_license_linux6.tar.gz cd install Check Perflib Configuration The default settings for Perflib are generally sufficient for basic application tracing and can be left unchanged. The configuration is defined via  environment variables defined in the perf.env file, with each parameter being documented (at least at high-level). Please feel free to investigate  alternative configuration options to see how thin...

Oracle BRM: Utilize the BRM's MTA framework to use a file instead of searching the database

The BRM MTA's framework supports three search options:  Search for objects stored in the BRM database Search for objects stored in a file Passing objects directly to the search opcode. You specify the search option in the PIN_FLD_SEARCH_FLIST substruct in the global flist. To search for objects in a file, you specify the name of the file where the objects are stored. For example: 0 PIN_FLD_SEARCH_FLIST    SUBSTRUCT [0]  1     PIN_FLD_FILENAME          STR [0] "file name"  1    PIN_FLD_COUNT             INT [0] 2  Important: The file specified in PIN_FLD_FILENAME  must  be a text file and  must  have the same format as the search results flist. The following is an example of the text file: 0 PIN_FLD_RESULTS          ARRAY [0]  1    PIN_FLD_ACCOUNT_OBJ       POID [0] "/account" 123 0  0 PIN_FLD_RESULTS...

Oracle BRM: Is your BRM application slow though the database is super responsive?

Image
  When the batch applications or real time operations are slow in Oracle BRM, we can use the module named 'perfLib' to identify any bottlenecks especially when the bottlenecks are on the application side rather than on the database or the network. Note: Contact Oracle support to get this library which suits your specific operating system and the version of BRM. To fix, performance issues in your BRM code, do the below. Identify and fix memory leaks. Use Perflib to fix performance bottlenecks. Diagnose database response using AWR/ADDM/ASH reports. Do hardware sizing when required. It is very important to fix memory leaks to achieve a good performance, because connection manager(CM) in BRM will have the ceiling limit of 2 GB. Once the leaked memory reaches to 2 GB for all the child threads of CM then it will generate a  core-dump  and halts further processing. We will discuss in another post on how to diagnose and fix memory leaks in detail. Using perflib tool you may ident...

Oracle BRM: A simple test automation setup using SoapUI

Image
Before you start setting up testcase in SoapUI, you should have webservicesmanager installed and webServer up and running in the BRM server. Verify the following url in your setup. http://<<host>>:<<port>>/Services/BRMBaseServices?wsdl If you can’t open above page, that means something is wrong with your web services setup in BRM server. If you can see all the web services defined, then follow the below steps to setup automated testing. I have used the free version of SoapUI. Install SoapUI Click on File → Add a project → Add WSDL url mentioned above Add a testsuite by right clicking on project name Add a test case → add a test step in the test case Add a soap request in the test step Requirement: Test step requires to do the following in the order. Fetch values from Database to form input XML Get the soap response XML Validate the soap response and display test result Fetch values from Database to form input XML Add soap input in test case Add assertion script ...