My Portfolio

Mapping between GL and XLA tables How Subledger Accounting (XLA) Tables are link to General Ledger (GL) Tables Assumption is GL Entry Summarization: Summarize (By GL Date or Period) JLT – Transfer to GL: Detail Expected behavior is: Summarize Entries at GL_JE_HEADERS and detail at GL_JE_LINES Refer to following post as how this is determine Transfer to GL in Detail or Summarize Mode Relation between GL_JE_BATCHES and XLA_AE_HEADERS A.1) Group_id column subledger(XLA_AE_HEADER) mapped group_id Gl_je_batches.group_id => xla_ae_headers.group_id 1 group id will have many xla_ae_headers rows 1 group id will have 1 or many periods in xla_ae_headers 1 group id will have 1 or many ledger id in xla_ae_headers Ideally there shouldn’t be any rows in xla_ae_headers with null group_id 1 group id and 1 period(GL Period) in xla_ae_headers will make 1 batch in GL_JE_BATCH Since 1 group id in xla ae headers can have multiple periods so 1 group id in xla_ae_headers can have multiple batches in gl...

GL Flexfield Qualifiers in R12 Flexfield Qualifier is “which segment  qualifies  for which  attribute “. Each Segment can have one of the following  Qualifying attributes  attached to it. Some of them are  mandatory  others are  optional . Cost Center:  Usually assigned to  Department  Segment. This qualifying segment is used by  Oracle Assets . Natural Account:  This qualifier when attached to a segment enables the five nature of accounts Asset, Liability, Expense,Revenue, Owner’s Equity. It also assigns the option of  Reconciliation account  and  Third Party Control . Balancing:  This qualifier is usually assigned to the segment on which the Balance Sheet is required. System balances the Debit and Credit of the ledger on this segment. Intercompany:  This qualifier is used to identify the transaction between two entities under one group.  More on this in Intercompany. Management:  T...

Requirement: How does the Invoices Workbench (APXINWKB) determine the validation status of an invoice? The validation status of an invoice is displayed at invoice header level, but this information is not stored in the corresponding table AP_INVOICES_ALL like the rest of data at invoice header level. How does the system store this information? Solution There is no column in the AP_INVOICES_ALL table that stores the validation status. Invoice Distributions are validated individually and the status is stored at the Invoice Distributions level. This status is stored in  the match_status_flag column of the ap_invoice_distributions_all table (AP_INVOICE_DISTRIBUTIONS_ALL.MATCH_STATUS_FLAG). Valid values for this column are: A – Validated (it used to be called Approved) N or null – Never validated T – Tested but not validated S – Stopped The invoice header form derives the invoice validation status based on the following: Validated: If ALL of the invoice distribu...

In the past I have worked as Migration lead and now I am working as conversion lead for one of the ERP implementation project. As having worked on both(migration/conversion) this is an effort to put forward the difference between migration and conversion. The terms  Data Conversion  and data migration are still sometimes used interchangeably on the internet. However, they do mean different things. Data conversion is the transformation  of data from one format to another. It implies extracting data from the source,  transforming  it and loading the data to the target system based on a  set of requirements . Data Migration  is the process of transferring data between silos, formats, or systems. Therefore, data conversion is only the first step in this complicated process. Except for data conversion, data migration includes data profiling, data cleansing, data validation, and the ongoing data quality assurance process in the target system. Both terms are ...

Oracle by default does not maintain future depreciation information (Accumulated or YTD) as depreciation could change as per cost adjustment, addition or asset retirement. Often there will be requirement to write a function or package that returns YTD depreciation or Accumulated depreciation as of year-end or specific period(In this example it is Dec 2017) for example Accumulated depreciation as of Dec 2017, YTD depreciation as of Dec 2017 and remaining depreciation period for asset after Dec 2017. Over here I had requirement to get Asset depreciation as of Dec 2017 for  Workday Financial Conversion . Following is the function that returns depreciation as of certain period. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 ...