oracle日记账导入,求助 日记账导入报错 但是手动输入正常

这是一份关于财务系统中出现错误的日志报告。主要问题包括日期不在有效范围内、未平衡的日记账条目、警告和错误代码,如EP01、EP03、WU01和EU02等。报告详细列出了错误源、错误代码、批次创建和发布的状态,以及未平衡的日记账条目。解决方案可能涉及检查日期有效性、调整日记账平衡和修复会计规则。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

下面是报错日志。

有谁知道怎么解决呀?

谢谢

AVXTJ                                             Journal ImportExecution Report                              Date: 07-SEP-09 14:17

Concurrent Request ID:400162                                                                                 Page:               1

Total   Total  Total Total Unbalanced Total Unbalanced Total Flex Total Non-Flex

Journal Entry Source Name       Group Id Status    Lines BatchesHeaders          Batches          Headers     Errors         Errors

---------------------------- ----------- ------- ------- -------------- ---------------- ---------------- ---------- --------------

AVXTJCASH                                Error        22       2      4                0                0          0              8

------- -------------- ---------------- ---------------- ---------- --------------

*** TOTALS ***                                        22       2      4                0                0          0              8

=======================================================   BatchesCreated   ========================================================

Total   Total               Total               Total

Warning Batch Name                                               PeriodName   Lines Headers    Accounted Debits   Accounted Credits

------- ------------------------------------------------------------------- ------- ------- ------------------- -------------------

==================================================   Batches Posted toSuspense   ==================================================

Flexfield                                                                                       Line

Error Code          Batch Name                         Period Name Header Name                  Number Accounting Flexfield

------------------- ---------------------------------- --------------------------------------- ------ -----------------------------

=================================================   Unbalanced JournalEntries**   =================================================

Error                                                                            Total

Code  Journal Entry Name                    BatchName                           Lines Period Name     Total Debits   Total Credits

----- ------------------------------------------------------------------------- ----- ----------- --------------------------------

=========================================================   ErrorLines   ==========================================================

Accounting

Error Code                     Source        Date        Currency     Entered Debit     Entered Credit Accounting Flexfield/CCID

------------------------------ ------------- ----------- -------------------------- ------------------ ----------------------------

EC03                           AVXTJCASH     31-MAY-09  CNY                  366.29                  0840.400.A4000110010G10.000.0

EC03                           AVXTJCASH     31-MAY-09  CNY                  366.29                  0840.400.A4000110010G10.000.0

EC03                           AVXTJCASH     31-MAY-09  CNY                  366.29                  0840.400.A4000119010G10.000.0

EC03                           AVXTJCASH     31-MAY-09  CNY                  366.29                  0840.400.A4000119010G10.000.0

EC03                           AVXTJCASH     31-MAY-09  CNY                       0             366.29840.400.A4000110010A20.000.0

EC03                           AVXTJCASH     31-MAY-09  CNY                       0             366.29840.400.A4000110010A20.000.0

EC03                           AVXTJCASH     31-MAY-09  CNY                       0             366.29840.400.A4000119010G10.000.0

EC03                           AVXTJCASH     31-MAY-09  CNY                       0             366.29840.400.A4000119010G10.000.0

==========================================================   ErrorKey   ===========================================================

Period Error Codes

------------------

EP01    This date is not in any open or future enterable period.

EP03    This date is not within any period in an open encumbrance year.

AVXTJ                                             Journal ImportExecution Report                              Date: 07-SEP-09 14:17

Concurrent Request ID:400162                                                                                 Page:               2

==========================================================   ErrorKey   ===========================================================

Period Error Codes

------------------

EP04    This date is not a business day.

EP05    There are no business days in this period.

Unbalanced Journal Error Codes

------------------------------

WU01    Warning: This journal entry is unbalanced.  It is accepted because suspense posting is allowed in this ledger.

EU02    This journal entry is unbalanced and suspense posting is not allowed in this ledger.

EU03    This encumbrance journal entry is unbalanced and the Reserve for Encumbrance account is not defined.

Flexfield Error Codes

---------------------

EF01    This Accounting Flexfield is inactive for this accounting date.

EF02    Detail posting not allowed for this Accounting Flexfield.

EF03    Disabled Accounting Flexfield.

EF04    This is an invalid Accounting Flexfield.  Check your cross-validation rules and segment values.

EF05    There is no Accounting Flexfield with this Code Combination ID.

