BI Publisher (MOSC)

MOSC Banner

how to write formula column in XML data template in apps R12

edited Jan 2, 2017 11:31AM in BI Publisher (MOSC) 7 commentsAnswered

Hi All,

Could you please help me how to write formula column in XML data template?

function C_REMIT_TO_CONCATENATEDFormula return VARCHAR2 is    Remit_To_String        VARCHAR2(5000);            address_style         VARCHAR2(30);    address1            VARCHAR2(240);    address2            VARCHAR2(240);    address3            VARCHAR2(240);    address4            VARCHAR2(240);    city            VARCHAR2(60);    county            VARCHAR2(60);    state            VARCHAR2(60);    province            VARCHAR2(60);    postal_code            VARCHAR2(60);    territory_short_name    VARCHAR2(80);    country_code        VARCHAR2(60);    customer_name        VARCHAR2(50);    bill_to_location        VARCHAR2(40);    first_name            VARCHAR2(40);    last_name            VARCHAR2(50);    mail_stop            VARCHAR2(60);    default_country_code    VARCHAR2(60);    default_country_desc    VARCHAR2(80);    print_home_country_flag    VARCHAR2(5);    print_default_attn_flag    VARCHAR2(5);    width            NUMBER(3);    height_min            NUMBER(3);    height_max            NUMBER(3);BEGIN    srw.reference(:REMIT_ADDRESS1);    srw.reference(:REMIT_ADDRESS2);    srw.reference(:REMIT_ADDRESS3);    srw.reference(:REMIT_ADDRESS4);    srw.reference(:REMIT_CITY);    srw.reference(:REMIT_STATE);    srw.reference(:REMIT_POSTAL_CODE);    srw.reference(:REMIT_COUNTRY);    srw.reference(:P_default_country);    srw.reference(:P_default_country_description);    srw.reference(:P_print_home_country_flag);    srw.reference(:BILL_COUNTRY);    /* only when country of Bill-To Address is Japan,       let the format_address() consider JP style address       formatting, otherwise default format style is forced       to be used. *//* bug1808782 : RAXINV does not

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