For customized project accounting validation solutions, the ReadSoft PROCESSIT Customization Workbench provides the Custom project account generator interface. This interface allows for source code to be entered and executed in place of the PROCESSIT default functionality.
When a user clicks the Validate button within the PROCESSIT Accounting Workbench, the system checks whether the Custom project account generator interface is active. If it is active, the corresponding code is executed.
For this article, the source code EPS-ProjectAccountGenerator is used. This code can be downloaded here and edited as necessary for individual implementations.
According to this code, there are two processing options:
- Use the APPS schema. If the value of the useAppsSchema parameter is true, the URL and user credentials are assigned by other trailing variables.
If the value is false, the URL and user credentials will come from the built- in jdbc/D4_OEBS_APPS connection as defined by Weblogic.
Use hard-coded test parameters. If the value of the useTestParameters variable is true, then variables that are ultimately passed to the project accounting package are statically assigned and are not passed in from the Accounting Workbench.
During execution, if the APPS schema method is used, the returned ccId and concat_segs information is returned to PROCESSIT via the interface's response object.
In addition, dbms_output is enabled so a thorough database tracing can be directed to the log4j log file. Tracing for this process is elevated to the debug level via a method call to aps.fnd_flex_workflow_apis:
The dbms_output text is written to the log4j log file via the printTrace method after the call to the xxd4_appps.xxd4_bpel_projectaccounting package.
Additionally, the code uses setLog statements that are appended to the log4j file. One benefit of using this interface is that the dbms_output information from the package calls are also appended to the log4j file.