Configuring Projects GL Reconciliation Manual Journal Entries
In addition to the default supported use cases, the Projects GL Reconciliation solution in this release supports an additional use case to identify manually created project journals in GL.
For EBS R11.5.10 and R12.x, most often customers configure a descriptive flexfield in source to populate it with a project number or identifier when creating manual journals to associate a project to that journal. In such cases, the ETL code can be customized to extract and report these manually created journals. So in case if a customer has created a descriptive flexfield in EBS Apps GL Journal header or Lines table and they use it to populate Project Number for manually created journals, the Projects GL Reconciliation ODI interfaces can identify those transactions after doing some customizations to the expression where JOURNAL_SOURCE field is populated during extract.
By default, JOURNAL_SOURCE is populated directly from GL_JE_HEADERS, it will not be linked with Project Sub Ledger and in that case, such transactions will be filtered out.
You customize the ETL code in ODI interfaces to identify manually created journal entries. The descriptive flexfield ATTRIBUTE1 in table GL_JE_HEADERS is used to store the Project Number (or some other Project key).
To Configure Projects GL Reconciliation Manual Journal Entries: