Custom Sources

Extend the list of sources available to application accounting definitions. Using standard and system source values as parameters, write PL/SQL functions that create custom sources.

It is used to extend the list of sources available to application accounting definitions. First, decide your primary goal in defining a custom source. Also be sure to explore other alternatives, as custom source may impact the performance of the create accounting program. If you need to define one custom source, then define a PL/SQL function. In the function, you determine the input and output parameters. The output parameters becomes the return data options that you need to provide the Custom Source page. The name of the PL/SQL function must be provided in the Custom Source page. Provide the input parameters that you need in the PL/SQL function in the Parameters section of the Custom Source page. A custom source's PL/SQL function may use the seeded sources that are available to the application accounting definition or any constant value. You have to define the PL/SQL function in the database.