Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error creating Opportunities on app Opportunities #48

Open
jualfoar opened this issue Jun 28, 2023 · 1 comment
Open

Error creating Opportunities on app Opportunities #48

jualfoar opened this issue Jun 28, 2023 · 1 comment

Comments

@jualfoar
Copy link

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
Copy link
Author

jualfoar commented Jun 28, 2023

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)`

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant