PSA — Public Sector Financials
22 documented tables · 15 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
PSA_MF_RCT_DIST_ALL |
Accounts receivable distributions for a cash receipt or credit memo applied to mutiple fund transaction | standalone |
PSA_RECEIVABLES_TRX_ALL |
This table stores information whether a receivable activity is of multi-fund type or not | standalone |
PSA_TRX_TYPES_ALL |
Stores Public Sector Transaction Types Information | standalone |
PSA_EFC_SUMMARY_BUDGETS |
Summary Budgets with Enhanced Funds Check | standalone |
PSA_MF_ACCOUNT_MAPPING_ALL |
This table stores the Multi-Funds Account Mapping Details | standalone |
PSA_MF_ACCT_MAP_HEADER_ALL |
This table stores the Multi-Funds Account Mapping Headers | standalone |
PSA_IMPLEMENTATION_ALL |
Public Sector Advanced Features Implementation | standalone |
PSA_MISC_POSTING |
Thist table stores the posting details for the Misc-Receipts, with respect to their multi-fund entries | standalone |
PSA_MF_TRX_DIST_ALL |
Accountsreceivable distributions for a mutiplefund transaction | standalone |
PSA_MF_MISC_DIST_ALL |
This table store the multi-fund distributions of a miscellaneous receipt | standalone |
PSA_EFC_OPTIONS |
Enhanced Funds Check Options | standalone |
PSA_MF_ADJ_DIST_ALL |
Accounts receivable distributions for an adjustment made against a mutiple fund transaction | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
PSA_BC_XLA_PUB |
PUB | 2 | 20 packages |
PSA_BC_XML_REPORT_PUB |
PUB | 7 | 4 packages |
PSA_AP_BC_GRP |
GRP | 1 | 2 packages |