SQL For Period Close Status snapshot for All Ledgers with All Subledgers. SELECT (SELECT sob.NAME FROM apps.gl_sets_of_books sob WHERE sob.set_of_books_id = a.set_of_books_id) “SOB_Name”, a.period_name “Period_Name”, a.period_num “Period_Num”, a.gl_status “GL_Status”,TO_CHAR(a.LAST_UPDATE_DATE, ‘MM-DD-YY…
Read MoreExpense Report Processing for Terminated Employee To enter an Expense report for an employee, the employee has to be Active. The expense code looks at the Hire Date…
Read More1099 Invoices Processing Every Year January the subject of 1099 processing shoots to the top of the priority list for many AP Managers. Remembering exactly what was…
Read MoreOracle Employee Approval Signing Limits in Oracle EBS Applications There is no API and other Method To Enter Signing Limits Metalink Note (171837.1) The only option is direct insert in…
Read MoreTables Involved in P2P –Inventory select * from mtl_system_items_b msib where msib.segment1=’TEST’; select * from mtl_onhand_quantities_detail where inventory_item_id=111111; select * from mtl_onhand_quantities –view where inventory_item_id=111111; –Requisitions select…
Read MoreCash Management base Tables CE_BANK_ACCOUNTS: CE_BANK_ACCOUNTS contains Legal Entity Level bank account information. Each bank account must be affiliated with one bank branch. CE_BANK_ACCT_USES_ALL: CE_BANK_ACCT_USES_ALL…
Read MoreTables Involved CM Reconciliation Process 1) Run the program- Bank Statement Loader to load data in following Open Interface tables CE_STATEMENT_HEADERS_INT_ALL (Stores Information about bank statement Header details)…
Read MoreTables involved in O2C Process in Oracle EBS –ORDER MAIN TABLES select flow_status_code, booked_flag, a.* from oe_order_headers_all a where order_number = ‘1234’; select flow_status_code, a.* from oe_order_lines_all a where header_id…
Read More1 Validating Ledger Setups with script SELECT GLV.LEDGER_CATEGORY_CODE, GLV.NAME, GLV.SHORT_NAME, GLV.DESCRIPTION, GLV.CHART_OF_ACCOUNTS_ID, GLV.PERIOD_SET_NAME ACCOUNTING_CALENDAR, GLV.CURRENCY_CODE, GLV.SLA_ACCOUNTING_METHOD_CODE, GLV.FIRST_LEDGER_PERIOD_NAME, GLV.FUTURE_ENTERABLE_PERIODS_LIMIT, GLV.SLA_DESCRIPTION_LANGUAGE, A.CONCATENATED_SEGMENTS ENTERED_CURRENCY, –GLV.SLA_ENTERED_CUR_BAL_SUS_CCID, B.CONCATENATED_SEGMENTS RETAINED_EARNING, –GLV.RET_EARN_CODE_COMBINATION_ID, C.CONCATENATED_SEGMENTS ROUNDING_ACCOUNT, — GLV.ROUNDING_CODE_COMBINATION_ID ,…
Read More