My Oracle Support Banner

BI 9.2: BI_FFEXT Is Extracting Only Single Line Though There Were Two Unique Values For Resource Type, ADMIN and ADVER . (Doc ID 2483475.1)

Last updated on DECEMBER 25, 2019

Applies to:

PeopleSoft Enterprise SCM Billing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 PUM 27 version, Billing Utility

ACTUAL BEHAVIOR
---------------
BI_FFEXT is extracting only single line though there were two unique values for Resource Type, ADMIN and ADVER.


EXPECTED BEHAVIOR
-----------------------
If there are multiple resource type then multiple line should get extracted in file for each resource type.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add project with Federal customer.
2. Add new fund distribution for project with multiple line target as 70% with category ADMIN, 20% with category ADVER, 10% with %.
3. Create contract and add the project and transaction.
4. Process transaction and fund distribution.
5: Run CA_BI interface which will create 2 rows in billing interface.
6. Run interface. Bill will get created with two lines.
7. Run BI_FFEXT process only one line will get generated in text file.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get multiple lines for each resource.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.