EF06    The alternate account is invalid.

WF01    An alternate account was used instead of the original account.

WF02    A suspense account was used instead of the original account.

Foreign Currency Error Codes

----------------------------

EC01    A conversion rate must be entered when using the User conversion rate type.

EC02    There is no conversion date supplied.

EC03    A conversion rate type or an accounted amount must be supplied when entering foreign currency journal lines.

EC06    There is no conversion rate for this currency, conversion type, and conversion date.

EC08    Invalid currency code.

EC09    No currencies are enabled.

EC10    Encumbrance journals cannot be created in a foreign currency.

EC11    Invalid conversion rate type.

EC12    The entered amount must equal the accounted amount in a ledger or STAT currency journal line.

EC13    Amount is too large.

ECW1    Warning: Converted amounts could not be validated because the conversion rate type is not specified.

Budget Error Codes

------------------

EB01    A budget version is required for budget lines.

EB02    Journals cannot be created for a frozen budget.

EB03    The budget year is not open.

EB04    This budget does not exist for this ledger.

EB05    The encumbrance_type_id column must be null for budget journals.

EB06    A period name is required for budget journals.

EB07    This period name is not valid.  Check calendar for valid periods.

EB08    Average journals cannot be created for budgets.

EB09    Originating company information cannot be specified for budgets.

Encumbrance Error Codes

-----------------------

EE01    An encumbrance type is required for encumbrance lines.

EE02    Invalid or disabled encumbrance type.

AVXTJ                                             Journal ImportExecution Report                              Date: 07-SEP-09 14:17

Concurrent Request ID:400162                                                                                 Page:               3

==========================================================   ErrorKey   ===========================================================

Encumbrance Error Codes

-----------------------

EE03    Encumbrance journals cannot be created in the STAT currency.

EE04    The BUDGET_VERSION_ID column must be null for encumbrance lines.

EE05    Average journals cannot be created for encumbrances.

EE06    Originating company information cannot be specified for encumbrances.

Reversal Error Codes

--------------------

ER01    A reversal period name must be provided.

ER02    This reversal period name is invalid.  Check your calendar for valid periods.

ER03    A reversal date must be provided

ER04    This reversal date is not in a valid period.

ER05    This reversal date is not in your database date format.

ER06    Your reversal date must be the same as or after your effective date.

ER07    This reversal date is not a business day.

ER08    There are no business days in your reversal period.

ER09    Default reversal information could not be determined.

Descriptive Flexfield Error Codes

---------------------------------

ED01    The context and attribute values do not form a valid descriptive flexfield for Journals - Journal Entry Lines.

ED02    The context and attribute values do not form a valid descriptive flexfield for Journals - Captured Information.

ED03    The context and attribute values do not form a valid descriptive flexfield for Value Added Tax.

Miscellaneous Error Codes

-------------------------

EM01    Invalid journal entry category.

EM02    There are no journal entry categories defined.

EM04    The value in the ACTUAL_FLAG must be "A" (actuals), "B" (budgets), or "E" (encumbrances).

EM05    The encumbrance_type_id column must be null for actual journals.

EM06    The budget_version_id column must be null for actual journals.

EM07    A statistical amount belongs in the entered_dr(cr) column when entering a STAT currency journal line.

EM09    There is no Transaction Code defined.

EM10    Invalid Transaction Code.

EM12    An Oracle error occurred when generating sequential numbering.

EM13    The assigned sequence is inactive.

EM14    There is a sequential numbering setup error resulting from a missing grant or synonym.

EM17    Sequential numbering is always used and there is no assignment for this ledger and journal entry category.

EM18    Manual document sequences cannot be used with Journal Import.

EM19    Value Added Tax data is only valid in conjunction with actual journals.

EM24    Average journals can only be imported into consolidation ledgers.

EM25    Invalid average journal flag.  Valid values are "Y", "N", and null.

EM26    Invalid originating company.

EM27    Originating company information can only be specified when intercompany balancing is enabled.

EM29    You do not have access to this ledger and account combination.

EM30    This balancing segment value is not valid for this ledger.

EM31    This management segment value is not valid for this ledger.

** Batches listed under "Unbalanced Batches**" have not been imported.

AVXTJ                                             Journal ImportExecution Report                              Date: 07-SEP-09 14:17

Concurrent Request ID:400162                                                                                 Page:               4

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值