Fusion PIM: Product Hub Publication Job Errors Out When Publishing Item Data With Supplier Association (Doc ID 1629640.1)

Last updated on JANUARY 19, 2016

Applies to:

Oracle Fusion Product Hub Cloud Service - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

Product Hub Publication Job errors out when publishing Item data with Supplier associations.

ERROR
---------
Execution error for request 11702. Reason: ESS-01708 Database job for request 11702 ended with error: SQL execution error. JobName: FUSION_RUNTIME.ESS32$JB_11702
Supplemental Detail --- SQL Execution Error ---
ErrorCode: 20979
ErrorMsg: [ORA-20979: Request 11702 encountered ERROR: ORA-06502: PL/SQL:
numeric or value error: character to number conversion error while executing
BEGIN egi_spoke_publication.load_publication_tables(:errbuf, :retcode ); END;

at ORA-06512: at "FUSION.FND_EXECUTE", line 226]
--- SQL Error Detail ---
[Error_Stack]
ORA-20979: Request 11702 encountered ERROR: ORA-06502: PL/SQL: numeric or
value error: character to number conversion error while executing BEGIN
egi_spoke_publication.load_publication_tables(:errbuf, :retcode ); END; at
ORA-06512: at "FUSION.FND_EXECUTE", line 226
[Error_Backtrace]
ORA-06512: at "FUSION.FND_EXECUTE", line 329
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1825
ORA-06512: at "FUSION.FND_EXECUTE", line 363
ORA-06512: at "FUSION.FND_EXECUTE", line 347
ORA-06512: at line 1
ORA-06512: at "FUSION_ORA_ESS.ESS_SCHJOB_PROC", line 16


Steps To reproduce:
----------

  1. Navigator >Items > Manage Spoke System > Publication Options
  2. Publish Items
  3. Item Selection Criteria
  4. Item Entities - Select all (including supplier associations) and move to selected list
  5. Item selection rules:
    • Business Entity = Item Class
    • Operator = Equals
    • Entity Name = Root Item Class
    • Include Child Item Classes = checked
  6. Save
  7. Submit 'Product Hub Publication Job' for the spoke system with following parameters:
  8. Publish Items = yes
  9. Publish Item Classes = no
  10. Publish Catalog= No
  11. Criteria = 1/1/14

Publication Job ends in error.

 

Cause

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