oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT HzPuiCustProfileEO.CUST_ACCOUNT_PROFILE_ID AS "CustAccountProfileId", HzPuiCustProfileEO.LAST_UPDATED_BY AS "LastUpdatedBy", HzPuiCustProfileEO.LAST_UPDATE_DATE AS "LastUpdateDate", HzPuiCustProfileEO.LAST_UPDATE_LOGIN AS "LastUpdateLogin", HzPuiCustProfileEO.CREATED_BY AS "CreatedBy", HzPuiCustProfileEO.CREATION_DATE AS "CreationDate", HzPuiCustProfileEO.CUST_ACCOUNT_ID AS "CustAccountId", HzPuiCustProfileEO.STATUS AS "Status", HzPuiCustProfileEO.COLLECTOR_ID AS "CollectorId", HzPuiCustProfileEO.CREDIT_ANALYST_ID AS "CreditAnalystId", HzPuiCustProfileEO.CREDIT_CHECKING AS "CreditChecking", HzPuiCustProfileEO.NEXT_CREDIT_REVIEW_DATE AS "NextCreditReviewDate", HzPuiCustProfileEO.TOLERANCE AS "Tolerance", HzPuiCustProfileEO.DISCOUNT_TERMS AS "DiscountTerms", HzPuiCustProfileEO.DUNNING_LETTERS AS "DunningLetters", HzPuiCustProfileEO.INTEREST_CHARGES AS "InterestCharges", HzPuiCustProfileEO.PREF_FUNCTIONAL_CURRENCY AS "PrefFunctionalCurrency", HzPuiCustProfileEO.SEND_STATEMENTS AS "SendStatements", HzPuiCustProfileEO.CREDIT_BALANCE_STATEMENTS AS "CreditBalanceStatements", HzPuiCustProfileEO.CREDIT_HOLD AS "CreditHold", HzPuiCustProfileEO.PROFILE_CLASS_ID AS "ProfileClassId", HzPuiCustProfileEO.SITE_USE_ID AS "SiteUseId", HzPuiCustProfileEO.CREDIT_RATING AS "CreditRating", HzPuiCustProfileEO.RISK_CODE AS "RiskCode", HzPuiCustProfileEO.STANDARD_TERMS AS "StandardTerms", HzPuiCustProfileEO.OVERRIDE_TERMS AS "OverrideTerms", HzPuiCustProfileEO.DUNNING_LETTER_SET_ID AS "DunningLetterSetId", HzPuiCustProfileEO.INTEREST_PERIOD_DAYS AS "InterestPeriodDays", HzPuiCustProfileEO.PAYMENT_GRACE_DAYS AS "PaymentGraceDays", HzPuiCustProfileEO.DISCOUNT_GRACE_DAYS AS "DiscountGraceDays", HzPuiCustProfileEO.STATEMENT_CYCLE_ID AS "StatementCycleId", HzPuiCustProfileEO.ACCOUNT_STATUS AS "AccountStatus", HzPuiCustProfileEO.PERCENT_COLLECTABLE AS "PercentCollectable", HzPuiCustProfileEO.AUTOCASH_HIERARCHY_ID AS "AutocashHierarchyId", HzPuiCustProfileEO.ATTRIBUTE_CATEGORY AS "AttributeCategory", HzPuiCustProfileEO.ATTRIBUTE1 AS "Attribute1", HzPuiCustProfileEO.ATTRIBUTE2 AS "Attribute2", HzPuiCustProfileEO.ATTRIBUTE3 AS "Attribute3", HzPuiCustProfileEO.ATTRIBUTE4 AS "Attribute4", HzPuiCustProfileEO.ATTRIBUTE5 AS "Attribute5", HzPuiCustProfileEO.ATTRIBUTE6 AS "Attribute6", HzPuiCustProfileEO.ATTRIBUTE7 AS "Attribute7", HzPuiCustProfileEO.ATTRIBUTE8 AS "Attribute8", HzPuiCustProfileEO.ATTRIBUTE9 AS "Attribute9", HzPuiCustProfileEO.ATTRIBUTE10 AS "Attribute10", HzPuiCustProfileEO.PROGRAM_APPLICATION_ID AS "ProgramApplicationId", HzPuiCustProfileEO.PROGRAM_ID AS "ProgramId", HzPuiCustProfileEO.PROGRAM_UPDATE_DATE AS "ProgramUpdateDate", HzPuiCustProfileEO.REQUEST_ID AS "RequestId", HzPuiCustProfileEO.WH_UPDATE_DATE AS "WhUpdateDate", HzPuiCustProfileEO.ATTRIBUTE11 AS "Attribute11", HzPuiCustProfileEO.ATTRIBUTE12 AS "Attribute12", HzPuiCustProfileEO.ATTRIBUTE13 AS "Attribute13", HzPuiCustProfileEO.ATTRIBUTE14 AS "Attribute14", HzPuiCustProfileEO.ATTRIBUTE15 AS "Attribute15", HzPuiCustProfileEO.AUTO_REC_INCL_DISPUTED_FLAG AS "AutoRecInclDisputedFlag", HzPuiCustProfileEO.TAX_PRINTING_OPTION AS "TaxPrintingOption", HzPuiCustProfileEO.CHARGE_ON_FINANCE_CHARGE_FLAG AS "ChargeOnFinanceChargeFlag", HzPuiCustProfileEO.GROUPING_RULE_ID AS "GroupingRuleId", HzPuiCustProfileEO.CLEARING_DAYS AS "ClearingDays", HzPuiCustProfileEO.JGZZ_ATTRIBUTE_CATEGORY AS "JgzzAttributeCategory", HzPuiCustProfileEO.JGZZ_ATTRIBUTE1 AS "JgzzAttribute1", HzPuiCustProfileEO.JGZZ_ATTRIBUTE2 AS "JgzzAttribute2", HzPuiCustProfileEO.JGZZ_ATTRIBUTE3 AS "JgzzAttribute3", HzPuiCustProfileEO.JGZZ_ATTRIBUTE4 AS "JgzzAttribute4", HzPuiCustProfileEO.JGZZ_ATTRIBUTE5 AS "JgzzAttribute5", HzPuiCustProfileEO.JGZZ_ATTRIBUTE6 AS "JgzzAttribute6", HzPuiCustProfileEO.JGZZ_ATTRIBUTE7 AS "JgzzAttribute7", HzPuiCustProfileEO.JGZZ_ATTRIBUTE8 AS "JgzzAttribute8", HzPuiCustProfileEO.JGZZ_ATTRIBUTE9 AS "JgzzAttribute9", HzPuiCustProfileEO.JGZZ_ATTRIBUTE10 AS "JgzzAttribute10", HzPuiCustProfileEO.JGZZ_ATTRIBUTE11 AS "JgzzAttribute11", HzPuiCustProfileEO.JGZZ_ATTRIBUTE12 AS "JgzzAttribute12", HzPuiCustProfileEO.JGZZ_ATTRIBUTE13 AS "JgzzAttribute13", HzPuiCustProfileEO.JGZZ_ATTRIBUTE14 AS "JgzzAttribute14", HzPuiCustProfileEO.JGZZ_ATTRIBUTE15 AS "JgzzAttribute15", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE1 AS "GlobalAttribute1", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE2 AS "GlobalAttribute2", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE3 AS "GlobalAttribute3", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE4 AS "GlobalAttribute4", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE5 AS "GlobalAttribute5", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE6 AS "GlobalAttribute6", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE7 AS "GlobalAttribute7", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE8 AS "GlobalAttribute8", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE9 AS "GlobalAttribute9", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE10 AS "GlobalAttribute10", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE11 AS "GlobalAttribute11", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE12 AS "GlobalAttribute12", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE13 AS "GlobalAttribute13", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE14 AS "GlobalAttribute14", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE15 AS "GlobalAttribute15", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE16 AS "GlobalAttribute16", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE17 AS "GlobalAttribute17", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE18 AS "GlobalAttribute18", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE19 AS "GlobalAttribute19", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE20 AS "GlobalAttribute20", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE_CATEGORY AS "GlobalAttributeCategory", HzPuiCustProfileEO.CONS_INV_FLAG AS "ConsInvFlag", HzPuiCustProfileEO.CONS_INV_TYPE AS "ConsInvType", HzPuiCustProfileEO.AUTOCASH_HIERARCHY_ID_FOR_ADR AS "AutocashHierarchyIdForAdr", HzPuiCustProfileEO.LOCKBOX_MATCHING_OPTION AS "LockboxMatchingOption", HzPuiCustProfileEO.OBJECT_VERSION_NUMBER AS "ObjectVersionNumber", HzPuiCustProfileEO.CREATED_BY_MODULE AS "CreatedByModule", HzPuiCustProfileEO.APPLICATION_ID AS "ApplicationId", HzPuiCustProfileEO.REVIEW_CYCLE AS "ReviewCycle", HzPuiCustProfileEO.LAST_CREDIT_REVIEW_DATE AS "LastCreditReviewDate", HzPuiCustProfileEO.PARTY_ID AS "PartyId", HzPuiCustProfileEO.CREDIT_CLASSIFICATION AS "CreditClassification", HzPuiCustProfileEO.CONS_BILL_LEVEL AS "ConsBillLevel", HzPuiCustProfileEO.LATE_CHARGE_CALCULATION_TRX AS "LateChargeCalculationTrx", HzPuiCustProfileEO.CREDIT_ITEMS_FLAG AS "CreditItemsFlag", HzPuiCustProfileEO.DISPUTED_TRANSACTIONS_FLAG AS "DisputedTransactionsFlag", HzPuiCustProfileEO.LATE_CHARGE_TYPE AS "LateChargeType", HzPuiCustProfileEO.LATE_CHARGE_TERM_ID AS "LateChargeTermId", HzPuiCustProfileEO.INTEREST_CALCULATION_PERIOD AS "InterestCalculationPeriod", HzPuiCustProfileEO.HOLD_CHARGED_INVOICES_FLAG AS "HoldChargedInvoicesFlag", HzPuiCustProfileEO.MESSAGE_TEXT_ID AS "MessageTextId", HzPuiCustProfileEO.MULTIPLE_INTEREST_RATES_FLAG AS "MultipleInterestRatesFlag", HzPuiCustProfileEO.CHARGE_BEGIN_DATE AS "ChargeBeginDate" FROM HZ_CUSTOMER_PROFILES HzPuiCustProfileEO WHERE HzPuiCustProfileEO.CUST_ACCOUNT_ID = :1 * at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)

