EBI9.1+: Using Billing Interface Excel Upload Results Foreign Amount to 0 in PS_PROJ_RES Record When System Source is BBI

(Doc ID 2104409.1)

Last updated on FEBRUARY 18, 2016

Applies to:

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

Symptoms

On : 9.1 version, Billing Interface

ACTUAL BEHAVIOR
---------------
Using Billing Interface Excel Upload results in Foreign Amount To 0 in PS_PROJ_RES Record When System Source is BBI.


EXPECTED BEHAVIOR
-----------------------
Billing Interface Excel Upload should behave or be consistent with online bill entry, in terms of writing back to Projects/Contracts record.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Enter credit  bill in BillingExcelUpload and post as BAJ (Billing Adjustment).
  2. Run Billing Interface Process BIIF0001.
  3. Run Finalize and Print BIJOB01
  4. Run Currency Conversion, Preload Process and Load to AR processes.
  5. Run the Process BIPCC000 (Update Contracts/Projects Data).
  6. Result: BIL and BAJ rows created in PROJ_RES_TMP_BI. BAJ row has blank for Foreign Amount. BIL row is correctly populated.
  7. Run the process PC_BI_TO_PC.
  8. PROJ_RESOURCE has blank amounts for BAJ

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