Order Management - EBS (MOSC)

MOSC Banner

INO 810 Allowance Charge Indicator is null in ECE_INO_ALLOWANCE_CHARGES_V

edited Feb 12, 2020 10:52AM in Order Management - EBS (MOSC) 2 commentsAnswered ✓

Hello, I have noticed that even when I have freight, the allowance charge indicator is null.  I have opened ECE_INO_ALLOWANCE_CHARGES_V, and the view definition is such:

Is this a bug or does Oracle just not provide any data on the allowance charge indicator?  Or, do I have to use the extension table?

SELECT RCTL.CUSTOMER_TRX_ID                       TRANSACTION_ID,

           RCTL.LINE_NUMBER                           LINE_NUMBER,

           RCTL.LINE_TYPE                             LINE_TYPE,

           RCTL.CUSTOMER_TRX_LINE_ID                  CUSTOMER_TRX_LINE_ID,

           NVL (RCTL.LINK_TO_CUST_TRX_LINE_ID, 0)     LINK_TO_CUST_TRX_LINE_ID,

           TO_CHAR (NULL)                             HEADER_DETAIL_INDICATOR,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center