apex icon indicating copy to clipboard operation
apex copied to clipboard

Published 20 hours ago • verified publisher icon oracle

Error creating Opportunities on app Opportunities

Open jualfoar opened this issue 2 years ago • 1 comments

I have this error when I click Create Opportunity image I tried to change the Time Zone but still the problem.

Im new in apex. Sorry in advance. Thank you.

jualfoar avatar Jun 28 '23 17:06 jualfoar

Error log:

`Error: Unable to create opportunity

  • Additional info: ORA-01840: input value not long enough for date format

  • Display location: ON_ERROR_PAGE

  • Association type:

  • Item name:

  • Region id:

  • Column alias:

  • Row:

  • Model instance id:

  • Model record id:

  • Internal error: false

  • Common runtime error: false

  • APEX error code:

  • SQL code: -1840

  • SQL error: ORA-01840: input value not long enough for date format ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS_NATIVE", line 55 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 126 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2643 ORA-06512: at line 38 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230100", line 806 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2603 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 97 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 430 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC", line 614 ORA-06512: at "APEX_230100.WWV_FLOW_EXEC_LOCAL", line 3101 ORA-06512: at "APEX_230100.WWV_FLOW_EXEC", line 2657 ORA-06512: at "APEX_230100.WWV_FLOW_EXEC", line 2693 ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS_NATIVE", line 34 ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS_NATIVE", line 1265 ORA-06512: at "APEX_230100.WWV_FLOW_PLUGIN", line 3443

  • Backtrace: ORA-06512: at line 38 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230100", line 806 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2603 ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS_NATIVE", line 55 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 126 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2643 ORA-06512: at line 38 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230100", line 806 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2603 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 97 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 430 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC", line 614 ORA-06512: at "APEX_230100.WWV_FLOW_EXEC_LOCAL", line 3101 ORA-06512: at "APEX_230100.WWV_FLOW_EXEC", line 2657 ORA-06512: at "APEX_230100.WWV_FLOW_EXEC", line 2693 ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS_NATIVE", line 34 ORA-06512: at "APEX_230100.WWV_FLOW_PROCES~

  • Statement: begin declare l_account_id number; l_opp_id number;

    la_product apex_application_global.vc_arr2; la_team apex_application_global.vc_arr2; la_competition apex_application_global.vc_arr2; begin if :P71_NEW_OR_EXISTING = 'NEW' then insert into eba_sales_customers ( customer_name, customer_territory_id, customer_web_site, customer_duns, customer_sic, customer_stock_symb, customer_is_key_account_yn, default_rep_id, customer_description, tags
    ) values ( :P71_CUSTOMER_NAME, :P71_TERRITORY_ID, :P71_CUSTOMER_WEB_SITE, :P71_CUSTOMER_DUNS, :P71_CUSTOMER_SIC, :P71_CUSTOMER_STOCK_SYMB, :P71_CUSTOMER_IS_KEY_ACCOUNT_YN, :P71_DEFAULT_REP_ID, :P71_CUSTOMER_DESCRIPTION, :P71_TAGS ) returning id into l_account_id; else l_account_id := :P71_ACC~

  • Component: APEX_APPLICATION_PAGE_PROCESS create opportunity (41091876933402302237)`

jualfoar avatar Jun 28 '23 18:06 jualfoar