Which Oracle DB packages are provided in BIP datamodels? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Which Oracle DB packages are provided in BIP datamodels?

in Reporting and Analytics for ERP 5 comments

Summary:

Hello,

actually we are looking for an Oracle provided db package with a standard function to convert item weights between item_weight uom codes.
I want to use this function in an BIP datamodel for Oracle Fusion (NOT Onprem).

In Oracle seeded reports / datamodels I can see that Oracle makes use of db functions coming through different db packages like:

AR_BPA_UTILS_PKG
HZ_FORMAT_PUB

examples are:

fnd_currency.get_format_mask(trx.invoice_currency_code, 40 )

AR_BPA_UTILS_PKG.fn_get_contact_name(trx.bill_to_contact_id)

AR_BPA_UTILS_PKG.fn_get_phone(trx.bill_to_contact_id)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!