Groups of Account Reconciliation Sync Saved Searches
The Account Reconciliation Sync saved searches are listed in the following groups:
-
Reconciliation Compliance
The following table shows the names and IDs of the saved searches included in this group:
Saved Search Name
Saved Search ID
NSAR Balance Sheet Inventory Subsystem
customsearch_nsar_bs_subsys_inv_trans
NSAR Balance Sheet AP Subsystem
customsearch_nsar_bs_subsys_ap_trans
NSAR Balance Sheet AR Subsystem
customsearch_nsar_bs_subsys_ar_trans
NSAR Balance Sheet Ending Balance
customsearch_nsar_bs_ending_bal
NSAR Balance Sheet Ending Balance -Functional
customsearch_nsar_bs_ending_bal_fnc
These saved searches are configured in Data Exchange and LCM imports to load data into the Account Reconciliation application. If you make any changes to these saved searches, you may need to update the Data Exchange configurations. For information about the use of Data Exchange, refer to Administering Data Integration for Oracle Enterprise Performance Management Cloud in the Oracle Help Center.
-
Transaction Matching
The following table shows the name and ID of the saved search included in this group:
Saved Search Name
Saved Search ID
NSAR GL Transaction Lines
customsearch_nsar_gl_trans_lines
This saved search is not configured in LCM imports. You need to configure it manually in the Account Reconciliation application. For information about how this saved search is involved in Account Reconciliation Transaction Matching, see Transaction Matching Accounts.
-
Other Searches
The following table shows the name and ID of the saved search included in this group:
Saved Search Name
Saved Search ID
NSAR Profile Template
customsearch_nsar_profile_template
NSAR Job Execution Search
customsearch_job_nsar_execution
The NSAR Profile Template saved search is used for generating the Profile data type export file. You can update the saved search before you export data. For more details, see Account Reconciliation Data Export and Import.
The NSAR Job Execution Search saved search is used to see the list of jobs that failed to execute and the error message.
For information about creating and customizing the saved searches, see the following help topics: