各位大侠，ＡＲ发票保存成功时，但点完成时报错？详见附件．紧急求助！！！

leap2005

ＡＲ发票保存成功时，但点完成时报错，什么原因？


各位大侠，ＡＲ发票保存成功时，但点完成时报错？紧急求助！！！
错误提示！

ORA-01400: 无法将 NULL 插入 ("AR"."AR_PAYMENT_SCHEDULES_ALL"."GL_DATE_CLOSED")
ORA-06512: 在"APPS.ARP_PROCESS_HEADER_POST_COMMIT", line 896
ORA-06512: 在"APPS.ARP_PROCESS_HEADER", line 1719

纵横四海批注：
请参考：
http://bbs.erp100.com/viewthread.php?tid=20078&highlight=ORA-01400

纵横四海

请参考：
http://bbs.erp100.com/viewthread ... highlight=ORA-01400

leap2005

Subject:  FRM-40735 ORA-01400 ORA-06512: TRYING TO COMPLETE A MANUAL INVOICE
  Doc ID:  Note:1048270.6 Type:  PROBLEM
  Last Revision Date:  04-AUG-2000 Status:  PUBLISHED


Problem Description
-------------------
You are trying to complete a manual invoice and see the following error:

  FRM-40735 POST-FORMS-COMMIT trigger raised unhandled exception
  ORA-01400 manditory (NOT NULL) column is missing or null during insert.
  ORA-06512 : AT "APPS.ARP_PROCESS_HEADER_POST_COMMIT", line 486.
  ORA-06512 : AT "APPS.ARP_PROCESS_HEADER", line 1213.
  ORA-06512 : AT line 1.

Duplication Steps
-----------------
Navigate: Transactions -> Class = Invoice, Choose type = Invoice standard.  
Choose ship to, enter terms, enter salesperson, go into Line Items: choose
an item, enter the quantity, unit price and tax code.  You are able to
save your work with no errors.  When you try to complete the invoice, you
see the error message.

Solution Description
--------------------
Check for invalid object and recompile if necessary, then check the status
of triggers.

1) Check for invalid objects:

SELECT OBJECT_NAME, STATUS         
FROM all_objects
WHERE status = 'INVALID';

2) Recompile any invalid objects.  For general recompile:

select distinct 'alter '
||decode(object_type,'PACKAGE BODY','PACKAGE',object_type)
        ||' '||object_name||' compile'
        ||decode(object_type,'PACKAGE BODY',' body','PACKAGE',' specification')
        ||';' Object
from user_objects
where status='INVALID' and object_type != 'PACKAGE'
order by Object

3) Check the status of triggers:

select trigger_name, status from
all_triggers
where trigger_name like '%AR_PAYMENT%';

update triggers to enable (if disabled)
client/server/node

alter trigger ar_payment_schedules_bru enable;
alter trigger ar_payment_schedules_bri enable;

After completing the three steps above, you should be able to complete a
manual invoice.