Store a 750+ long string on AR Invoice in EBS r12 — 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

Store a 750+ long string on AR Invoice in EBS r12

edited May 8, 2025 1:40PM in E-Business Suite

Whenever we create an AR invoice in Oracle E-Business Suite, we receive a string that exceeds 750 characters in length for that invoice. We need to store this string in EBS—either directly on the AR invoice or in a way that it can be associated with the invoice.

In similar projects for clients using Oracle Fusion, we used a custom object to store this long string. However, in EBS R12:

1. There is no equivalent "custom object" functionality available.

2. Descriptive Flexfields (DFFs) have a maximum character limitation and cannot accommodate a 750+ character string.

Is there a way to do that? We also need to be able to extract the string and associate it to the invoice using SQL.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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