My Oracle Support Banner

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 to [Release 7.2.0]
Information in this document applies to any platform.


-- 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
SELECT gsm.account_obj_id0
FROM group_sharing_members_t gsm
-- exclude parent of sponsorship
SELECT g.parent_id0
FROM group_t g WHERE g.poid_type IN ('/group/billing', '/group/sponsor')
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 =


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.