PSA Tables (22)
PSA - Public Sector Financials — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
PSA_BC_ALLOC_GT |
5 | This table holds the parent child relationship hierarchy of budgetary control accounting events. The hierarchy is used to link accounting li |
PSA_BC_REPORT_EVENTS_GT |
8 | This is an interface table for Budgetary Control Results Report. Product teams insert data in this table prior to invoking the report. Data |
PSA_BC_RESULTS_GT |
104 | |
PSA_BC_XLA_EVENTS_GT |
2 | This is an interface table to invoke accounting with budgetary control. Product teams populate events in this table prior to calling the Bud |
PSA_DEBUG_LOG |
5 | This table is used to store the debug log messages |
PSA_EFC_OPTIONS |
7 | Enhanced Funds Check Options |
PSA_EFC_SUMMARY_BUDGETS |
7 | Summary Budgets with Enhanced Funds Check |
PSA_IMPLEMENTATION_ALL |
11 | Public Sector Advanced Features Implementation |
PSA_MF_ACCOUNT_MAPPING_ALL |
30 | This table stores the Multi-Funds Account Mapping Details |
PSA_MF_ACCT_MAP_HEADER_ALL |
9 | This table stores the Multi-Funds Account Mapping Headers |
PSA_MF_ADJ_DIST_ALL |
30 | Accounts receivable distributions for an adjustment made against a mutiple fund transaction |
PSA_MF_ADJ_REC_BUF |
32 | Temporary Table to store Adjustment records during GL Transfer |
PSA_MF_DISTRIBUTIONS_LOG |
10 | Multiple Fund Distributions Error Log |
PSA_MF_MISC_DIST_ALL |
34 | This table store the multi-fund distributions of a miscellaneous receipt |
PSA_MF_RCT_DIST_ALL |
38 | Accounts receivable distributions for a cash receipt or credit memo applied to mutiple fund transaction |
PSA_MF_RCT_REC_BUF |
43 | Temporary Table to store Receivable-Application records during GL Transfer |
PSA_MF_TRX_DIST_ALL |
25 | Accountsreceivable distributions for a mutiplefund transaction |
PSA_MF_TRX_REC_BUF |
25 | Temporary Table to store Transaction-Distribution records during GL Transfer |
PSA_MISC_POSTING |
3 | Thist table stores the posting details for the Misc-Receipts, with respect to their multi-fund entries |
PSA_OPTION_DETAILS_GT |
9 | This table is created to improve performance of funds checker. It is populated with the budgetary control parameters for each packet, journa |
PSA_RECEIVABLES_TRX_ALL |
22 | This table stores information whether a receivable activity is of multi-fund type or not |
PSA_TRX_TYPES_ALL |
22 | Stores Public Sector Transaction Types Information |