IM Ap Stage Detail Error
In ScopeTechnical: IM_AP_STAGE_DETAIL_ERROR | ID: OR-IM-IM_AP_STAGE_DETAIL_ERROR-IM_AP_STAGE_DETAIL_ERROR
Invoice Matching AP staging detail lines for documents posted to Oracle Financials, including transaction codes, amounts, VAT, and GL account segments that failed posting and were retained for error handling.
See how this object fits into Invoice Matching
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- IM_AP_STAGE_DETAIL_ERROR
Field Definitions(5)
Sample Load Data(4)
| _scenario | AMOUNTR | DOC_IDRPK | SEQ_NOR | TRAN_CODER | LINE_TYPE_LOOKUP_CODER | ORG_UNIT | SEGMENT1 | SEGMENT2 | SEGMENT3 | SEGMENT4 | SEGMENT5 | SEGMENT6 | SEGMENT7 | SEGMENT8 | SEGMENT9 | VAT_CODE | VAT_RATE | SEGMENT10 | SEGMENT11 | SEGMENT12 | SEGMENT13 | SEGMENT14 | SEGMENT15 | SEGMENT16 | SEGMENT17 | SEGMENT18 | SEGMENT19 | SEGMENT20 | POSTING_ID | REASON_CODE | REFERENCE_ID | LINE_GROUP_NO | NON_MERCH_CODE | ODI_SESSION_NUM | SET_OF_BOOKS_ID | CREATE_DATE_TIME | PRORATE_ACROSS_FLAG | SELF_ASSESSED_TAX_IND | BASIC_TRANSACTION_CODE | REASON_CODE_DESCRIPTION | NON_MRCH_CODE_DESCRIPTION | BASIC_TRANSACTION_CODE_DESC |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1.0000 | 1 | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1.0000000000 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | 1 | 1 | 2026-01-01 | S | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE |
| default | 12.5000 | 1000000003 | 4 | ALT-IM | ALT-IM_AP-002 | 3 | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | ALT-IM | 12.5000000000 | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | 1000000003 | ALT-IM_AP-002 | ALT-IM_AP-002 | 4 | ALT-IM | 4 | 1000000003 | 2026-01-03 | N | IM Ap Stage Detail Error-002-ALT | ALT-IM | IM Ap Stage Detail Error: Alternate source profile | IM Ap Stage Detail Error: Alternate source profile | IM Ap Stage Detail Error-002-ALT |
| default | 14.0000 | 1000000005 | 6 | EDGE-I | EDGE-IM_AP-003 | 5 | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | EDGE-I | 14.0000000000 | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | IM Ap Stage Detail Error- | 1000000005 | EDGE-IM_AP-003 | — | 6 | EDGE-I | 6 | 1000000005 | 2026-01-05 | N | IM Ap Stage Detail Error-003-EDGE | EDGE-I | — | — | IM Ap Stage Detail Error-003-EDGE |
Example values from field definitions
- AMOUNTR
- 1.0000
- DOC_IDRPK
- 1
- SEQ_NOR
- 1
- TRAN_CODER
- SAMPLE
- LINE_TYPE_LOOKUP_CODER
- SAMPLE
- ORG_UNIT
- 1
- SEGMENT1
- SAMPLE
- SEGMENT2
- SAMPLE
- SEGMENT3
- SAMPLE
- SEGMENT4
- SAMPLE
- SEGMENT5
- SAMPLE
- SEGMENT6
- SAMPLE
- SEGMENT7
- SAMPLE
- SEGMENT8
- SAMPLE
- SEGMENT9
- SAMPLE
- VAT_CODE
- SAMPLE
- VAT_RATE
- 1.0000000000
- SEGMENT10
- SAMPLE
- SEGMENT11
- SAMPLE
- SEGMENT12
- SAMPLE
- SEGMENT13
- SAMPLE
- SEGMENT14
- SAMPLE
- SEGMENT15
- SAMPLE
- SEGMENT16
- SAMPLE
- SEGMENT17
- SAMPLE
- SEGMENT18
- SAMPLE
- SEGMENT19
- SAMPLE
- SEGMENT20
- SAMPLE
- POSTING_ID
- 1
- REASON_CODE
- SAMPLE
- REFERENCE_ID
- SAMPLE
- LINE_GROUP_NO
- 1
- NON_MERCH_CODE
- SAMPLE
- ODI_SESSION_NUM
- 1
- SET_OF_BOOKS_ID
- 1
- CREATE_DATE_TIME
- 2026-01-01
- PRORATE_ACROSS_FLAG
- S
- SELF_ASSESSED_TAX_IND
- SAMPLE
- BASIC_TRANSACTION_CODE
- SAMPLE
- REASON_CODE_DESCRIPTION
- SAMPLE
- NON_MRCH_CODE_DESCRIPTION
- SAMPLE
- BASIC_TRANSACTION_CODE_DESC
- SAMPLE
default
- AMOUNTR
- 12.5000
- DOC_IDRPK
- 1000000003
- SEQ_NOR
- 4
- TRAN_CODER
- ALT-IM
- LINE_TYPE_LOOKUP_CODER
- ALT-IM_AP-002
- ORG_UNIT
- 3
- SEGMENT1
- IM Ap Stage Detail Error-
- SEGMENT2
- IM Ap Stage Detail Error-
- SEGMENT3
- IM Ap Stage Detail Error-
- SEGMENT4
- IM Ap Stage Detail Error-
- SEGMENT5
- IM Ap Stage Detail Error-
- SEGMENT6
- IM Ap Stage Detail Error-
- SEGMENT7
- IM Ap Stage Detail Error-
- SEGMENT8
- IM Ap Stage Detail Error-
- SEGMENT9
- IM Ap Stage Detail Error-
- VAT_CODE
- ALT-IM
- VAT_RATE
- 12.5000000000
- SEGMENT10
- IM Ap Stage Detail Error-
- SEGMENT11
- IM Ap Stage Detail Error-
- SEGMENT12
- IM Ap Stage Detail Error-
- SEGMENT13
- IM Ap Stage Detail Error-
- SEGMENT14
- IM Ap Stage Detail Error-
- SEGMENT15
- IM Ap Stage Detail Error-
- SEGMENT16
- IM Ap Stage Detail Error-
- SEGMENT17
- IM Ap Stage Detail Error-
- SEGMENT18
- IM Ap Stage Detail Error-
- SEGMENT19
- IM Ap Stage Detail Error-
- SEGMENT20
- IM Ap Stage Detail Error-
- POSTING_ID
- 1000000003
- REASON_CODE
- ALT-IM_AP-002
- REFERENCE_ID
- ALT-IM_AP-002
- LINE_GROUP_NO
- 4
- NON_MERCH_CODE
- ALT-IM
- ODI_SESSION_NUM
- 4
- SET_OF_BOOKS_ID
- 1000000003
- CREATE_DATE_TIME
- 2026-01-03
- PRORATE_ACROSS_FLAG
- N
- SELF_ASSESSED_TAX_IND
- IM Ap Stage Detail Error-002-ALT
- BASIC_TRANSACTION_CODE
- ALT-IM
- REASON_CODE_DESCRIPTION
- IM Ap Stage Detail Error: Alternate source profile
- NON_MRCH_CODE_DESCRIPTION
- IM Ap Stage Detail Error: Alternate source profile
- BASIC_TRANSACTION_CODE_DESC
- IM Ap Stage Detail Error-002-ALT
default
- AMOUNTR
- 14.0000
- DOC_IDRPK
- 1000000005
- SEQ_NOR
- 6
- TRAN_CODER
- EDGE-I
- LINE_TYPE_LOOKUP_CODER
- EDGE-IM_AP-003
- ORG_UNIT
- 5
- SEGMENT1
- IM Ap Stage Detail Error-
- SEGMENT2
- IM Ap Stage Detail Error-
- SEGMENT3
- IM Ap Stage Detail Error-
- SEGMENT4
- IM Ap Stage Detail Error-
- SEGMENT5
- IM Ap Stage Detail Error-
- SEGMENT6
- IM Ap Stage Detail Error-
- SEGMENT7
- IM Ap Stage Detail Error-
- SEGMENT8
- IM Ap Stage Detail Error-
- SEGMENT9
- IM Ap Stage Detail Error-
- VAT_CODE
- EDGE-I
- VAT_RATE
- 14.0000000000
- SEGMENT10
- IM Ap Stage Detail Error-
- SEGMENT11
- IM Ap Stage Detail Error-
- SEGMENT12
- IM Ap Stage Detail Error-
- SEGMENT13
- IM Ap Stage Detail Error-
- SEGMENT14
- IM Ap Stage Detail Error-
- SEGMENT15
- IM Ap Stage Detail Error-
- SEGMENT16
- IM Ap Stage Detail Error-
- SEGMENT17
- IM Ap Stage Detail Error-
- SEGMENT18
- IM Ap Stage Detail Error-
- SEGMENT19
- IM Ap Stage Detail Error-
- SEGMENT20
- IM Ap Stage Detail Error-
- POSTING_ID
- 1000000005
- REASON_CODE
- EDGE-IM_AP-003
- REFERENCE_ID
- —
- LINE_GROUP_NO
- 6
- NON_MERCH_CODE
- EDGE-I
- ODI_SESSION_NUM
- 6
- SET_OF_BOOKS_ID
- 1000000005
- CREATE_DATE_TIME
- 2026-01-05
- PRORATE_ACROSS_FLAG
- N
- SELF_ASSESSED_TAX_IND
- IM Ap Stage Detail Error-003-EDGE
- BASIC_TRANSACTION_CODE
- EDGE-I
- REASON_CODE_DESCRIPTION
- —
- NON_MRCH_CODE_DESCRIPTION
- —
- BASIC_TRANSACTION_CODE_DESC
- IM Ap Stage Detail Error-003-EDGE
Rule Validation Summary
- Source Rule Count
- 58
- Governed Rule Count
- 50