- After completing AR Transaction there is no data or entry in AR_PAYMENT_SCHEDULES_ALL table.
- Possible reason is "Open Receivables" check box is not checked for the Transaction Type while creating it.
- If Open Receivable is set to Yes then Receivables updates Customer Balances each time you create a complete Credit Memo, Debit Memo, Chargeback, or On-Account Credit with this Transaction Type.
- This also includes these Transactions in the Standard Aging and Collection Processes in Receivables.
Thursday, May 12, 2022
Why there is no entry in AR_PAYMENT_SCHEDULES_ALL even after completing the AR Transaction in Oracle APPS
Wednesday, December 15, 2021
EB-Tax Setup Tables in Oracle APPS
|
Tax Setup |
Table Name |
|
Tax Regimes |
ZX_REGIMES_B |
|
Taxes |
ZX_TAXES_B |
|
Tax Status |
ZX_STATUS_B |
|
Tax Rates |
ZX_RATES_B |
|
Tax Jurisdictions |
ZX_JURISDICTIONS_B |
|
Tax Rules |
ZX_RULES_B |
EB-Tax Tables in Oracle APPS
|
TABLE_NAME |
|
ZX_ACCOUNTS |
|
ZX_ACCOUNT_RATES |
|
ZX_ACCT_TX_CLS_DEFS_ALL |
|
ZX_API_CODE_COMBINATIONS |
|
ZX_API_OWNER_STATUSES |
|
ZX_API_REGISTRATIONS |
|
ZX_COMPOUND_ERRORS |
|
ZX_COMPOUND_ERRORS_T |
|
ZX_CONDITIONS |
|
ZX_CONDITION_GROUPS_B |
|
ZX_CONDITION_GROUPS_TL |
|
ZX_CONTENT_CHOICES_TMP |
|
ZX_CONTENT_SOURCES |
|
ZX_DATA_UPLOAD_INTERFACE |
|
ZX_DETAIL_TAX_LINES_GT |
|
ZX_DETERMINING_FACTORS_B |
|
ZX_DET_FACTORS_TL |
|
ZX_DET_FACTOR_TEMPL_B |
|
ZX_DET_FACTOR_TEMPL_DTL |
|
ZX_DET_FACTOR_TEMPL_TL |
|
ZX_ERRORS_GT |
|
ZX_EVENT_CLASSES_B |
|
ZX_EVENT_CLASSES_TL |
|
ZX_EVENT_CLASS_PARAMS |
|
ZX_EVNT_CLS_MAPPINGS |
|
ZX_EVNT_CLS_OPTIONS |
|
ZX_EVNT_CLS_TYPS |
|
ZX_EVNT_TYP_MAPPINGS |
|
ZX_EXCEPTIONS |
|
ZX_EXEMPTIONS |
|
ZX_FC_CODES_B |
|
ZX_FC_CODES_CATEG_ASSOC |
|
ZX_FC_CODES_DENORM_B |
|
ZX_FC_CODES_TL |
|
ZX_FC_COUNTRY_DEFAULTS |
|
ZX_FC_TYPES_B |
|
ZX_FC_TYPES_REG_ASSOC |
|
ZX_FC_TYPES_TL |
|
ZX_FORMULA_B |
|
ZX_FORMULA_DETAILS |
|
ZX_FORMULA_TL |
|
ZX_ID_TCC_MAPPING_ALL |
|
ZX_IMPORT_TAX_LINES_GT |
|
ZX_ITM_DISTRIBUTIONS_GT |
|
ZX_JURISDICTIONS_B |
|
ZX_JURISDICTIONS_GT |
|
ZX_JURISDICTIONS_TL |
|
ZX_LINES |
|
ZX_LINES_DET_FACTORS |
|
ZX_LINES_SUMMARY |
|
ZX_PARAMETERS_B |
|
ZX_PARAMETERS_TL |
|
ZX_PARAM_DETAILS |
|
ZX_PARTY_TAX_PROFILE |
|
ZX_PARTY_TYPES |
|
ZX_PO_REC_DIST |
|
ZX_PROCESS_RESULTS |
|
ZX_PRODUCT_OPTIONS_ALL |
|
ZX_PRVDR_HDR_EXTNS_GT |
|
ZX_PRVDR_LINE_EXTNS_GT |
|
ZX_PTNR_LOCATION_INFO_GT |
|
ZX_PTNR_NEG_LINE_GT |
|
ZX_PTNR_NEG_TAX_LINE_GT |
|
ZX_PURGE_TRANSACTIONS_GT |
|
ZX_RATES_B |
|
ZX_RATES_TL |
|
ZX_REGIMES_USAGES |
|
ZX_REGIME_RELATIONS |
|
ZX_REGISTRATIONS |
|
ZX_REPORTING_CODES_B |
|
ZX_REPORTING_CODES_TL |
|
ZX_REPORTING_TYPES_B |
|
ZX_REPORTING_TYPES_TL |
|
ZX_REPORT_CODES_ASSOC |
|
ZX_REPORT_TYPES_USAGES |
|
ZX_REP_ACTG_EXT_T |
|
ZX_REP_CONTEXT_T |
|
ZX_REP_MATRIX_EXT_T |
|
ZX_REP_TRX_DETAIL_T |
|
ZX_REP_TRX_JX_EXT_T |
|
ZX_REVERSE_DIST_GT |
|
ZX_REVERSE_TRX_LINES_GT |
|
ZX_RULES_B |
|
ZX_RULES_TL |
|
ZX_SERVICE_TYPES |
|
ZX_SIM_CONDITIONS |
|
ZX_SIM_PROCESS_RESULTS |
|
ZX_SIM_PURGE |
|
ZX_SIM_RULES_B |
|
ZX_SIM_RULES_TL |
|
ZX_SIM_RULE_CONDITIONS |
|
ZX_SIM_TRX_DISTS |
|
ZX_SRVC_SBSCRPTN_EXCLS |
|
ZX_SRVC_SUBSCRIPTIONS |
|
ZX_SRVC_TYP_PARAMS |
|
ZX_STATUS_B |
|
ZX_STATUS_TL |
|
ZX_SUBSCRIPTION_DETAILS |
|
ZX_SUBSCRIPTION_OPTIONS |
|
ZX_TAXES_B |
|
ZX_TAXES_TL |
|
ZX_TAX_PRIORITIES_T |
|
ZX_TAX_RELATIONS_T |
|
ZX_TRANSACTION |
|
ZX_TRANSACTION_LINES |
|
ZX_TRANSACTION_LINES_GT |
|
ZX_TRX_HEADERS_GT |
|
ZX_TRX_LINE_APP_REGIMES |
|
ZX_TRX_PRE_PROC_OPTIONS_GT |
|
ZX_TRX_TAX_LINK_GT |
|
ZX_UPDATE_CRITERIA_RESULTS |
|
ZX_VALIDATION_ERRORS_GT |
APEX$TASK_PK
APEX$TASK_PK is a substitution string holding the primary key value of the system of records
-
The XDOLoader utility is a Java-based command line program to load template (RTF, PDF, and XSL-FO), XML, and XSD files to the XML Publis...
-
SELECT aca.check_number ,aia.invoice_id ,aia.invoice_num ,aia.invoice_amount ,distribution_line_number ,aida.accrual_p...
-
Serial_number_control_code column contains values as 1,2,5 &6 in mtl_system_items_b table. Inorder to find meaning for this values r...
