Compile error ORA-06553: PLS-306: wrong number or types of arguments in call to 'DATE_TO_CHARDT' on Form GMEIBFED

(Doc ID 1997634.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Setup Issues

Compile Adadmin generate Error

Compile using ada adadmin generate error.
After creating an issue, Engineer at Oracle Support suggest to do Compile on Form, Schema and Procedure using Adadmin.
Here are the suggestions :
- start adadmin
- 1 Generate Applications Files menu
- 2 Generate form files
- 'No' on regenerate Oracle Forms PL/SQL
- 'No' on regenerate Oracle Forms menu
- 'Yes' on regenerate Oracle Forms executable files
- 'inv' on Product
- 'No' on Generate specific forms objects
- 'All' on Enter libraries.


FRM-30085: Unable to adjust form for output.

FRM-30064: Unable to parse statement select p.batch_no, g.meaning, fnd_date.date_to_charDT(p.plan_start_date,2) plan_start_date,
  formula_no, formula_vers,
  p.batch_id, plan_qty, m.dtl_um, p.batch_status
from gme_batch_header p, fm_form_mst f,
  gme_material_details m, gem_lookups g
where p.delete_mark = 0
  and p.organization_id = :parameter.org_id
  and p.update_inventory_ind = 'Y'
  and m.batch_id = p.batch_id
  and p.formula_id= f.formula_id(+)
  and m.line_type = 1 and m.line_no = 1
  and batch_status in (2,3) and batch_type = 0
  and g.lookup_type = 'GME_BATCH_STATUS'
  and g.lookup_code = p.batch_status
  and g.enabled_flag = 'Y'
  order by p.batch_id desc .
ORA-06553: PLS-306: wrong number or types of arguments in call to 'DATE_TO_CHARDT'
Record Group BATCH_NO

The issue can be reproduced at will with the following steps:
1. Run adadmin for GME application

The issue has the following business impact:
Due to this issue form GMEIBFED is not generated


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms