Financial - JDE1 (MOSC)

MOSC Banner

Payment batch is errored out due to future year in payment

edited Jan 9, 2019 4:00AM in Financial - JDE1 (MOSC) 4 commentsAnswered

SELECT * FROM PRODDTA.F0413 WHERE RMPYID > '247190' and RMDMTJ >'119000' results show 

RMPYID DCT RMDOCM RMPYE RMGLBA -RMDMTJ RMICU ICUT RMDICJ RMPAAP ...

247198 _PN _88788 __17382 _65205517 208318  228953 _W  _118318  _-246752  ...

The Julian date is 208318 which is equivalent to year 2108 when it should be 2018

I am not sure if I should do a SQL query to fix the date in PRODDTA.F0413 >> RMDMTJ

Or if I should create a Fiscal year equal to 2108 in Proddta.F0008 (Company Names and Numbers)

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

E1 Financial Tags

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