Pin_amt Hangs On Account Search (Doc ID 951432.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.2.0.2.0 to 7.2.0.2.0 [Release 7.2.0]
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
When running pin_amt for job creation, the process hangs during the account search.
Problem occurs in development environment where there is only one database with two schemas, however all DB links are created and all install is performed in the DEV DB.

-- Steps To Reproduce:
launch "pin_amt -s <search file>". Process hangs

In pin_amt log process hangs with below messages:


-- exclude children in sharingship
MINUS
SELECT gsm.account_obj_id0
FROM group_sharing_members_t gsm
-- exclude parent of sponsorship
MINUS
SELECT g.parent_id0
FROM group_t g WHERE g.poid_type IN ('/group/billing', '/group/sponsor')
MINUS
SELECT gt.account_obj_id0
FROM group_t gt WHERE gt.poid_type LIKE '/group/sharing%'
main - 06/17/09 10:32:39:076 - connnection = jdbc:oracle:oci8:@infra2.des.oracle.uk

Cause

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 hundreds of Community platforms