You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    HCM Extract: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

    edited Mar 25, 2025 5:30AM in HCM Extract 2 comments

    Summary:

    The extract is running into error, logging also set to "no logging". But still the extract running into error, below shows log.

    There was a ORA-06502: PL/SQL: numeric or value error: character string buffer too small
    ORA-06512: at "SYS.DBMS_SQL", line 1750
    ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 717
    ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 2249
    ORA-06
    Name null
    Token1 null
    Token2 null
    Token3 null

    Followed the document below, but still issue exists.

    Doc ID 2763609.1

    Content (please ensure you mask any confidential information):


    Version (include the version you are using, if applicable):



    Code Snippet (add any code snippets that support your topic, if applicable):

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!