Using the My Oracle Support Portal (MOSC)

MOSC Banner

Night Audit - not being able to run an End Of Day due to error: WHEN-VALIDATE-ITEM trigger raised un

edited May 8, 2019 5:09AM in Using the My Oracle Support Portal (MOSC) 1 commentAnswered

Please note that it's happened to me the same, and I did the solution  as "Night Audit - not being able to run an End Of Day due to error: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01400 (Doc ID 2192824.1)"  but still the same issue, then I realized the issue is from the  BUSINESSDATE is not updated as the current resort code, I have updated the resort code and it's work just fine as the below statement :

update BUSINESSDATE set resort='YASMOO' WHERE RESORT='CRO'

CRO: Is the Old property code

YASMOO: Is the new Property code

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center