My Oracle Support Banner

Usage Account Not Getting Linked To Invoice Account (Doc ID 2711513.1)

Last updated on SEPTEMBER 18, 2020

Applies to:

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


On : version, ENV - Environment

Usage Account not getting linked to Invoice Account

While uploading Invoice constructs using File Request Type (FRT), Columns i.e. RULE_SQL and RULE_SQL_HARD_PARSE do not get populated in the CI_CONSTRUCT_TEMPLATE table for most of the records. This eventually impacts the usage accounts not getting linked to Invoice Account.

Steps to Replicate the Issue:

1) Create FRT using Business Object - C1_INVOICE_CONSTRUCT.
2) Upload a file to create Invoice constructs on the Invoice Accounts.
3) Verify if Invoice constructs are created.
4) Verify if RULE_SQL and RULE_SQL_HARD_PARSE is populated in the CI_CONSTRUCT_TEMPLATE table.


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.