BI Publisher (MOSC)

MOSC Banner

How to print instalment plan table in BIP publisher

edited Feb 5, 2018 4:03AM in BI Publisher (MOSC) 13 commentsAnswered

Hi Guys,

I am working on BIP report which prints out data as follows:

Header and Lines comes from DB but product instalment plan is not available in DB. requirement is to calculate the Instalment plan on runtime (in BIP report )

  • Instalment lines are always 10 (fixed) 
  • instalment amount for 10 lines is base on % provided in parameter
  • instalment date is base on order date and add 1 month time interval for 10 lines to fill.

Header:

BuyerName:           Buyer ID          Order Date

Lines:

Product ID               Product Name               Product Amount

Product Instalment Plan:

Instalment 1          Date          Instalment_amount     Instalment %

Instalment 2          Date          Instalment_amount     Instalment %

.

.

Instalment 10          Date          Instalment_amount     Instalment %

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