Financial Management - PSFT (MOSC)

MOSC Banner

Table PS_INTFC_BI_AEDS Field PERCENTAGE significance?

edited Dec 31, 2014 10:02AM in Financial Management - PSFT (MOSC) 4 commentsAnswered

We are having trouble with approx. 431 invoices that were loaded with sum(PERCENTAGE) <> 100.  A change was made to the interface into BI and not fully tested (bad bad, I know).

What is the significance of field PERCENTAGE on table PS_INTFC_BI_AEDS?

For example, TARGET_INVOICE 698923SB has a sum(PERCENTAGE) of 102% which caused it to error out.  (See attached lines in excel spreadsheet).

In our development environment, as a test, I ran the sql statements shown below to set field PERCENTAGE on the first seq no = 100, the field PERCENTAGE on the rest of the seq nos = 0.  That way when the rows are summed by TARGET_INVOICE when the BI Interface runs, they would equal 100. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center