My Oracle Support Banner

W_RTL_PO_ONORD_IT_LC_DY_F Not Populated (Doc ID 3021285.1)

Last updated on MAY 09, 2024

Applies to:

Oracle Retail AI Foundation Cloud Service - Version 24.1 and later
Information in this document applies to any platform.

Goal

W_RTL_PO_ONORD_IT_LC_DY_F table is not populated after running SEED_CSV_W_RTL_PO_ONORD_IT_LC_DY_F_PROCESS_ADHOC.

Following was checked:
1. SEED_CSV_W_RTL_PO_ONORD_IT_LC_DY_F_PROCESS_ADHOC completed successfully
2. records inserted in W_RTL_PO_ONORD_IT_LC_DY_FS
3. no records in W_RTL_PO_ONORD_IT_LC_DY_F
4. records inserted in E$_W_RTL_PO_ONORD_IT_LC_DY_TMP table
5. no error in C_LOAD_DATES table

Steps followed:
1. Open Oracle Retail Process Orchestration and Monitoring
2. Click Batch Monitoring
3. Click AIF data.
4. Click Standalone Tab
5. Run SEED_CSV_W_RTL_PO_ONORD_IT_LC_DY_F_PROCESS_ADHOC
6. Job completes
7. No records in W_RTL_PO_ONORD_IT_LC_DY_F

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.