Oracle Community | 714905 | 6 years ago
  1. 0

    Entity Object extension

    Oracle Community | 6 years ago | 714905
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT HzPuiCustProfileEO.CUST_ACCOUNT_PROFILE_ID AS "CustAccountProfileId", HzPuiCustProfileEO.LAST_UPDATED_BY AS "LastUpdatedBy", HzPuiCustProfileEO.LAST_UPDATE_DATE AS "LastUpdateDate", HzPuiCustProfileEO.LAST_UPDATE_LOGIN AS "LastUpdateLogin", HzPuiCustProfileEO.CREATED_BY AS "CreatedBy", HzPuiCustProfileEO.CREATION_DATE AS "CreationDate", HzPuiCustProfileEO.CUST_ACCOUNT_ID AS "CustAccountId", HzPuiCustProfileEO.STATUS AS "Status", HzPuiCustProfileEO.COLLECTOR_ID AS "CollectorId", HzPuiCustProfileEO.CREDIT_ANALYST_ID AS "CreditAnalystId", HzPuiCustProfileEO.CREDIT_CHECKING AS "CreditChecking", HzPuiCustProfileEO.NEXT_CREDIT_REVIEW_DATE AS "NextCreditReviewDate", HzPuiCustProfileEO.TOLERANCE AS "Tolerance", HzPuiCustProfileEO.DISCOUNT_TERMS AS "DiscountTerms", HzPuiCustProfileEO.DUNNING_LETTERS AS "DunningLetters", HzPuiCustProfileEO.INTEREST_CHARGES AS "InterestCharges", HzPuiCustProfileEO.PREF_FUNCTIONAL_CURRENCY AS "PrefFunctionalCurrency", HzPuiCustProfileEO.SEND_STATEMENTS AS "SendStatements", HzPuiCustProfileEO.CREDIT_BALANCE_STATEMENTS AS "CreditBalanceStatements", HzPuiCustProfileEO.CREDIT_HOLD AS "CreditHold", HzPuiCustProfileEO.PROFILE_CLASS_ID AS "ProfileClassId", HzPuiCustProfileEO.SITE_USE_ID AS "SiteUseId", HzPuiCustProfileEO.CREDIT_RATING AS "CreditRating", HzPuiCustProfileEO.RISK_CODE AS "RiskCode", HzPuiCustProfileEO.STANDARD_TERMS AS "StandardTerms", HzPuiCustProfileEO.OVERRIDE_TERMS AS "OverrideTerms", HzPuiCustProfileEO.DUNNING_LETTER_SET_ID AS "DunningLetterSetId", HzPuiCustProfileEO.INTEREST_PERIOD_DAYS AS "InterestPeriodDays", HzPuiCustProfileEO.PAYMENT_GRACE_DAYS AS "PaymentGraceDays", HzPuiCustProfileEO.DISCOUNT_GRACE_DAYS AS "DiscountGraceDays", HzPuiCustProfileEO.STATEMENT_CYCLE_ID AS "StatementCycleId", HzPuiCustProfileEO.ACCOUNT_STATUS AS "AccountStatus", HzPuiCustProfileEO.PERCENT_COLLECTABLE AS "PercentCollectable", HzPuiCustProfileEO.AUTOCASH_HIERARCHY_ID AS "AutocashHierarchyId", HzPuiCustProfileEO.ATTRIBUTE_CATEGORY AS "AttributeCategory", HzPuiCustProfileEO.ATTRIBUTE1 AS "Attribute1", HzPuiCustProfileEO.ATTRIBUTE2 AS "Attribute2", HzPuiCustProfileEO.ATTRIBUTE3 AS "Attribute3", HzPuiCustProfileEO.ATTRIBUTE4 AS "Attribute4", HzPuiCustProfileEO.ATTRIBUTE5 AS "Attribute5", HzPuiCustProfileEO.ATTRIBUTE6 AS "Attribute6", HzPuiCustProfileEO.ATTRIBUTE7 AS "Attribute7", HzPuiCustProfileEO.ATTRIBUTE8 AS "Attribute8", HzPuiCustProfileEO.ATTRIBUTE9 AS "Attribute9", HzPuiCustProfileEO.ATTRIBUTE10 AS "Attribute10", HzPuiCustProfileEO.PROGRAM_APPLICATION_ID AS "ProgramApplicationId", HzPuiCustProfileEO.PROGRAM_ID AS "ProgramId", HzPuiCustProfileEO.PROGRAM_UPDATE_DATE AS "ProgramUpdateDate", HzPuiCustProfileEO.REQUEST_ID AS "RequestId", HzPuiCustProfileEO.WH_UPDATE_DATE AS "WhUpdateDate", HzPuiCustProfileEO.ATTRIBUTE11 AS "Attribute11", HzPuiCustProfileEO.ATTRIBUTE12 AS "Attribute12", HzPuiCustProfileEO.ATTRIBUTE13 AS "Attribute13", HzPuiCustProfileEO.ATTRIBUTE14 AS "Attribute14", HzPuiCustProfileEO.ATTRIBUTE15 AS "Attribute15", HzPuiCustProfileEO.AUTO_REC_INCL_DISPUTED_FLAG AS "AutoRecInclDisputedFlag", HzPuiCustProfileEO.TAX_PRINTING_OPTION AS "TaxPrintingOption", HzPuiCustProfileEO.CHARGE_ON_FINANCE_CHARGE_FLAG AS "ChargeOnFinanceChargeFlag", HzPuiCustProfileEO.GROUPING_RULE_ID AS "GroupingRuleId", HzPuiCustProfileEO.CLEARING_DAYS AS "ClearingDays", HzPuiCustProfileEO.JGZZ_ATTRIBUTE_CATEGORY AS "JgzzAttributeCategory", HzPuiCustProfileEO.JGZZ_ATTRIBUTE1 AS "JgzzAttribute1", HzPuiCustProfileEO.JGZZ_ATTRIBUTE2 AS "JgzzAttribute2", HzPuiCustProfileEO.JGZZ_ATTRIBUTE3 AS "JgzzAttribute3", HzPuiCustProfileEO.JGZZ_ATTRIBUTE4 AS "JgzzAttribute4", HzPuiCustProfileEO.JGZZ_ATTRIBUTE5 AS "JgzzAttribute5", HzPuiCustProfileEO.JGZZ_ATTRIBUTE6 AS "JgzzAttribute6", HzPuiCustProfileEO.JGZZ_ATTRIBUTE7 AS "JgzzAttribute7", HzPuiCustProfileEO.JGZZ_ATTRIBUTE8 AS "JgzzAttribute8", HzPuiCustProfileEO.JGZZ_ATTRIBUTE9 AS "JgzzAttribute9", HzPuiCustProfileEO.JGZZ_ATTRIBUTE10 AS "JgzzAttribute10", HzPuiCustProfileEO.JGZZ_ATTRIBUTE11 AS "JgzzAttribute11", HzPuiCustProfileEO.JGZZ_ATTRIBUTE12 AS "JgzzAttribute12", HzPuiCustProfileEO.JGZZ_ATTRIBUTE13 AS "JgzzAttribute13", HzPuiCustProfileEO.JGZZ_ATTRIBUTE14 AS "JgzzAttribute14", HzPuiCustProfileEO.JGZZ_ATTRIBUTE15 AS "JgzzAttribute15", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE1 AS "GlobalAttribute1", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE2 AS "GlobalAttribute2", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE3 AS "GlobalAttribute3", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE4 AS "GlobalAttribute4", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE5 AS "GlobalAttribute5", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE6 AS "GlobalAttribute6", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE7 AS "GlobalAttribute7", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE8 AS "GlobalAttribute8", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE9 AS "GlobalAttribute9", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE10 AS "GlobalAttribute10", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE11 AS "GlobalAttribute11", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE12 AS "GlobalAttribute12", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE13 AS "GlobalAttribute13", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE14 AS "GlobalAttribute14", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE15 AS "GlobalAttribute15", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE16 AS "GlobalAttribute16", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE17 AS "GlobalAttribute17", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE18 AS "GlobalAttribute18", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE19 AS "GlobalAttribute19", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE20 AS "GlobalAttribute20", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE_CATEGORY AS "GlobalAttributeCategory", HzPuiCustProfileEO.CONS_INV_FLAG AS "ConsInvFlag", HzPuiCustProfileEO.CONS_INV_TYPE AS "ConsInvType", HzPuiCustProfileEO.AUTOCASH_HIERARCHY_ID_FOR_ADR AS "AutocashHierarchyIdForAdr", HzPuiCustProfileEO.LOCKBOX_MATCHING_OPTION AS "LockboxMatchingOption", HzPuiCustProfileEO.OBJECT_VERSION_NUMBER AS "ObjectVersionNumber", HzPuiCustProfileEO.CREATED_BY_MODULE AS "CreatedByModule", HzPuiCustProfileEO.APPLICATION_ID AS "ApplicationId", HzPuiCustProfileEO.REVIEW_CYCLE AS "ReviewCycle", HzPuiCustProfileEO.LAST_CREDIT_REVIEW_DATE AS "LastCreditReviewDate", HzPuiCustProfileEO.PARTY_ID AS "PartyId", HzPuiCustProfileEO.CREDIT_CLASSIFICATION AS "CreditClassification", HzPuiCustProfileEO.CONS_BILL_LEVEL AS "ConsBillLevel", HzPuiCustProfileEO.LATE_CHARGE_CALCULATION_TRX AS "LateChargeCalculationTrx", HzPuiCustProfileEO.CREDIT_ITEMS_FLAG AS "CreditItemsFlag", HzPuiCustProfileEO.DISPUTED_TRANSACTIONS_FLAG AS "DisputedTransactionsFlag", HzPuiCustProfileEO.LATE_CHARGE_TYPE AS "LateChargeType", HzPuiCustProfileEO.LATE_CHARGE_TERM_ID AS "LateChargeTermId", HzPuiCustProfileEO.INTEREST_CALCULATION_PERIOD AS "InterestCalculationPeriod", HzPuiCustProfileEO.HOLD_CHARGED_INVOICES_FLAG AS "HoldChargedInvoicesFlag", HzPuiCustProfileEO.MESSAGE_TEXT_ID AS "MessageTextId", HzPuiCustProfileEO.MULTIPLE_INTEREST_RATES_FLAG AS "MultipleInterestRatesFlag", HzPuiCustProfileEO.CHARGE_BEGIN_DATE AS "ChargeBeginDate" FROM HZ_CUSTOMER_PROFILES HzPuiCustProfileEO WHERE HzPuiCustProfileEO.CUST_ACCOUNT_ID = :1 * at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
  2. 0

    db:: 4.74::DirectAccess Services operation status is unknown a1

    hivmr.com | 5 months ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.DMLConstraintException: JBO-26048: Constraint "UK1" violated during post operation:"Insert" using SQL Statement "BEGIN INSERT INTO COM_TOE_HEADER(TOE_HEADER_ID,TOE_NUMBER,EFFECTIVE_DATE,EM_HEADER_ID,TOE_TYPE_HEADER_ID,APPROVED,STATUS,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) VALUES (?,?,?,?,?,?,?,?,?,?,?,?) RETURNING APPROVED, STATUS INTO ?, ?; END;".
  3. 0

    Urgent: Getting a oracle.jbo.DMLException: JBO-26041

    Oracle Community | 1 decade ago | 459203
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement " INSERT INTO GECM_SUBCOM_CATEGORIES_MAP(CATEGORY_KEY_ID,SUB_COMMODITY_ID,CATEGORY_ID,LAST_UPDATED_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY) VALUES (:1,:2,:3,:4,:5,:6,:7)".; (Could not lookup message because there is no database connection)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Facing problem in inserting record into table

    Oracle Community | 9 years ago | 603889
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO MISIBE_NOLICENSEREPORT(ID,PARTY_ID,REPORT_DATE,CREATED_BY) VALUES (?,?,?,?)".;
  6. 0

    how to fix exception in dev enviorment, while it's ok in dev instance

    Oracle Community | 8 years ago | Tsinhua-Oracle
    oracle.apps.fnd.framework.OAException: java.lang.IndexOutOfBoundsException: bitIndex < 0: -1

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.apps.fnd.framework.OAException

      oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT HzPuiCustProfileEO.CUST_ACCOUNT_PROFILE_ID AS "CustAccountProfileId", HzPuiCustProfileEO.LAST_UPDATED_BY AS "LastUpdatedBy", HzPuiCustProfileEO.LAST_UPDATE_DATE AS "LastUpdateDate", HzPuiCustProfileEO.LAST_UPDATE_LOGIN AS "LastUpdateLogin", HzPuiCustProfileEO.CREATED_BY AS "CreatedBy", HzPuiCustProfileEO.CREATION_DATE AS "CreationDate", HzPuiCustProfileEO.CUST_ACCOUNT_ID AS "CustAccountId", HzPuiCustProfileEO.STATUS AS "Status", HzPuiCustProfileEO.COLLECTOR_ID AS "CollectorId", HzPuiCustProfileEO.CREDIT_ANALYST_ID AS "CreditAnalystId", HzPuiCustProfileEO.CREDIT_CHECKING AS "CreditChecking", HzPuiCustProfileEO.NEXT_CREDIT_REVIEW_DATE AS "NextCreditReviewDate", HzPuiCustProfileEO.TOLERANCE AS "Tolerance", HzPuiCustProfileEO.DISCOUNT_TERMS AS "DiscountTerms", HzPuiCustProfileEO.DUNNING_LETTERS AS "DunningLetters", HzPuiCustProfileEO.INTEREST_CHARGES AS "InterestCharges", HzPuiCustProfileEO.PREF_FUNCTIONAL_CURRENCY AS "PrefFunctionalCurrency", HzPuiCustProfileEO.SEND_STATEMENTS AS "SendStatements", HzPuiCustProfileEO.CREDIT_BALANCE_STATEMENTS AS "CreditBalanceStatements", HzPuiCustProfileEO.CREDIT_HOLD AS "CreditHold", HzPuiCustProfileEO.PROFILE_CLASS_ID AS "ProfileClassId", HzPuiCustProfileEO.SITE_USE_ID AS "SiteUseId", HzPuiCustProfileEO.CREDIT_RATING AS "CreditRating", HzPuiCustProfileEO.RISK_CODE AS "RiskCode", HzPuiCustProfileEO.STANDARD_TERMS AS "StandardTerms", HzPuiCustProfileEO.OVERRIDE_TERMS AS "OverrideTerms", HzPuiCustProfileEO.DUNNING_LETTER_SET_ID AS "DunningLetterSetId", HzPuiCustProfileEO.INTEREST_PERIOD_DAYS AS "InterestPeriodDays", HzPuiCustProfileEO.PAYMENT_GRACE_DAYS AS "PaymentGraceDays", HzPuiCustProfileEO.DISCOUNT_GRACE_DAYS AS "DiscountGraceDays", HzPuiCustProfileEO.STATEMENT_CYCLE_ID AS "StatementCycleId", HzPuiCustProfileEO.ACCOUNT_STATUS AS "AccountStatus", HzPuiCustProfileEO.PERCENT_COLLECTABLE AS "PercentCollectable", HzPuiCustProfileEO.AUTOCASH_HIERARCHY_ID AS "AutocashHierarchyId", HzPuiCustProfileEO.ATTRIBUTE_CATEGORY AS "AttributeCategory", HzPuiCustProfileEO.ATTRIBUTE1 AS "Attribute1", HzPuiCustProfileEO.ATTRIBUTE2 AS "Attribute2", HzPuiCustProfileEO.ATTRIBUTE3 AS "Attribute3", HzPuiCustProfileEO.ATTRIBUTE4 AS "Attribute4", HzPuiCustProfileEO.ATTRIBUTE5 AS "Attribute5", HzPuiCustProfileEO.ATTRIBUTE6 AS "Attribute6", HzPuiCustProfileEO.ATTRIBUTE7 AS "Attribute7", HzPuiCustProfileEO.ATTRIBUTE8 AS "Attribute8", HzPuiCustProfileEO.ATTRIBUTE9 AS "Attribute9", HzPuiCustProfileEO.ATTRIBUTE10 AS "Attribute10", HzPuiCustProfileEO.PROGRAM_APPLICATION_ID AS "ProgramApplicationId", HzPuiCustProfileEO.PROGRAM_ID AS "ProgramId", HzPuiCustProfileEO.PROGRAM_UPDATE_DATE AS "ProgramUpdateDate", HzPuiCustProfileEO.REQUEST_ID AS "RequestId", HzPuiCustProfileEO.WH_UPDATE_DATE AS "WhUpdateDate", HzPuiCustProfileEO.ATTRIBUTE11 AS "Attribute11", HzPuiCustProfileEO.ATTRIBUTE12 AS "Attribute12", HzPuiCustProfileEO.ATTRIBUTE13 AS "Attribute13", HzPuiCustProfileEO.ATTRIBUTE14 AS "Attribute14", HzPuiCustProfileEO.ATTRIBUTE15 AS "Attribute15", HzPuiCustProfileEO.AUTO_REC_INCL_DISPUTED_FLAG AS "AutoRecInclDisputedFlag", HzPuiCustProfileEO.TAX_PRINTING_OPTION AS "TaxPrintingOption", HzPuiCustProfileEO.CHARGE_ON_FINANCE_CHARGE_FLAG AS "ChargeOnFinanceChargeFlag", HzPuiCustProfileEO.GROUPING_RULE_ID AS "GroupingRuleId", HzPuiCustProfileEO.CLEARING_DAYS AS "ClearingDays", HzPuiCustProfileEO.JGZZ_ATTRIBUTE_CATEGORY AS "JgzzAttributeCategory", HzPuiCustProfileEO.JGZZ_ATTRIBUTE1 AS "JgzzAttribute1", HzPuiCustProfileEO.JGZZ_ATTRIBUTE2 AS "JgzzAttribute2", HzPuiCustProfileEO.JGZZ_ATTRIBUTE3 AS "JgzzAttribute3", HzPuiCustProfileEO.JGZZ_ATTRIBUTE4 AS "JgzzAttribute4", HzPuiCustProfileEO.JGZZ_ATTRIBUTE5 AS "JgzzAttribute5", HzPuiCustProfileEO.JGZZ_ATTRIBUTE6 AS "JgzzAttribute6", HzPuiCustProfileEO.JGZZ_ATTRIBUTE7 AS "JgzzAttribute7", HzPuiCustProfileEO.JGZZ_ATTRIBUTE8 AS "JgzzAttribute8", HzPuiCustProfileEO.JGZZ_ATTRIBUTE9 AS "JgzzAttribute9", HzPuiCustProfileEO.JGZZ_ATTRIBUTE10 AS "JgzzAttribute10", HzPuiCustProfileEO.JGZZ_ATTRIBUTE11 AS "JgzzAttribute11", HzPuiCustProfileEO.JGZZ_ATTRIBUTE12 AS "JgzzAttribute12", HzPuiCustProfileEO.JGZZ_ATTRIBUTE13 AS "JgzzAttribute13", HzPuiCustProfileEO.JGZZ_ATTRIBUTE14 AS "JgzzAttribute14", HzPuiCustProfileEO.JGZZ_ATTRIBUTE15 AS "JgzzAttribute15", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE1 AS "GlobalAttribute1", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE2 AS "GlobalAttribute2", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE3 AS "GlobalAttribute3", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE4 AS "GlobalAttribute4", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE5 AS "GlobalAttribute5", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE6 AS "GlobalAttribute6", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE7 AS "GlobalAttribute7", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE8 AS "GlobalAttribute8", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE9 AS "GlobalAttribute9", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE10 AS "GlobalAttribute10", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE11 AS "GlobalAttribute11", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE12 AS "GlobalAttribute12", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE13 AS "GlobalAttribute13", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE14 AS "GlobalAttribute14", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE15 AS "GlobalAttribute15", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE16 AS "GlobalAttribute16", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE17 AS "GlobalAttribute17", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE18 AS "GlobalAttribute18", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE19 AS "GlobalAttribute19", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE20 AS "GlobalAttribute20", HzPuiCustProfileEO.GLOBAL_ATTRIBUTE_CATEGORY AS "GlobalAttributeCategory", HzPuiCustProfileEO.CONS_INV_FLAG AS "ConsInvFlag", HzPuiCustProfileEO.CONS_INV_TYPE AS "ConsInvType", HzPuiCustProfileEO.AUTOCASH_HIERARCHY_ID_FOR_ADR AS "AutocashHierarchyIdForAdr", HzPuiCustProfileEO.LOCKBOX_MATCHING_OPTION AS "LockboxMatchingOption", HzPuiCustProfileEO.OBJECT_VERSION_NUMBER AS "ObjectVersionNumber", HzPuiCustProfileEO.CREATED_BY_MODULE AS "CreatedByModule", HzPuiCustProfileEO.APPLICATION_ID AS "ApplicationId", HzPuiCustProfileEO.REVIEW_CYCLE AS "ReviewCycle", HzPuiCustProfileEO.LAST_CREDIT_REVIEW_DATE AS "LastCreditReviewDate", HzPuiCustProfileEO.PARTY_ID AS "PartyId", HzPuiCustProfileEO.CREDIT_CLASSIFICATION AS "CreditClassification", HzPuiCustProfileEO.CONS_BILL_LEVEL AS "ConsBillLevel", HzPuiCustProfileEO.LATE_CHARGE_CALCULATION_TRX AS "LateChargeCalculationTrx", HzPuiCustProfileEO.CREDIT_ITEMS_FLAG AS "CreditItemsFlag", HzPuiCustProfileEO.DISPUTED_TRANSACTIONS_FLAG AS "DisputedTransactionsFlag", HzPuiCustProfileEO.LATE_CHARGE_TYPE AS "LateChargeType", HzPuiCustProfileEO.LATE_CHARGE_TERM_ID AS "LateChargeTermId", HzPuiCustProfileEO.INTEREST_CALCULATION_PERIOD AS "InterestCalculationPeriod", HzPuiCustProfileEO.HOLD_CHARGED_INVOICES_FLAG AS "HoldChargedInvoicesFlag", HzPuiCustProfileEO.MESSAGE_TEXT_ID AS "MessageTextId", HzPuiCustProfileEO.MULTIPLE_INTEREST_RATES_FLAG AS "MultipleInterestRatesFlag", HzPuiCustProfileEO.CHARGE_BEGIN_DATE AS "ChargeBeginDate" FROM HZ_CUSTOMER_PROFILES HzPuiCustProfileEO WHERE HzPuiCustProfileEO.CUST_ACCOUNT_ID = :1 * at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)

      at oracle.apps.fnd.framework.server.OADBTransactionImpl.commit()
    2. oracle.apps.fnd
      OADBTransactionImpl.commit
      1. oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(OADBTransactionImpl.java:711)
      1 frame
    3. oracle.apps.ar
      ArCreCusCO.processFormRequest
      1. oracle.apps.ar.cusstd.createcus.webui.ArCreCusCO.processFormRequest(ArCreCusCO.java:233)
      1 frame
    4. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:815)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1189)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1027)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:993)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:848)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
      9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1027)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:993)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:848)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
      14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
      15. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2863)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1840)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:538)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:426)
      18 frames